Analyzing Data with Power BI, DAX, and Power Query M
Duration: 5 Days
US Price: $2795 *California residents and government employees call for pricing.
This course gives students a solid understanding of data analysis with Power BI, DAX, and Power Query M. Attending this course will prepare students with the in-depth language skills needed to tackle even the toughest Data Analysis needs in Power BI.
Topics include creating visualizations, connecting to Excel files, creating a Power BI dashboard, developing reports using the Power BI desktop App, using DAX syntax, accessing data in Azure SQL Data Warehouses, and using the Power BI Mobile App and the Developer API.
Students will learn beginner and intermediate techniques for adding calculations to their Power BI Data models using DAX. Our hands-on labs provide practical exercises that cover some of the common data modelling problems that users may face, and how DAX can be used to solve those. Students will experience flattening out an OLTP database into a star schema by using DAX, resolving common granularity issues with data models, and learn how Measures can be used to solve advanced calculation problems that languages like SQL are unable to tackle.
Students will also learn about the M language that Power Query uses behind its graphical user interface, and how writing M directly can enable advanced queries against the data-sources that populate a model with its data.
Students who want Power BI training but do not need coverage of DAX and Power Query M should instead attend the Analyzing and Presenting Data with Power BI course rather than this course.
Before attending this course, students must have:
- Some prior experience working with data in Microsoft Excel, Microsoft Access, or SQL Databases
- Some exposure to basic programming constructs (such as looping and branching)
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
- Familiarity with Microsoft Office applications - particularly Excel
|Introduction to Self-Service BI Solutions
||Introducing Power BI
|Shaping and Combining Data
|Interactive Data Visualizations
|The Developer API
||Power BI Mobile App
||Basic DAX Calculations
|Advanced DAX Calculations
||DAX and Modeling
|M and Power Query
|Analyzing and Presenting Data with Power BI|
|SQL Server 2017 Reporting Services|