Duration: 5 Days
Discounts: We offer multiple discount options. Click here for more info.
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 in-depth language skills necessary 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 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 shorter Analyzing and Presenting Data with Power BI course rather than this course.
Before attending this course, students must have:
|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
Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.
Copyright© Hands On Technical Training