Power BI Intermediate Training

From £400 per person - businesses only

Enquire today we have face to face and live online training available

What you will learn

  • This course is designed for those already using Power BI Desktop and are ready to work with further analytical elements of Power BI reports. The course maintains a balanced look at the different areas data analysis including the Query Editor to transform data, a deeper dive into writing DAX measures, data modelling, and enhanced dashboard visualisations.
  • The aim of this course is to go beyond the basics and explore the analytics capabilities in more depth, working with examples that will take you to the next level in your use of Power BI.

Skills you will gain

  • Shareable Certificate Earn a Cerfiticate upon completion
  • Face to Face or Live Online Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Intermediate For those with working experience or likely to have completed foundation level training
    Our assumption is you are already using Power BI and are ready to move beyond the basics. If not, we recommend attending the Power BI Introduction course first.

This course consists of 13 lessons

Lesson 1. Importing Files, Importing a database, Import vs. Direct Query vs. Live Connection, Import a folder of files, Managing imported file connections

Lesson 2. Shape Data in the Query Editor, Add a custom column, Appending tables together, Prevent tables loading in reports, Fixing error issues, Perform math calculations

Lesson 3. Merge Queries, Table join kinds, Merging tables

Lesson 4. Conditional and Custom Columns, The M functions, Adding conditional columns, Custom column formulas, Merging columns, Creating text functions, Creating IF functions, Query group folders

Lesson 5. Pivoting Tables, Pivot a table, Pivot data but don’t aggregate, Appending mismatched headers

Lesson 6. Data Modelling, Data model relationships, Marking calendar tables

Lesson 7. DAX New Columns, Creating DAX columns, The SWITCH function, Including TRUE within SWITCH

Lesson 8. Writing DAX Measures, The COUNT measures, The DIVIDE measure, DAX rules

Lesson 9. The CALCULATE Measure, Understanding CALCULATE filters, Add Context to CALCULATE with FILTER, Controlling field summarisation

Lesson 10. The SUMX Measure, The “X” iterator functions, Anatomy of SUMX, Create a SUMX measure, When to use “X” functions

Lesson 11. Time Intelligence Measures, Importance of a calendar table, Changing financial year end in TOTALYTD, Viewing date calculations in charts, Compare historical data with DATEADD

Lesson 12. Dashboard Visualisations, Utilising report themes, Filtering across dashboards, Data mining with hierarchies, Compare data in groups, Adding conditional formatting

Lesson 13. Power BI Service, Getting quick insights, What is Q&A?, Publish reports in SharePoint

Enquire today

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.