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 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
If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on telephone etiquettes, communication and behaviours.
If you want your employees to improve their customer service skills and deliver an amazing experience to your customers, feel free to check out my Training course focusing on delivering the best customer care.
Reliability Centred Maintenance (RCM) is commonly used to help establish safe minimum levels of maintenance, determine changes to operating procedures and help establish maintenance regimes and plans. Successful implementation can result in cost savings, machine uptime and improved risk management. But the devil's in the detail - how can you achieve these benefits and successfully implement RCM in your organisation? This programme will help you do just that. Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. To provide a better understanding of RCM, particularly: What, why, how and who? Opportunities and benefits Risks Cost effectiveness Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. 1 What is maintenance? Why maintain? Traditional maintenance methods Common current practices and trends 2 What is Reliability Centred Maintenance? Its history Its development Current usage Where can it be cost-effective? 3 How does it work? Basic features Key criteria Maintenance options Key outcomes 4 Making the business case and preparing the strategy Identifying and quantifying current risks Identifying and quantifying current costs Motivating decision-makers Identifying and empowering those who have to deliver the results Educating / gaining buy-in from interested parties 5 Implementation Identify business functions Prioritise functions Verify correct usage Identify failure modes Identify the consequences of failure Understand the failure process Specify the appropriate maintenance action(s) 6 Ongoing requirements Monitoring Recording Analysis Continuous re-evaluation 7 Open discussion Sharing experience and addressing specific issues of interest to participants Course review Close
The aim of this course is to expose the commercial context within which technical work is carried out. It is to allow technical staff to understand how they fit into a larger picture, why they may be asked to undertake tasks that may not appear to be technical and the impact their interactions have within the commercial context. The scope of the programme includes: The course emphasises the collaborative nature of delivery and the need to offer value to customers. The principal training objectives for this programme are to help participants: Understand why technical roles are broader than we might assume Appreciate the importance of, and the need to support, sales Value the idea of 'Good Enough' Recognise what can affect profitability Realise the future needs protecting 1 Introduction (Course sponsor) Why this programme has been developed Review of participants' needs and objectives 2 That's not my job! How we see our own role in work How other people see our role Stakeholders: who are they and why do they matter? The organisational backdrop What is my role really? 3 Sales and marketing Where does the money come from? Where do we find customers? The sales process One-off sales versus repeat business Customer/supplier relationships What something costs versus what the customer will pay The value chain 4 Estimating Purpose of estimates The problem with precision Five estimating techniques 5 Change control Can you just do this for me? When being helpful leads to bankruptcy How to deal with change requests 6 Risk management Risk in projects Risk in operations Categories of risk 7 The value of intellectual property Issues with sharing information Commercial in confidence Non-disclosure agreements 8 Course review and action planning (Course sponsor present) Identify actions to be implemented individually What actions should be implemented to improve working with non-technical people? Conclusion
Overview Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing. Objectives By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization
This programme provides an intensive, two-day overview of the key elements of operations management, including an array of practical tips and tools to help managers be more proactive and effective in the operations management environment - whether that's in an industrial manufacturing context or in operational leadership in the service sectors. At the end of the programme, participants will: Understand the 6Cs approach to operations management Be able to apply a range of practical tools and techniques to improve their personal effectiveness towards being a more effective operations manager Be able to prepare an action plan for the critical first (or next) 100 days in their operational leadership role 1 Introduction What is Operations Management and where does it fit in? What makes a successful Operations Manager? Introducing the 6Cs of Operations Management 2 Context Link to business strategy Making a year plan Performance measurement 3 Controls Governance Reputational controls Costs and budgets Quality Operational 4 Customers Internal External Stakeholder management 5 Communication Planning Meetings Reporting Emails Notices Networking Walking the talk 6 Care People Safety, Health, Environment & Security Assets 7 Continuous improvement Process Product Proactivity Link to KPIs and Year Plan 8 Putting it all together Action planning for the first (or next) 100 days Conclusions