Power BI Master Class - Data Modeling and DAX Formulas

Course details

Recent reviews:

"Really good crash course for Power BI. If you are just started to use Power BI and want to quickly go through the basic I highly recommend this course."

"Awesome. Focused and wll explained!"

"The course is very well structured and at the right pace. There is a very clear explanation as to what is the goal of every section and how it is accomplished. I would definitely recommend the course for anyone starting with PBI."

**** Lifetime access to course materials and practice activities.  100% money back guarantee ****

This course is presented by Ian Littlejohn - who with over 50 000 students is one of the most popular & highly rated instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn how to perform data modeling and use DAX formulas to get the most out of Microsoft Power BI.

In this class (the second module of my 3 part "Power BI Master Class" Series), you will cover:

1. Introduction and Course Content

2. Creating Calculated Columns - Basic calculations, using date fields and date tables

3. Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Calculated Tables and Time Intelligence

4. Creating Relationships between tables and using relationship calculations

5. Using KPIs visualizations in the data model

6. Creating and using hierarchies

The prized Microsoft MCSA BI Reporting Certification consists of 2 exams; Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. This course aligns to the outcomes of the Microsoft exam 70-778.  Please see my Excel Master Class Series for content that aligns to Exam 70-779. 

Even, if you are not preparing for the exam you will find these courses a valuable resource to learn the most important and powerful features of Microsoft Power BI and Excel.

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI.

Please note that this course is the second course in a series of three courses for the Power BI Master Class series.  Search for my instructor profile to purchase these other courses.

1. Course 1 - Query Editor

2. Course 2 - Data Modeling and DAX Formulas

3. Course 3 - Dashboards and Power BI Service