Delivery Options: Attend face-to-face in the classroom, remote-live or via on-demand training.
Face-to-face or remote-live: CDN$3,275
Discounts: We offer multiple discount options. Click here for more informaiton.
Face-to-face or remote-live: 5 Days
On-demand: Approximately 35 hours of coursework with personal facilitation, to be completed in a four week span.
This Power BI / DAX 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.
Topics include an exploration of the evolution of relational databases, data warehouse and business intelligence; importing and combining 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; collaborating in the Power BI service; using DAX to solve common data modeling 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 shorter Analyzing and Presenting Data with Power BI course rather than this course.
Before attending this course, students must have:
|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
Choose a city below to view a schedule of courses. Attend regularly scheduled classes across Canada, or attend via our Remote-Live and On-Demand training options.
Copyright© Hands On Technology Transfer