Power BI Master Class - Data Modeling and DAX Formulas |
This course is presented by Ian Littlejohn - who with over 45 000 students is one of the most popular 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.
Please note that this course is the second course in a series of three courses for the Power BI Master Class series:
- Course 1 - Consume and Transform Data
- Course 2 - Data Modeling and DAX Formulas
- Course 3 - Visualizations and The Power BI Service
In this second course - Data Modelling and DAX Formulas using Microsoft Power BI Desktop you will learn:
- Introduction and Course Content
- Creating Calculated Columns - Basic calculations, using date fields and date tables
- Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Calculated Tables and Time Intelligence
- Creating Relationships between tables and using relationship calculations
- Using KPIs visualizations in the data model
- Creating and using hierarchies
This course aligns to the outcomes of the Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. The Microsoft MCSA BI Reporting is a valuable certification for every Excel and Power BI user. The certification consists of two exams. Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. Ian has created a series of courses that will assist all users to prepare for these exams.
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.
Who this course is for:
- Excel users who want to learn how to create professional reports in Power BI
- Learners who want to prepare themselves for Microsoft Exam 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
- Get the course