• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1996 Courses in Manchester

Professional Customer Care

By Dickson Training Ltd

Any team member with Customer interaction (including internal) are the 'Ambassadors' of the company/organisation. If they project positive professionalism - they win others' confidence. If they appear or sound like they are in any way indifferent or unprofessional - they will cost sales and lose clients/customers. With this 2 day Training course, that will be tailored to your company/organisation, each person attending will upgrade their professional standards in people skills, telephone manner and email etiquette. No training in this area may well be a false economy as there is a much greater risk of disenfranchised customers and team members - and probably increases your competitors to win business at your expense. Professional customer care is all too frequently regarded as a token issue in most induction sessions for employees. Surprisingly it is very rarely considered as a key priority, despite being essential for ensuring customer commitment is secure and supplier/partnerships are robust. Excellent customer care is paramount in our ever increasingly competitive market and making customers feel valued and looked after is often a differentiator. This 2-day course will help you understand your customers and the vital importance of customer care in any organisation. You will gain the tools and techniques to apply your learning directly back into the workplace and deliver excellent customer care. Course Syllabus The syllabus of the Professional Customer Care course is comprised of four modules, covering the following: Module One What is Excellent Customer Care? Internal versus external customers Why customer care is important Meeting customer expectations Module Two Making a Personal Difference How do you measure customer care? Making a difference Taking ownership Positive mental attitude Displaying professionalism both face-to-face and over the telephone Using positive language Module Three Gathering Information and Offering Solutions Asking the right questions Active listening skills Summarising and clarifying skills Module Four Dealing with Difficult Situations How to give a 'service' no Demonstrating empathy Assertiveness techniques Handling a complaint Problem solving Saying 'sorry' Making realistic promises and keeping them Real Play Scenarios with a Professional Actor (Optional Extra) This programme benefits significantly from our innovative training feature: Real Play. Using a professional actor who performs role plays as different customer characters in carefully devised situations, the delegates have the opportunity to 'pause' the role play to coach and control their character to improve their skill sets and practice the theory delivered. These scenarios can deal with difficult situations and enacting options to ensure good customer relations are intact. The outcome of the scenario is the responsibility of the delegates, not the trainer and actor. The actor will remain in character throughout the de-brief in order to bring to life the impact and possible next steps. Objectives By the end of the course participants will be able to Adopt a professional telephone manner Communicate assertively by taking control and directing the conversation Deliver information positively by offering options and alternatives Develop a range of versatile behaviours to use when dealing with difficult situations by: Listening actively Using empathy Gathering relevant information through effective questioning Finding solutions to concerns/problems quickly and efficiently Speaking positively and assertively What Is The Benefit? For individuals this course will increase confidence and ability to deal with customers in all situations, which will in turn create customer loyalty and raise their profile. For an employer, ensuring that all customer facing employees are demonstrating excellent customer care instils confidence in the customers and promotes a positive image of the company. In-House Courses Every single team member or employee that has a role which involves engaging with a customer, client and/or a key partner/supplier has a responsibility for projecting a positive image of the organisation which they represent. That may sound obvious, but how many hundreds of experiences have you had as a customer where you were treated with indifference and a distinct lack of professionalism by the receptionist, the retail assistant, the tele-agent, the delivery person, the credit controller or the departmental manager of the operation that you were dealing with? Far too many to count? This is because professional customer care is regarded as a token issue in most induction sessions for employees - and it is very rarely considered as a key priority to ensure customer commitment is secure and supplier/partnerships are robust. Yet the hugely expensive churn in customer/client commitments and staff is enormously expensive and immensely disruptive to any organisation. The Importance of Customers and Clients Every client/customer engaging person needs to recognise that it is ultimately the client or customer that pays their wages. If they gain a basic understanding of the clients' motivations and behaviours, coupled with some core skills in how to care for them, they will attain the status of 'professional'. This will very quickly translate into increased revenues, retained loyalty, high commitment and far greater security for all parties. The foundation has to be based on the authentic commitment to both the customer and also to the organisation they work for. Disenfranchisement readily curdles into sloppy behaviours cloaked in unprofessional attitudes and demeanours; plenty there to repel the most loyal of customers. If your company or organisation relies on repeat business and retaining the confidence and commitment of your clients, then all of your team members - perhaps including managers who set the example and have the biggest influence on the where the needle points to in relation to professionalism - need to be trained on the core basics of professional customer care. Customer Care Programmes from Dickson Training Ltd We are delighted to boast about the many successes we have had in providing effective and long lasting improvements for many clients, where awards have been won and, more importantly, talent has been retained because their clients and customers keep on coming back. Professional customer care extends to suppliers and partners that you value and need to get the best service and rates from, as well as any 'internal clients' such as other departments where you need to rely on their support and collaboration in order to achieve your goals. It is amazing what effective professional customer care training can do for any organisation. Without it your organisation may be vulnerable, with it you are much more likely to see increased performances and much greater security and growth. 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.

