Introduction to Self-Service Business Intelligence
  • Self-Service BI
  • Power Pivot
  • Power Query
  • Power View
  • Power Map
Introduction to Power Pivot
  • PivotTables in Excel
  • PivotTables in Excel 2013
  • Using Power Pivot
  • Calculated Columns
  • Linked Tables
  • Calculated Fields
  • Publishing to Power BI
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
Data Modeling
  • Introduction to Data Models
  • Normalization and Denormalization
  • Star Schemas
  • Over Denormalization
Conclusion
  • Beginner Course Conclusion
Additional Material
  • Download Sample Files