Excel: Power Pivot, Power Query and DAX
Discover Excel’s most powerful analytical tools
Learn how to use Power Pivot and the basics of Power Query and DAX to manage large amounts of data from multiple sources.
The Excel Advanced Level on Power Pivot, Power Query and DAX is an introduction to Excel’s most powerful analytical tools. The Excel user who works with multiple data sources and large data sets will see a significant increase in productivity and quality of reports. This level allows you to become more comfortable with the pivot table tools and turn them into interactive dashboards, as well as discovering the power of the Power Pivot extension. It is a gateway to Microsoft’s new analytical tools and new ways of managing data.
At this level, you’ll learn how to join multiple data sources to make dashboards. You will also discover how to fetch data from multiple sources and schedule manipulations of that data with Power Query. You will also get a taste of the computational power of DAX (Data Analysis Expressions) to create complex calculations that are not accessible with basic pivot tables.
This level is offered in 3 workshops of 2 hours each, online with expert instructors. It requires a commitment from the participants because of the intensity of its content, both during and between workshops. In order to stay on track, they will need to ensure that they have fully integrated the first two workshops before moving on to the third. Even if this level is demanding, the benefits it will bring are worth it and any advanced Excel user will find it worthwhile.
ARE YOU MORE THAN 7 WANTING TO TAKE THE SAME COURSE?
We offer private lessons. Contact us for more information.
WHAT YOU WILL LEARN
- Producing interactive and professional dashboards
- Joining multiple data sources with Power Pivot
- Automating the import of data tables with Power Query
- Understanding basic concepts and best practices in databases
- Using DAX metrics to generate complex calculations
TRAINING PROGRESSION
Excel: Power Pivot, Power Query and DAX
Workshop 1: Power Pivot and Dashboards
- Essential concepts and best practices in databases
- Introduction to the data model
- Joining data from multiple sources in Power Pivot
- Creating an interactive dashboard from these multiple sources
- Joining multiple sources to slicers and timelines
- Pivot charts
Workshop 2: Databases, Power Query and DAX
- Using Power Query to automate importation of and normalize data
- Understanding the different tools in Power Query to manipulate data
- In-depth understanding of table relationships and filter direction
- Basic concepts of DAX and Power Pivot measures
- Differentiating between calculated columns and DAX measures
Workshop 3: DAX measures
- Best practices for creating DAX measures
- Linking data with RELATED and RELATEDTABLE
- Aggregation DAX functions: SUMX, AVERAGEX, COUNTX, etc.
- Enhancing filtering capabilities with FILTER
- Creating versatile, reusable and powerful analyses
TESTIMONIALS FROM THE IMPROOV COMMUNITY
Excel: Power Pivot, Power Query and DAX
$497.00
- Support on workshop materials for the duration of the course
- Three 120-minute workshops