course
Power Pivot, Power Query and DAX in Excel
Simon Sez IT
Updated Jan 23, 2025
What you'll learn
- Initiate Power Query for efficient data transformation and connect Excel seamlessly to multiple workbooks for unified data access.
- Retrieve data from the web and diverse sources with Power Query.
- Merge and append queries seamlessly using Power Query techniques.
- Navigate the Power Pivot window with confidence and proficiency.
- Establish and manage relationships adeptly within a data model.
- Construct dynamic PivotTables showcasing Power Pivot data model insights.
- Implement calculated columns using DAX for enhanced data analysis.
- Apply DAX functions, CALCULATE, DIVIDE, DATESYTD, for powerful calculations.
- Create compelling Pivot Charts and PivotTables, leveraging your data model.
- Utilize slicers to refine and customize the displayed dataset effectively.
Course Description
In this advanced-level course, you will explore three crucial features in Excel: Power Pivot, Power Query and DAX. This suite of functions allows you to manipulate, analyze and evaluate millions of rows of data from Excel or other databases. If you've reached a point where you need Excel to work with data at scale, then these tools will unlock that capability.
Upon completion of this course, you will know how to bring your data together, then merge and clean it using Power Query. As you proceed to creating relationships between data tables and building out a data model, you will then be able to perform calculations using DAX, and finally display your analysis using PivotTables and PivotCharts.
