Who is this training for?

This training is designed for Power BI Developers, Data analysts, Power BI architects, Data architects, BI Developers, and anyone who is building or designing a Power BI solution or implementation. You don’t need to know about Power Query, M, or DAX to attend this training. However, a general basic understanding of Power BI will be helpful, although it is not mandatory. Regardless of your role with the Power BI solution, you will need to understand and learn modeling and development best practices for Power BI to ensure the Power BI model you develop can be the most useful, with minimum maintenance required, and the best-performing model for analytics.

This is not a course about visualization in Power BI. It is focused on modeling, transformations of the data, and calculations in Power BI, but the outcome of this will lead to a proper visualization of course.

What is included in the training?

We have 6 days of Power BI modeling content and agenda in the Power BI from Rookie to Rock Star program that we have taught throughout many years to users worldwide. We collected the most common and the most important parts of that agenda into a 3-day course program to be a good reference for anyone who wants to master Power BI development. This course has a combination of the most important learnings for Power BI development.

In this training, you will learn about Power BI modeling, from the star schema dimensional modeling to the fundamentals of relationships in Power BI; you will learn Power Query transformations and how to use functions and parameters alongside M scripting, then you will learn DAX and some of the most important formulas with the concepts of evaluation context, time intelligence functions and the most common calculations and how to solve challenges, then some of the design patterns of building a Power BI model for patterns such as budget vs. actual or inventory model and some other useful models such as ticketing will be explained.

This training is focused on teaching you the most important parts of Power BI development from a modeling perspective. The course focuses on modeling and relationship principles, Power Query, DAX, and calculations.

At the end of this training, you will be able to build the best possible model in Power BI, transform the data into the shape needed for that dimensional model, and write calculations using DAX language with a good understanding of how the language of calculation works and solve real-world modeling and calculations challenges in Power BI.

What will attendees receive after this training?

• All data files related to demos and examples
• The Handout of the training
• Certificate of completion
• Digital copies of the books used as a reference for this course
• Access to the video course for the subjects related to this course

Your Instructor: Reza Rad

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker, and Consultant. He has a BSc in Computer engineering and more than 20 years of experience in data analysis, BI, databases, programming, and development, mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 14 continuous years (from 2011 till now) for his dedication to Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of the Difinity conference in New Zealand, the Power BI Summit (the biggest Power BI conference), and the Data Insight Summit (Chicago, USA). Reza is the author of the only Power BI Architecture book.

• CEO at RADACAD
• Chairman and Director at Power BI Summit
• Chairman and Director at Difinity conference (Since 2017)
• Microsoft Regional Director (Since 2018)
• Microsoft Data Platform MVP (Since 2011)
• Leader of Power BI user group in Auckland, New Zealand (Since 2013)
• Microsoft Fast Track Recognized Solution Architect – Power Platform
• Power BI All-Star award winner
• Dynamic Communities Emerald award winner
• Best-selling author of more than 12 books on BI, analytics, and Power BI
• Speaker at many conferences such as Ignite, Microsoft Business Applications Summit, PASS, etc.
• Blogger and content creator
• Consultant and trainer
• Microsoft Certified trainer
• Microsoft Certified Professional

His articles on different aspects of technologies, especially on BI, can be found on his blog: https://radacad.com/blog.

He wrote some books on Microsoft BI and also is writing some others. He was also an active member of online technical forums such as MSDN and Experts-Exchange, was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the co-leader of the New Zealand Business Intelligence users group. He is also the author of the very popular book Power BI from Rookie to Rock Star, free with more than 1700 pages of content, and the Power BI Pro Architecture published by Apress and more than ten other Power BI Books.

He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday, and user groups. And He is a Microsoft Certified Trainer.

The training includes but is not limited to the topics below:

Table of contents:

The training includes but is not limited to the topics below:

1. Power BI Modeling (0.5 days)
   • Dimension tables
   • Fact tables
   • Star schema and how to build it
   • Relationships in Power BI, cardinality, direction of relationship, and examples of it.
   • Modeling best practices
