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 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 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 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 and registration options. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.
Copyright© Hands On Technology Transfer