Highlights
- DAX
- Data modelling
Course Details
DAX
DAX Basics review
Table Functions
Evaluation Contexts o Filter and Row Context o CALCULATE
Evaluation Contexts and Relationships
Time Intelligence Calculations
DAX as a Query Language: use of DAX Studio
Advanced Table Functions
Advanced Evaluation Context DAX (Understanding Cross filters)
Calculations over Hierarchies
Parent/Child Hierarchies
Creating Dynamic titles
Using parameter table
Capturing and debugging queries with Dax Studio
Data modelling
Creating a Bridge Table
Role Playing Tables with DAX
Role Playing Tables without DAX
Mismatched Granularies
Who should attend
Business Analysts, Financial Analysts, Data Scientists and Staff who already use Power BI or who have attended our introduction course and who need to explore its features in more depth. Developers and Super Users/ Power Users looking to get more out of Power BI
Learn to build Dashboards like this - Typically used for CFO Dashboards, Revenue & Profitability, Expense Management, Financial Planning & Analysis, Sales, Stock Control, Risk & Compliance Analysis...
Feedback
4.8 out of 5 average
"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022