Power Pivot Workshop Beginner
4.3 (801 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12,852 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Power Pivot Workshop Beginner to your Wishlist.

Add to Wishlist

Power Pivot Workshop Beginner

Learn how to start using Power Pivot for Excel creating your own data models.
4.3 (801 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
12,852 students enrolled
Last updated 12/2014
English
Price: Free
Includes:
  • 3 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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.
View Curriculum
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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 32 Lectures Collapse All 32 Lectures 02:51:46
+
Introduction to Self-Service Business Intelligence
5 Lectures 20:50

In this module you learn the basics of Self Service BI, the new trend in building reports with Microsoft Excel. You learn the basic terminology of data warehouse, data mart and the right place of Power Pivot in the flow of data, from raw tables to exciting reports. This background theory will greatly help you learning better the next lectures.

Self-Service BI
03:51

What is Power Pivot and why millions of people are learning it? This module shows a demo of how to load data from a database and build a simple sales report.

Power Pivot
02:09

Power Query is the new exciting tool to load data from different databases. In this demo, you see how to merge the data loaded in the previous module with demographic information that you can easily find on the web. You do not need SQL skills: just point and click to load and shape the data the way you need it.

Power Query
06:13

Once data coming from your database is in Power Pivot, you can build interactive reports using Power View: the analytical tool included in Excel 2013, which makes it easy creating interactive reports.

Power View
04:42

Power Map allows you to project data on maps showing distribution of numbers over the territory, and to create animated stories about your data.

Power Map
03:55
+
Introduction to Power Pivot
7 Lectures 46:53

PivotTables in Excel are the main tool to navigate in data models created with Power Pivot. This module describes the features available in both Excel 2010 and Excel 2013. The goal is to create a solid background on what is a PivotTable, how it works and what are its limitations. In the following lectures, you learn how to overcome those limitations.

PivotTables in Excel
07:53

Excel 2013 greatly enhanced PivotTables with the introduction of the Data Model and a deeper integration with Power Pivot. In this lecture, you learn what the data model is, how to activate it, and how to start using Power Pivot.

PivotTables in Excel 2013
05:07

In this lecture, you learn how to load data in the Power Pivot window, how to create basic relationships, and how to use the Power Pivot user interface to complete basic operations.

Using Power Pivot
09:08

Calculated columns are a simple and very effective way of enriching the expressiveness of your model, by adding basic row-by-row calculations to your tables. In this lecture, you learn the basics of calculated columns: how to create and use them.

Calculated Columns
10:49

You can turn any Excel table into a Data Model table by using Linked Tables, which are a great way to enrich your model with data you prepare in Excel.

Linked Tables
05:02

Calculated fields add advanced calculations to the data model. They compute values over totals instead of computing values row-by-row, making it possible to compute percentages, distinct counts and other non-trivial calculations.

Calculated Fields
05:08

Once you complete a report, you might want to share it with other people. Power BI transforms any Excel workbook containing Power Pivot data into an interactive web-based report, so that authorized people using a web browser can see and navigate it.

Publishing to Power BI
03:46
+
Loading Data
14 Lectures 01:03:38

This lecture provides you a deeper analysis of the difference between loading data from Excel tables and loading data from data sources. You learn why it is important loading data directly into the model and what are the basic tools to use.

Loading Data in Power Pivot
04:56

A relational database accessible by using SQL queries is probably the most common data source. Here you learn the basic techniques to load data from SQL Server tables, how to connect to a relational database and load the content from available tables and views, without writing SQL queries.

Loading from SQL Tables
06:52

Even if you are not familiar with the SQL language, you can use the SQL Wizard to create custom queries that populate your data model. You just have to be aware of a few details about relationships, which you learn in this lecture.

Loading from SQL Queries
08:33

This lecture shows a few advices about importing data from Microsoft Access.

Loading from Access
04:13

If you have data stored in Analysis Services databases (also known as “Cubes”), you can import that data in Power Pivot, too. This lecture shows how to overcome a few limitations existing in importing data from SQL Server Analysis Services.

Loading from Analysis Services
07:47

You have already seen Linked Tables in a previous lecture. Now you can see more details about how they work and how to get the most out of this feature.

Using Linked Tables
04:59

If you have data stored in other Excel workbooks, you can import them in a Power Pivot data model. This lecture explains how to do that and how to avoid the most common mistakes.

Loading from Excel
03:37

This lecture described the Text File Data Source, which imports data stored in text and CSV files.

Loading from Text Files
01:23

This lecture shows how to load data from any program by using the copy and paste feature, using the Windows clipboard.

Loading from the Clipboard
04:01

You can populate a data model by loading data from Reporting Services reports in a fast and efficient way, without having to worry about the removal of formatting and graphics.

Loading from Reports
04:23

You can load data published on certain web sites (e.g. SharePoint) in Power Pivot using the data feeds. This module shows you how to import OData data feeds supported by Power Pivot.

Loading from Data Feeds
02:01

You can load data from the Azure Marketplace, where you can find data collected and sold (or provided for free) by other companies.

Loading from Azure Marketplace
03:55

In this lecture, you learn the techniques to load data from SharePoint lists, reports stored in SharePoint, and Power Pivot workbooks already published in SharePoint.

Loading from SharePoint
02:19

In this lecture, you learn how to modify the data connection automatically created by Power Pivot in order to enable automatic refresh on open, to activate periodic data updates, and to disable the automatic refresh on connection that you want to update only manually.

Data Connection Properties
04:39
+
Data Modeling
4 Lectures 38:50

Working with Power Pivot you will become a data modeler. This lecture provides the basic information about what is a data model and why modeling is important in Power Pivot.

Introduction to Data Models
12:06

What does it mean to normalize or de-normalize a model? Knowing when to denormalize is a very important skill, which is useful creating data models for Power Pivot.

Normalization and Denormalization
09:08

In modern data warehouses, the shape of data is usually a star schema. In this lecture, we introduce the concept of star schemas and explain why it is important to shape data in this way, maximizing the usability of the data model.

Star Schemas
07:11

You learn that denormalization is important, but what happens if you denormalize too much? At that point, the data model is no longer easy to use. This module introduces the concept of over denormalization and simple techniques to solve the issue, if present.

Over Denormalization
10:25
+
Conclusion
1 Lecture 00:15
Beginner Course Conclusion
00:15
+
Additional Material
1 Lecture 01:07

Instructions to download sample database and files.

Download Sample Files
01:07
About the Instructor
Marco Russo
4.3 Average rating
1,000 Reviews
13,768 Students
4 Courses
Business Intelligence expert at SQLBI - SSAS Maestro & MVP

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.

Alberto Ferrari
4.3 Average rating
1,000 Reviews
13,768 Students
4 Courses
Business Intelligence expert at SQLBI - SSAS Maestro & MVP

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.