Data Analysis with Excel's Power Pivot
4.0 (1 rating)
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 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Analysis with Excel's Power Pivot to your Wishlist.

Add to Wishlist

Data Analysis with Excel's Power Pivot

Learn how to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.
4.0 (1 rating)
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 students enrolled
Last updated 11/2016
English
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.
  • Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
View Curriculum
Requirements
  • To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables.
Description

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amountsof data quickly. 

Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources.

You will: 

  • Get started with Power Pivot.
  • Visualize Power Pivot data. 
  • Work with advanced functionality in Power Pivot. 


Who is the target audience?
  • People taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Getting Started with Power Pivot
4 Lectures 14:37

In Excel, you don't have access to Power Pivot unless you enable it.

Preview 00:23

Power Pivot is an add-in built by Microsoft that you can use to create sophisticated relationships among various data sources and perform powerful data analysis. (Power Pivot, Excel Add-Ins, The Power Pivot Tab, The Power Pivot Window, Navigating the PowerPivot Window)

Enable and Navigate Power Pivot
04:26

Before you can analyze and report on your data, you must first get the data into Power Pivot to work with it.

Preview 03:06

For reporting to be accurate and function well, you must prepare the data for analysis by setting up relationships among tables and creating hierarchies. (The Excel 2016 Data Model, Data Sources, The Table Import Wizard, Diagram View, Relationships, Hierarchies)

Manage Data Relationships
06:42
+
Visualizing Power Pivot Data
4 Lectures 10:34

Learn how to create a Power Pivot report and a Chart using the data in the Data Model.

Create a Power Pivot Report - Introduction
00:16

Viewing rows and rows of data in disparate tables is exhausting, and it is nearly impossible to make any sense out of it. Data becomes meaningful only when you create a report, because you are able to organize and manipulatethe data in ways that you can better analyze. (PivotTables, The PivotTable Fields Task Pane, PivotCharts, Power Pivot Report Options, The Create Report Dialog Box, Quick Explore, Slicers, The Report Connections Dialog Box)

Create a Power Pivot Report
05:07

With Power Pivot, you can create new columns and fields by performing calculations.


Preview 00:28

Once you have created a Power Pivot report, there may be additional information that you want to analyze, but that you don't have already in the Data Model. With Power Pivot, you can create new columns and fields byperforming calculations with much more flexibilty than in Excel. (Calculated Columns, Calculated Fields, Explicit Calculated Fields, The AutoSum Feature) 

Create Calculations in Power Pivot
04:43
+
Working with Advanced Functionality in Power Pivot
2 Lectures 06:10

Excel provides a way to measure performance in your data with key performance indicators.

Preview 00:44

In Power Pivot, key performance indicators (KPIs) are visual measures of performance - a great solution if you need to measure the performance of data against a target. (Key Performance Indicators (KPIs), The KPI Dialog Box, The Manage KPIs Dialog Box)

Create a Key Performance Indicator
05:26
+
Work with Dates and Time in Power Pivot
5 Lectures 25:18

Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)

Work with Dates and Time in Power Pivot - Part 1
03:05

Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)

Work with Dates and Time in Power Pivot - Part 2
04:19

Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)

Work with Dates and Time in Power Pivot - Part 3
04:40

Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence, (Data Analysis Expressions (DAX), DAX Syntax, Time Intelligence)
Work with Dates and Time in Power Pivot - Part 4
04:31

Month over Month (MOM) or Year over year (YOY) is a common method of evaluating two or more measured events to compare the results at one time period with those of a comparable time period. Learn how to create these valuable comparisons.

Preview 08:43
+
Quiz
0 Lectures 00:00
Quiz
5 questions
+
Course Follow-Up
1 Lecture 01:13

You have completed the Microsoft®Office Excel 2016: Data Analysis with Power Pivot course. What's next?

Course Follow-Up
01:13
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.4 Average rating
358 Reviews
6,231 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.