Power Pivot Workshop Beginner

Power Pivot Workshop Beginner, available at Free, has an average rating of 4.2, with 32 lectures, based on 2598 reviews, and has 52984 subscribers.

You will learn about By the end of the course, you will be able to create simple models in Power Pivot, loading data from different data sources. This course is ideal for individuals who are Advanced Excel Users or Business Analysts or Business Intelligence Developers or Data Scientists It is particularly useful for Advanced Excel Users or Business Analysts or Business Intelligence Developers or Data Scientists.

Enroll now: Power Pivot Workshop Beginner

Summary

Title: Power Pivot Workshop Beginner

Price: Free

Average Rating: 4.2

Number of Lectures: 32

Number of Published Lectures: 32

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Advanced Excel Users
Business Analysts
Business Intelligence Developers
Data Scientists

Target Audiences

Advanced Excel Users
Business Analysts
Business Intelligence Developers
Data Scientists

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.

Course Curriculum

Chapter 1: Introduction to Self-Service Business Intelligence

Lecture 1: Self-Service BI

Lecture 2: Power Pivot

Lecture 3: Power Query

Lecture 4: Power View

Lecture 5: Power Map

Chapter 2: Introduction to Power Pivot

Lecture 1: PivotTables in Excel

Lecture 2: PivotTables in Excel 2013

Lecture 3: Using Power Pivot

Lecture 4: Calculated Columns

Lecture 5: Linked Tables

Lecture 6: Calculated Fields

Lecture 7: Publishing to Power BI

Chapter 3: Loading Data

Lecture 1: Loading Data in Power Pivot

Lecture 2: Loading from SQL Tables

Lecture 3: Loading from SQL Queries

Lecture 4: Loading from Access

Lecture 5: Loading from Analysis Services

Lecture 6: Using Linked Tables

Lecture 7: Loading from Excel

Lecture 8: Loading from Text Files

Lecture 9: Loading from the Clipboard

Lecture 10: Loading from Reports

Lecture 11: Loading from Data Feeds

Lecture 12: Loading from Azure Marketplace

Lecture 13: Loading from SharePoint

Lecture 14: Data Connection Properties

Chapter 4: Data Modeling

Lecture 1: Introduction to Data Models

Lecture 2: Normalization and Denormalization

Lecture 3: Star Schemas

Lecture 4: Over Denormalization

Chapter 5: Conclusion

Lecture 1: Beginner Course Conclusion

Chapter 6: Additional Material

Lecture 1: Download Sample Files

Instructors

Marco Russo
Business Intelligence expert at SQLBI – SSAS Maestro & MVP
Alberto Ferrari
Business Intelligence expert at SQLBI – SSAS Maestro & MVP

Rating Distribution

1 stars: 31 votes
2 stars: 86 votes
3 stars: 421 votes
4 stars: 933 votes
5 stars: 1127 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu