Microsoft Excel Power Query, Data Model, Power Pivot & DAX (Intro)

This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). Business intelligence (BI) is a collection of tools and processes that are used to gather data and turn it into meaningful information that people can use to make better decisions.

At the end of the 2 days training, you will be able to:

• have hands-on experience with Power Query
• Explore the Data Modeling and cover the fundamentals of database design and normalization (including table relationships, hierarchies and more)
• Use Power Pivot and DAX to explore and analyze the data model. Unlike traditional Pivot Table, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables, and create powerful calculated fields and measures using a formula language called Data Analysis Expressions (or “DAX” for short)