What will attendee learn?
Part 1
– Relationship Mechanics & Data Modeling
• Understanding Relationships in Power BI and their nuances.
• Filter Propagation using One to Many Relationships.
• Filter Context in Multiple Related Tables.
• What is Data Modeling and why is it so important
– Quiz

Part 2
– Case Studies – Solving Problems with Data Modeling (and minimal DAX)

• Cast Study 1 – Staff Rotation – This is an excerpt of a staff rotation problem for a large financial institution with upwards of 50,000 employees.
– The Problem – The financial institution needs to either change the location or job role of the employee at regular intervals to minimize fraud.
– The Case – We’ll be required to flag employees which are nearing a location or job role change. And of course, our calculations need to be simple and fast.

• Case Study 2- Budget Allocations – A commonly found problem is to analyze budget numbers along with actual sales data.
– The Problem – Understanding equal and proportionate budget allocations and allocations based on last year.
– The Case – Rather than writing sophisticated DAX, we’ll work with modeling approaches to creatively solve tough allocation problems.

• Case Study 3 – Events in Progress (the classic from and to problem)
– The Problem – A commonly found pattern in datasets which captures From and To dates and you need access to all the dates in between that period.
– The Case – Again, we’ll solve events in progress problem by shaping the data rather than writing complex DAX.

Ideal Audience
• This is NOT beginner level training. Instructor won’t teach you what is Power BI, what is Power Query & DAX etc..
• Ideal for people who have already dabbled with Power BI and want to build a strong foundation on Data Modeling and a bit of DAX.

Recommended attendee
✔Data Analysts ✔Business Analysts ✔Business Intelligence Professionals ✔Business Professionals ✔Excel Users ✔Power BI Users ✔Students
✔Learning Enthusiast

Masterclass duration
Masterclass Length : 2 days x 4 hours per day
Date : 08th September 2022 & 09th September 2022
Time : 09:00 to 13:30 hrs – Azerbaijan Time (GMT +4)

Click here for speaker info