Analyzing Data with Power BI, DAX, and Power Query M
Duration: 5 DaysPrice: Contact SST for pricing.
DescriptionThis course provides a robust and in-depth introduction to Microsoft's Power BI suite of products and gives students a solid understanding of data analysis with Power BI, DAX, and Power Query M. Students will learn to use the Power BI Desktop and Power BI online service to import, analyze, and visualize business data, and to share business intelligence. In addition, students will learn beginner and intermediate techniques for adding calculations to their Power BI Data models using DAX, as well as how to use the Power Query M language to write advanced queries in order to populate a data model from external data sources.
The course starts with an exploration of the evolution of relational databases, data warehouse and business intelligence. Afterwards, students dive into topics such as the importing and combining of data from diverse data sources, shaping and transforming data, modeling data, developing useful and insightful visualizations, creating and sharing reports and dashboards in the Power BI service, and collaborating in the Power BI service. Additional topics include the use of DAX to solve common data modelling problems, how to flatten out an OLTP database into a star schema by using DAX, resolving common granularity issues with data models, and using Measures to solve advanced calculation problems that languages like SQL are unable to tackle.
Students who want Power BI training but do not need detailed 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:
- High degree of computer literacy
- Experience with office applications
- Familiarity with spreadsheet functionality
- An understating of fundamental business analysis issues such as revenue, profitability, financial accounting, and reporting
- Basic familiarity with relational databases and data warehousing is helpful but not required
|Introduction to Business Analysis
||Getting Data with Power BI Desktop
|Transforming and Shaping Data
|Types of Visualizations
|The Power BI Service
||Power BI and Programming Languages
||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|