Learn how to start using Power Pivot for Excel creating your own data models.

What Will I Learn?

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 is the target audience?

• Advanced Excel Users
• Business Analysts
• Business Intelligence Developers
• Data Scientists