Udemy

Power Pivot Workshop Beginner

Learn how to start using Power Pivot for Excel creating your own data models.
Free tutorial
Rating: 4.2 out of 5 (2,645 ratings)
53,994 students
2hr 50min of on-demand video
English
English [Auto]

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

Instructors

Business Intelligence expert at SQLBI - SSAS Maestro & MVP
  • 4.5 Instructor Rating
  • 2,934 Reviews
  • 55,106 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
  • 4.5 Instructor Rating
  • 2,934 Reviews
  • 55,106 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.

Top companies trust Udemy

Get your team access to Udemy's top 30,000+ courses