Power Pivot Workshop Beginner

Learn how to start using Power Pivot for Excel creating your own data models.
Rating: 4.3 out of 5 (2,070 ratings)
39,985 students
Power Pivot Workshop Beginner
Rating: 4.3 out of 5 (2,070 ratings)
39,985 students
By the end of the course, you will be able to create simple models in Power Pivot, loading data from different data sources.

Requirements

  • Power Pivot for Excel 2010 or Excel 2013
Description

The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics.

The course includes almost 3 hours of video in 30 lectures. You do not need any previous experience in Power Pivot to take this course.

Sections included in this course:

  • Introduction to Self-Service Business Intelligence
  • Introduction to Power Pivot
  • Loading Data
  • Data Modeling

After this course, we suggest you to take the Power Pivot Workshop Intermediate one.

Who this course is for:
  • Advanced Excel Users
  • Business Analysts
  • Business Intelligence Developers
  • Data Scientists
Curriculum
6 sections • 32 lectures • 2h 51m total length
  • Power Pivot
  • Power Query
  • Power View
  • Power Map
  • PivotTables in Excel
  • PivotTables in Excel 2013
  • Using Power Pivot
  • Calculated Columns
  • Linked Tables
  • Calculated Fields
  • Publishing to Power BI
  • 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
  • Introduction to Data Models
  • Normalization and Denormalization
  • Star Schemas
  • Over Denormalization
  • Beginner Course Conclusion
  • Download Sample Files

Instructors
Business Intelligence expert at SQLBI - SSAS Maestro & MVP
Marco Russo
  • 4.3 Instructor Rating
  • 2,344 Reviews
  • 41,077 Students
  • 4 Courses

Marco is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe.

Marco is also a book author and wrote two books for Microsoft Press about Power Pivot with Alberto Ferrari: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits.

Business Intelligence expert at SQLBI - SSAS Maestro & MVP
Alberto Ferrari
  • 4.3 Instructor Rating
  • 2,344 Reviews
  • 41,077 Students
  • 4 Courses

Alberto is a Business Intelligence consultant and mentor. He has been working with Analysis Services since 2005 and with Power Pivot since first beta versions in 2009. He split his time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe.

Alberto is also a book author and wrote two books for Microsoft Press about Power Pivot with Marco Russo: Microsoft Excel 2013: Building Data Models with PowerPivot and PowerPivot for Excel 2010: Give Your Data Meaning. He is also a speaker at international conferences such as Microsoft TechEd, PASS Summit, SQLRally, and SQLBits.