CFI - Power Pivot Fundamentals
- Offered byCoursera
- Public/Government Institute
Power Pivot Fundamentals at Coursera Overview
Duration | 4 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
Power Pivot Fundamentals at Coursera Highlights
- Earn a certificate from Coursera
- Add to your LinkedIn profile
- 4 assignments
Power Pivot Fundamentals at Coursera Course details
- This course provides step-by-step instructions for how to set-up a business intelligence dashboard in Excel using the Power Pivot add-on
- You'll learn the key functions and best practices for setting-up a dashboard
- As you progress through the course, you'll apply everything you've learned to a hands-on example using data we provide
- By the end of this course, you'll walk away with everything you need to create your own dashboards in Excel so you can analyze and present data, track KPIs, and make your data easily accessible
Power Pivot Fundamentals at Coursera Curriculum
Course Orientation
Introduction to Power Pivot
Course Objectives
Downloadable Files
Installing Power Pivot
Download
Module 1: A Basic Data Model
Module Introduction
Tables in Our Data Model
Database Normalization
Fact and Dimension Recap
Opening the Starter File
Importing Data into Power Pivot
Power Pivot Overview
Create a Basic Pivot Table
Create a Relationship in Power Pivot
Types of Relationships
Power Pivot Table Review
Insert a Slicer
Module 2: Basic Measures
Chapter Introduction - Basic DAX Measures
Opening and Refreshing the Partially Completed Course File
Two Common Problems When Refreshing Data
Creating an Explicit Measure
Hiding Columns from the Excel View
Creating a Calculated Column for Store Size
Updating the Dashboard and Slicer
Calculating Margin Dollars
Calculating Sales with SUMX
Comparing Methods of Creating Measures
Calculating Margin %
A Closer Look at DAX
More Examples of Context
Week 1 Challenge
Module 3: Working with a Star Schema
Chapter Intro - Working with a Star Schema
The Star Schema
Copy a Pivot Table
Adding the Product Dimension
Add a Pivot Table for Brands
Format Measures
Managing Multiple Slicer Connections
The Datetime Dimension
Tidying the Diagram View
Creating a Pivot Chart
Creating a Slicer to Chart Connections
Removing Autosizing Based on Slicer Selections
Chart Formatting Overview
Changing the Sort Order of Months
Adding a Timeline
Setting up the Basics of the Store Performance Dashboard
Linking Slicers Between Report Pages
The Manager Dimension - Dealing with Duplicates
Load and Transform Data in Power Query
Load data from Power Query to Data Model
Setting up the Manager Pivot Table
Week 2 Challenge
Module 4: From Number to Narratives
From Numbers to Narratives
DAX % of Total
Best Practice for Naming Metrics
DAX Time Intelligence - SalesPY
DAX Time Intelligence - Sales Vs PY
Dashboard Consistency
Conditional Formatting in Pivot Tables
Create a KPI in Power Pivot
Modify KPI Icons in Power Pivot
Finishing Touches
Task - Finalize the Store Dashboard
Review - Pivot Table Layout
Review - Advanced Table Sort
Module 5: Extended Practice
Big Wings Competitor Analysis
Big Wings Dashboard Review
Course Conclusion
Course Summary
Download & Review
Week 3 Challenge - Part 1
Week 3 Challenge - Part 2
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?