Professional Customer Care
Delivered In-Person in Bardsey + 3 more or UK WideFlexible Dates
Price on Enquiry

CDM 2015 - Understanding and achieving best practice (In-House)

By The In House Training Company

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

CDM 2015 - Understanding and achieving best practice (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Specification writing (introduction) (In-House)

By The In House Training Company

This intensive one-day training programme has been developed to help those involved in producing specifications create high quality documents in an organised and effective way. The programme explains the primary purpose of specifications and the importance of understanding the context in which they are used. It focuses particularly on how to develop and structure content and write requirements that are clear and concise. The methods and techniques presented will provide a practical foundation course for those new to the topic whilst offering new insights to those with more experience. The objectives of the workshop are to: Review and discuss the role and purpose of specifications Present a structured approach for organising and producing specifications Explain each of the key steps involved in creating effective specifications Review some methods for assisting in defining requirements Explain how to define the scope and develop the structure for a specification Present methods to assist the writing and editing of specifications Review how specifications should be issued and controlled 1 Introduction Course objectives Review of participants' needs and objectives 2 Specifications in perspective The role and purpose of specifications The impact of specifications on commercial performance The qualities of an effective specification The five key steps of 'POWER' writing: prepare-organise-write-edit-release 3 Step 1: Preparing to write Defining the purpose the specification; integrating the specification and contract Deciding how to specify: when to specify in functional and technical terms Getting the right people involved at the right time; engaging stakeholders Applying procedures for writing, issuing and controlling specifications 4 Step 2: Organising the specification content Scoping the document: scope maps, check lists, structured brainstorming Clarifying requirements; separating needs and desires Dealing with requirements that are difficult to quantify Useful techniques: cost benefit analysis, Pareto analysis Deciding what goes where; typical contents and layout for a specification Creating and using model forms: typical sections and sub sections 5 Step 3: Writing the specification Identifying and understanding the readers needs Choosing and using the right words; dealing with jargon Important words; will, shall, must; building a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity 6 Step 4: Editing the specification Why editing is difficult; how to develop a personal editing strategy Key areas to review: structure, content, accuracy, clarity, style and grammar Editing tools and techniques 7 Step 5: Releasing and controlling the specification Key requirements for document issue and control Final formatting and publication issues; document approval Requirements management: managing revisions and changes 8 Course review and action planning What actions should be implemented to improve specifications? Conclusion

Specification writing (introduction) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

CDM 2015 - Understanding and achieving best practice (In-House)

By The In House Training Company

This course provides participants with a comprehensive understanding of the requirements of the CDM Regulations 2015 and how these should be implemented in practice. The Regulations are put in context with other key health and safety legislation. The programme sets out clearly the roles and responsibilities of the principal duty holders and explores with the participants how these roles may vary on different types of project and procurement routes. The programme examines the content and appropriate level of information that should be included in the Pre-Construction Information and the Construction Phase Plan. The trainer will discuss best practice in implementing CDM through the new 2015 Regulations and Guidance. This course is essential for anyone who is involved in the procurement, planning, design or implementation of construction work. The course will provide you with: An overview of construction health and safety law, liability and enforcement A detailed understanding of the 2015 CDM Regulations and the part they play with other key legislation An explanation of the roles and responsibilities of all duty holders and the requirements for the CDM documentation Clear advice on current best practice for complying with the principles of the CDM Regulations and the changes introduced by the 2015 Regulations An understanding of how risk assessment should be applied practically throughout the design and how this responsibility is then transferred to contractors 1 Introduction Why manage health and safety? The costs of accidents Construction industry statistics Why CDM? Health and safety culture in the construction industry 2 Overview of health and safety law and liabilities Criminal and civil law Liability Enforcement and prosecution Compliance - how far do we go? Statutory duties 3 Health and safety law in construction Framework of relevant legislation Health and Safety at Work etc Act 1974 Management of Health and Safety at Work Regulations 1999 Construction (Design and Management) Regulations 2015 Who is responsible for the risks created by construction work? Shared workplaces/shared responsibilities Control of contractors - importance of contract law 4 Construction (Design and Management) Regulations 2015 Scope - What is construction? Application - When do they apply? The CDM Management System Duty holders (Client, Domestic Client, Designer, Principal Designer, Principal Contractor, Contractor) Documents (HSE Notification, Pre-Construction Information, Construction Phase Health & Safety Plan, H&S File) Management process The 2015 Guidance 5 Best practice - key issues in the CDM process The client and client management arrangements Competence and resource under CDM 2015 The role of the Principal Designer in practice Design risk assessment and the role of the Designer The CDM Documents (PCI, PCI Pack, Plan and File) Construction health, safety and welfare Making CDM work in practice 6 Questions, discussion and review

CDM 2015 - Understanding and achieving best practice (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Credit control training 'menu' (In-House)

By The In House Training Company

This is not a single course but a set of menu options from which you can 'pick and mix' to create a draft programme yourself, as a discussion document which we can then fine-tune with you. For a day's training course, simply consider your objectives, select six hours' worth of modules and let us do the fine-tuning so that you get the best possible training result. Consider your objectives carefully for maximum benefit from the course. Is the training for new or experienced credit control staff? Are there specific issues to be addressed within your particular sector (eg, housing, education, utilities, etc)? Do your staff need to know more about the legal issues? Or would a practical demonstration of effective telephone tactics be more useful to them? Menu Rather than a generic course outline, the expert trainer has prepared a training 'menu' from which you can select those topics of most relevance to your organisation. We can then work with you to tailor a programme that will meet your specific objectives. Advanced credit control skills for supervisors - 1⁄2 day Basic legal overview: do's and don'ts of debt recovery - 2 hours Body language in the credit and debt sphere - 1⁄2 day County Court suing and enforcement - 1⁄2 day Credit checking and assessment - 1 hour Customer visits and 'face to face' debt recovery skills - 1⁄2 day Data Protection Act explained - 1⁄2 day Dealing with 'Caring Agencies' and third parties - 1 hour Debt counselling skills - 2 hours Elementary credit control skills for new staff - 1⁄2 day Granting credit and collecting debt in Europe - 1⁄2 day Identifying debtors by 'type' to handle them accurately - 1 hour Insolvency: Understanding bankruptcy / receivership / administration / winding-up / liquidation / CVAs and IVAs - 2 hours Late Payment of Commercial Debts Interest Act explained - 2 hours Liaison with sales and other departments for maximum credit effectiveness - 1 hour Suing in Scottish Courts (Small Claims and Summary Cause) - 1⁄2 day Telephone techniques for successful debt collection - 11⁄2 hours Terms and conditions of business with regard to credit and debt - 2 hours Tracing 'gone away' debtors (both corporate and individual) - 11⁄2 hours What to do if you/your organisation are sued - 1⁄2 day Other topics you might wish to consider could include: Assessment of new customers as debtor risks Attachment of Earnings Orders Bailiffs and how to make them work for you Benefit overpayments and how to recover them Cash flow problems (business) Charging Orders over property/assets Credit policy: how to write one Council and Local Authority debt recovery Consumer Credit Act debt issues Using debt collection agencies Director's or personal guarantees Domestic debt collection by telephone Exports (world-wide) and payment for Emergency debt recovery measures Education Sector debt recovery Forms used in credit control Factoring of sales invoices Finance Sector debt recovery needs Third Party Debt Orders (Enforcement) Government departments (collection from) Harassment (what it is - and what it is not) Health sector debt recovery skills Hardship (members of the public) Insolvency and the Insolvency Act In-house collection agency (how to set up) Instalments: getting offers which are kept Judgment (explanation of types) Keeping customers while collecting the debt Late payment penalties and sanctions Letter writing for debt recovery Major companies as debtors Members of the public as debtors Monitoring of major debtors and risks Negotiation skills for debt recovery Old debts and how to collect them Out of hours telephone calls and visits Office of Fair Trading and collections Oral Examination (Enforcement) Pro-active telephone collection Parents of young debtors Partnerships as debtors Positive language in debt recovery Pre-litigation checking skills Power listening skills Questions to solicit information Retention of title and 'Romalpa' clauses Sale of Goods Act explained Salesmen and debt recovery Sheriffs to enforce your judgment Students as debtors Statutory demands for payment Small companies (collection from) Sundry debts (collection of) Terms and Conditions of Contract Tracing 'gone away' debtors The telephone bureau and credit control Taking away reasons not to pay Train the trainer skills Utility collection needs Visits for collection and recovery Warrant of execution (enforcement)

Credit control training 'menu' (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Selling through service (In-House)

By The In House Training Company

In today's fast-moving competitive environment, sales are often made or lost on the strength of a telephone conversation or a brief email. This means that not only is customer service everyone's responsibility - so is sales. Customer service staff are failing the customer if they don't think about sales. And sales staff are failing customers if they don't think about service. And anyone failing a customer is failing both themselves and their employer. Too often, customer service staff feel neither capable nor empowered to recognise or capitalise upon a sales opportunity. Too often, sales people pursue the short-term opportunity at the expense of the bigger picture. The good news is - it doesn't have to be this way! Sales and customer service skills can be acquired, developed and polished just like any other skill. This tried-and-tested programme shows you how to do it. As a result of this course, participants will be able to: Take control of a customer conversation, with confidence Refresh and polish their customer service and sales performance Recognise and develop a sales opportunity Engage the customer and build rapport Identify a customer's needs Match the customer's needs to the organisation's products or services Handle objections confidently Ask for the order At the end of the workshop each participant will have developed their own action plan for developing and using their skills in the workplace. 1 Introduction Course overview, objectives and introductions 2 Serving or selling? Feelings and attitudes - How we can affect the outcome by our feelings and behaviour What is selling? - Selling is helping people to buy, identifying the opportunities that exist within the conversation to develop the customer's interest in our products or services 3 Developing the right skills Communication- The impact of body language, voice tone and words- How to make the best impression on the customer and create a 'buying environment' Rapport-building- What makes a good working relationship?- What do customers look for when they call us?- How can we match their expectations in terms of our own interpersonal skills? Relating to different types of people by identifying and matching their communication style on the telephone 4 Making it easy for the customer Starting it right- Opening the conversation positively- Building rapport- How to develop interest in our products or services Gaining and clarifying information- Questioning skills and questioning style- What do we need to know from the customer?- How can we use that information in the conversation? Active listening- The most under-rated skill of all- Picking up on the 'Golden Moments' when a customer shows they may be interested Presenting information confidently- Knowing the benefits of our products or services- How to tell the customer what they need to know in order to enable them to buy Closing on a positive note- When and how to ask for commitment Dealing with the customer's objections and concerns in a positive manner 5 Course summary and action plans Review of main learning points Presentation of personal action plans

Selling through service (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Managing with NLP (In-House)

By The In House Training Company

Self-understanding is a prerequisite for leading and managing others responsibly and honourably. The field of Neuro Linguistic Programming has helped us to gain a better insight into how we all think and behave. Upon completion of this course participants will be able to: Gain an insight into the purpose and functions of the unconscious mind Develop flexibility to increase their for behaviours in different circumstances Appreciate how different people experience the world Create and set effective goals and direction Understand the NLP Model of Communication Adapt their communication style to maximise effectiveness Influence and persuade others by connecting with people Understand how empowerment can make life easier Appreciate how creativity works Learn creativity techniques to tap into the power of the team 1 Self-awareness Autopilot - your unconscious mind Developing flexibility How identify, values & beliefs shape our behaviour Models of the world 2 Creating direction Describing present and desired state Designing your direction Making it happen Self-mastery 3 Communication The NLP Model of Communication Insights to the way people think Understanding representation systems Reframing the way people think about negative experiences Using metaphor 4 Influence and persuasion Building trust Connecting with people Purpose intention and outcomes The difference empowerment makes 5 Creativity and innovation Hindrances to creativity and innovation Your natural state of creativity Getting unblocked Creativity techniques 6 Action plan Course summary and presentation of action plans

Managing with NLP (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

The project management toolkit (In-House)

By The In House Training Company

The aim of this course is to provide project managers, project engineers and project support staff with a toolkit they can use on their projects. The tools range from the simple that can be used on all projects to the advanced that can be used where appropriate. This programme will help the participants to: Identify and engage with stakeholders Use tools for requirements gathering and scope management Produce better estimates using a range of techniques Develop more reliable schedules Effectively manage delivery DAY ONE 1 Introduction Overview of the programme Review of participants' needs and objectives 2 Stakeholder management Using PESTLE to aid stakeholder identification Stakeholder mapping The Salience model Stakeholder engagement grid 3 Requirements management Using prototypes and models to elucidate requirements Prioritising techniques Roadmaps Requirements traceability 4 Scope management Work breakdown structures Responsibility assignment matrix 5 Delivery approaches Sequential Agile 6 Estimating Comparative estimating Parametric Bottom-up Three-point estimating Delphi and Planning Poker Creating realistic budgets DAY TWO 7 Scheduling Critical path analysis Smoothing and levelling Timeboxing Team boards Monte Carlo simulations Probability of completion 8 People management Situational Leadership The Tuckman model Negotiation Conflict management Belbin 9 Monitoring and control Earned value management 10 Course review and action planning Identify actions to be implemented individually Conclusion PMI, CAPM, PMP and PMBOK are registered marks of the Project Management Institute, Inc.

The project management toolkit (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

The professional project manager (In-House)

By The In House Training Company

The aim of this programme is to provide current / prospective senior project managers with an in-depth review of the role and importance of project management in the organisation. It focuses on the strategic role of the project manager and aims to draw out the full scope of the role and how it impacts on project performance. The five key objectives of this programme are to enable the participants to: Identify the characteristics and attributes needed by project managers in ensuring the organisation is recognised as an industry leader in delivering successful projects Understand the full scope and impact of the project manager / leader's role in managing projects or programmes to maximise benefit to the business Define the hallmarks and skills required to manage significant business projects or project portfolios Develop an understanding of the skills required and their impact on the project through case study work and syndicate exercises Benefit from an effective forum for exchanging experience and fostering a sense of team spirit and mutual support between senior project managers DAY ONE 1 Introduction (Course sponsor) A vision of future opportunities and challenges The impact of project managers / leaders on future success 2 The determinants of success The contractor's perspective The client's perspective Success and failure: factors that determine the project outcome The impact of the project manager 3 Case study: Project Giotto How successful was this project? What were the primary factors that influenced the outcome? How relevant are these factors to current projects? Feedback and review 4 Project team exercise A practical exercise demonstrating the role of the project manager in managing the interfaces between the client, the project team and suppliers Review - what skills are required to be a 'world class' project manager? 5 The role of the Project Manager The role and skills of the 'world class' project manager The three key dimensions of effective project leadershipManaging influential stakeholdersManaging project performanceManaging the project team Project leadership skills appraisal (individual review) DAY TWO 6 Managing influential stakeholders Project management and the art of leadership Who are the influential stakeholders and how do they affect the project? What we need to do / not do, to build successful working relationships 7 Case study: Understanding the customer What are the likely problems the project manager will encounter? What should the project manager do to ensure an effective partnership? 8 Managing project performance Issues affecting commercial performance Joining up the project life-cycle: getting performance from inception to closure The roles of project manager, line manager and project sponsor 9 Project team exercise: Making the promise / delivering the promise An exercise demonstrating the commercial and team leadership skills needed by the project manager Review - what must the project manager do to optimise project performance? 10 Managing multi-functional project teams The challenges of building effective, multi-functional project teams Co-ordinating work across functional and organisational boundaries Maintaining strategic focus and balancing priorities 11 Making it happen Individual action planning Syndicate discussion 12 Course review and transfer planning (Course sponsor present) What will we do differently? How will we make it happen? Conclusion

The professional project manager (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

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

Power BI - introduction to intermediate (2 days) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry