Power Pivot Workshop Beginner

Description

In this course, you will :

• By the end of the course, you will be able to create simple models in Power Pivot, loading data from different data sources.​​​​​​

Syllabus :

1. Introduction to Self-Service Business Intelligence

• Self-Service BI
• Power Pivot
• Power Query
• Power View
• Power Map

 

2. Introduction to Power Pivot

• PivotTables in Excel
• PivotTables in Excel 2013
• Using Power Pivot
• Calculated Columns
• Linked Tables
• Calculated Fields
• Publishing to Power BI

 

3. Loading Data

• Loading Data in Power Pivot
• Loading from SQL Tables
• Loading from SQL Queries
• Loading from Access
• Loading from Analysis Services
• Using Linked Tables
• Loading from Excel
• Loading from Text Files
• Loading from the Clipboard
• Loading from Reports
• Loading from Data Feeds
• Loading from Azure Marketplace
• Loading from SharePoint
• Data Connection Properties

 

4. Data Modeling

• Introduction to Data Models
• Normalization and Denormalization
• Star Schemas
• Over Denormalization

Show more