2. Power Query (1 day)
   • Combining tables (merge and append)
   • Merge types
   • Table transformations
   • Pivot and Unpivot
   • Group by and aggregations
   • Custom Functions and Parameters
   • generator functions
   • M scripting and formula
   • Error handling in Power Query
   • Dataflow
3. DAX (1 day)
   • Calculations in Power BI
   • Evaluation context (filter context and row context)
   • Scalar VS Tabular functions
   • Filter functions: ALL, AllSelected …
   • Calculate
   • Sum VS SUMX
   • Variables
   • Debugging DAX calculations
   • Time Intelligence
   • Dynamic DAX: Parameters
   • Path and Hierarchical functions
   • Table functions
4. Design Patterns (0.5 days)
   • Customer retention
   • Inventory stock on-hand
   • Subscription or ticketing
   • budget vs. actual
   • Row-level security

Timing each day:

• 8:30 am to 9:00 am – Registration and setup
• 9:00 am to 10:30 am – Course
• 10:30 am to 11:00 am – Morning Tea
• 11:00 am to 12:30 am – Course
• 12:30 am to 1:30 pm – Lunch
• 1:30 pm to 3:00 pm – Course
• 3:00 pm to 3:30 pm – Afternoon Tea
• 3:30 pm to 5:00 pm – Course
• 5:00 pm to 5:30 pm – Wrap up and closing

Direction, Parking, and Accommodation Guide (TBD)

5-Star feedback from attendees

Here are what some of our attendees think of our courses;

• Enthusiastic and intense, it’s been an incredible three days, covering all important aspects of Data engineering, Data warehousing, Integration, Data governance, and Fabric best practices. From hands-on lab exercises to ad hoc discussions, we’ve dived deep and explored every facet of the Fabric landscape.
• The course was very helpful to deepen more into the Power BI capabilities and its use cases, seeing different solution alternatives, and strengthen the knowledge we already have in some topics.
• I liked the training a lot. It was a very interactive session – good level of overview around PowerBI Architectures, mixed with right level of deeper dives. Reza was always open and approachable to adjust the agenda and answering questions relevant to the audience. I enjoyed switching between presentation and Live-demos, which made the content easy to understand and remember.
• Reza is very knowledgeable in MS tech stack and some of the questions he answered went beyond just the fabric usage in a more holistic and practical view from his experiences. It was one of the best engaging trainings I have attended in years and would definitely recommend anyone looking to learn Fabric architecture and workloads to attend this brilliantly designed course.
• I thoroughly enjoyed the Microsoft Fabric training. The content was well-structured and relevant, providing a deep dive into essential topics. Reza was an outstanding trainer, whose enthusiasm and deep knowledge made the learning process both effective and enjoyable. His practical examples and hands-on approach greatly aided in understanding the complexities of Fabric. I leave this course better equipped and confident in applying these new skills in my work. Highly recommend!
• I really enjoyed the training. I learned a lot. Reza has the ability to convey information well and takes the time for questions.
• The course was quite informative and filled up gaps in understanding MS Fabric platform. Now we have clearer strategy what is the best way to use the platform.
  Thank you! Great job!

Change or cancellation policy:

Cancellation requests must be submitted in writing. All cancellation requests received at least 45 days before the beginning of the course are entitled to a refund, minus a processing fee – please inquire by email at training@radacad.com for the exact amount. Cancellation requests received between 45 and 15 days before the conference start date are entitled to a 50% refund minus a processing fee. No refunds will be given to registrants who cancel less than 15 days before the beginning of the conference or who fail to attend the conference.

Substitutions for paid registrants may be made only with another attendee approved by the RADACAD. Written notice is required, and for complete accuracy, it must include all pertinent changes for the substituting attendee. Substitutions are allowed until seven days before the course start date. Substitutions are not allowed less than seven days before the course start date.

In the unlikely and rare event that the course gets canceled, all paid registrants will give a full refund. RADACAD will not refund any other amount paid by registrants to other companies, including and not limited to travel expenses and hotel reservations.