Power BI Level 1 - Overview
During this hand-on session, you will gain an understanding of what Power BI is and what it is used for in relation to Power Query and Power Pivot. You will discover how this interactive tool can help analyse data and present it visually to help make informed business decisions.
Anyone with Database, Business Intelligence (BI), Programming, or similar experience are quite qualified to take this course, even if lacking in Excel experience.
- Overview of Power BI, Power Pivot and Power Query
- Power BI Service, Power BI Desktop and Power BI Report Server
- Various Methods of loading data
- Managing Data Relationships: the End of VLOOKUP
- Data Tables vs. Lookup Tables
Power BI Level 2 - Fundamentals & introduction to Formulas and DAX
During this hand-on session, you will learn how to work with calculations in Power BI. You will be introduced to Data Analytics Expressions (DAX) functions and what they are and why they are needed.
You should have attended the Overview of Power BI or be aware of how Power BI is being used in your business area.
- Named reference syntax
- Measures (Calc Fields) vs. Calc Columns
- COUNTROWS(), DISTINTCOUNT(), DIVIDE()
- CALCULATE function and its uses
Power BI Level 3 – Formulas and DAX
During this hand-on session, you will learn how to improve on formulas and look at further DAX function examples.
You should have attended Level 2 introduction to DAX functions.
- Debugging your formulas
- Evaluation Contexts and Context Transition
- Introduction to Time Intelligence: Date/Calendar Tables
- Running totals – Year to Date, Month to Date, Quarter to Date
- Change versus Prior Month/Year Etc.
- What-if Analysis using Disconnected Tables and Slicers