This workshop will help you improve the impact, clarity, accuracy and effectiveness of your sales proposals. It takes bid and proposal teams right through the process, from start to finish - from forming the team and gathering the information, through to writing and reviewing the proposal document, and on to presenting it to the client. The learning points shared in the programme come from the trainer's extensive real-world experience with a wide variety of businesses. As a result of attending this programme, participants will be able to: Write more clearly, more grammatically and more persuasively Structure their written communications more effectively Avoid the 'howlers' that can cost you business Impress your clients Win more business 1 Bid strategy How to combine your knowledge of the market or customer, your products and services, and your competitors, to create a quality bid New insights into your comparative advantages and competitive position in the marketplace Understanding more about how your client views you and other suppliers A plan of attack to build on your strengths and attack the weaknesses of your competition Dealing with RFP/ITT situations 2 Teamwork How a bid or proposal team needs to prioritise and manage preparation time Co-ordinating input from team members Agreeing responsibilities 3 The importance and role of a well-written sales proposal Why bother? - the value of the sales proposal to you and to the customer What the customer wants and needs to make a decision in your favour Understanding and delivering on customer expectations Review and discussion of different proposals - with real-life examples 4 The best way to structure your sales proposals A section-by-section, page-by-page review of best practice in structuring great sales proposals How to improve the way you match your proposal to the customer's objectives and requirements Plan your sales documents systematically - to make them easy to read and more persuasive How to make your proposal look like the 'least risky' option 5 Making your proposal a compelling and persuasive proposition Choosing the right words that sell effectively Selecting the right content and information for your document or proposal Using an option matrix to summarise complex choices and increase final order value How to write an executive summary 6 Well-written and error-free Developing your writing style for maximum impact Expressing the content (ie, selling points) clearly, concisely and correctly Proof-reading and editing work effectively, using formal marks and techniques Improving visual layout, format and appearance Keeping it customer-focused 7 Presenting to the client - overview Presentation options Understanding the client's objectives - as well as your own The proposal review meeting - logistics Managing to the next step Designing and delivering a compelling presentation Isolating objections and concerns Follow-up and follow-through 8 Positioning your final proposal Finalising your bid - presenting the right 'best few' USPs, features and benefits and making them relevant and real to the customer Smart ways to position price and be a strong player - without being the cheapest How to differentiate yourselves by how you present, as well as what you present How to design and deliver a successful bid presentation 9 Bid presentation practice session with structured feedback Participants work in small groups or pairs to prepare and later present a sample section from a real life bid or proposal presentation The trainer will provide assistance and input During group review and discussions, input from others will be encouraged and many best practice ideas summarised 10 Managing the end game How best to draw-out, understand, isolate and answer customer objections, negotiate points and concerns How to read the situation to plan the next step Identifying negotiation tactics - and how to deal with them Planning for a negotiation and how to get the customer feel they have the 'best deal' 11 Workshop summary and close
One of our greatest strengths is our ability to tailor any of our open management courses to the needs and requirements of different businesses in different industries. We understand that whilst our open management training courses provide a wealth of knowledge in their particular area of focus, not all of it may be relevant for your business and the particular industry you operate in.Rather than making delegates sit through management training that is irrelevant to their job role, we offer bespoke management training where we tailor the course to cover the specific needs of your organisation, ultimately relieving the inevitable boredom and "switching off" that would come with having to sit through training that a person knew they would not need. Why choose us for your bespoke management training needs? We have provided tailored, bespoke management training courses to some of the largest organisations in the UK. Using our acquired experience and knowledge of running these courses, we will be able to work with you to create a bepoke management training programme that delivers a significant return on investment, both in terms of tangible and intangible results. ILM accredited management training courses Because we charge a daily training rate rather than a per delegate fee, if you have a number of delegates requiring management training, a bespoke management training course can often be less expensive than putting them all on an open course. A number of courses have been accredited by the ILM, which means you can be assured as to the standard of the course content and delivery. For more information on these, please see our page on ILM Management Training. All of our ILM Programmes are provided in partnership with BCF Group Limited, which is the ILM Approved Centre we deliver under. Interested in finding out more about bespoke management training? Between us, we can come up with a training plan which will provide relevant, bespoke management training for your delegates which will maximise the return on both your time and cost. We are happy to come to your premises or arrange training facilities nearer to your location if this would be more convenient. Feedback Below is a small selection of past feedback for our management training and development courses and programmes: "Excellent instructor. I looked forward to our monthly lectures knowing that I would have a good laugh but also that I would learn more about the subject and myself. He has been very helpful to me and the rest of the students, not just during the lectures but often in his own time. His enthusiasm for all of the subjects covered during the course was evident throughout, which again helped me to enjoy and understand the subjects and lectures. If I get the chance in future to attend a further course with you, I would jump at the chance."Senior Acquisitions SurveyorGalliford Try "A very accomplished trainer and someone who I would very much like to be involved in our business training going forward. The feedback I have had from all levels of our team structure is excellent."Group HR OperationsEADS Personnel Services UK "Phil has a lot of energy which he throws into the course. This visably broke down resistance and attendees entered into the exercises wholeheartedly."Senior QSBullock Construction Scheduled Courses Unfortunately this course is not one that is currently scheduled as an open course, and is only available on an in-house basis. Please contact us for more information.
This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint
This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson
There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups
Polycom Handsets and Voicemail Soft Client Horizon Collaborate Desktop and Mobile App Receptionist Console Integrator Agent Client Supervisor Client Akixi Reporting Horizon Contact Agent Horizon Contact Supervisor Horizon Contact Admin User Web Portal User Admin Portal
Handset and/or Voicemail Training 1600’s, 1400, 96/95 series handsets, J Series and Voicemail Workplace Attendant Console and One-X Attendant Console One-X Portal and Video Soft phone / One X Communicator One-X Mobile/ Preferred Mobile IX Workplaces and Mobile App Agent and CMS Supervisor ASA – Avaya Site Administrator Tool AACC Administrator, Supervisor and Agent
78, 79, 88 and 99 series Handsets & Voicemail Cisco Call Manager (CCM) & Self Care Portal Jabber WebEx Meetings WebEx Training Centre WebEx Events Centre Attendant Console Standard and Advanced Console (ARC) UCCX/UCCE and Finesse Agent & Supervisor CUIC Reporting
Handset and/or Voicemail Training 1600’s, 1400, 96/95 series handsets, J Series and voicemail One X Communicator One-X Mobile IX Workplace Desktop and Mobile App Web Conferencing Collaboration System Administration Training up to Release 11 Voicemail Pro Administration Training ACCS Agent, Supervisor and Administration Training XIMA/CHRONICALL/ACR Agent, Realtime, Recording and Reporting