Power Pivot and Power Query Essentials
Introducing Power Pivot
If you house your data in tables, you may find limits in your ability to analyze it comprehensively. Excel can help. Power Pivot creates a structured data model in Excel similar to a database, turning it into a self-service business intelligence platform. In this course, you’ll explore how it can add value to your analysis.
Intermediate    15 Lessons    120 Minutes    CPD Credits
About This Course
There is only so much insight you can retrieve from a basic table of a data. In this course, you’ll learn how to perform powerful data analysis and create sophisticated data models using Power Pivot.
Across 15 lessons, you’ll explore the important features of the Excel data model, and show you how to create Pivot Tables and Pivot Charts using one.
By the end of the course, you’ll know how to boost your analysis, expand your range of insights, and save time in the process.
Learning Outcomes
-
Load data to the Power Pivot data model
-
Explore the data model using the Power Pivot interface
-
Create relationships between tables in Power Pivot
-
Create calculated columns and measures
-
Create Pivot Tables and Pivot Charts from Power Pivot data
-
Update the data in the data model
Lessons
1. Overview and Installation
2. Loading Data to the Excel Data Model Part 1
4. Q&A - Loading Data to Power Pivot
5. Data View and Diagram View
6. Relationships
Read More
7. Q&A - Relationships and Viewing Tables
8. Calculated Columns
9. Measures
10. Q&A - Calculated Columns and Measures
11. Creating a PivotTable from Power Pivot Data
12. Creating a PivotChart from Power Pivot Data
13. Adding Slicers to PivotTables and PivotCharts
14. Updating the Data Model
15. Q&A - PivotTables, PivotCharts, and Refreshing Data
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.