Excel 2016 PowerPivot, PowerMap, PowerQuery, PowerView & BI

Enter the sizzling hot world of BI, Power Pivot, DAX, and big data. Excel 2016 Power Tools are a total game changer!
4.4 (94 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.
851 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 51
  • Length 5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

This course takes up where the Optima Train Excel 2016 Pivot Tables and Pivot Charts course leaves off. It all revolves around the fairly new suite of Microsoft “Power” tools, often referred to as Power BI. The course has three primary themes. First, it teaches you a number of methods for importing data (from a database, text files, or other sources) into Excel. The primary emphasis is on Power Query. Second, it devotes considerable time to the Excel Data Model and Power Pivot for analyzing data with pivot tables. These take traditional pivot tables to a whole new level. Third, it shows how Power View and Power Map can be used to create insightful reports and maps with very little work.

***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****

***** CLEAR AND CRISP VIDEO RESOLUTION *****

***** COURSE UPDATED: February 2016 *****

“When I first looked up this site I was a bit skeptical, but I soon realized how amazing these courses are. They have helped me excel in all my business classes. The PowerPivot course now makes business analytics easy and at my fingertips." - Wilson Xu, STUDENT

“The Optima Train two part series on Pivot Tables is pure gold! The material is so amazingly thorough and clear that anyone watching the videos and doing the exercises provided will without a doubt become a true expert at working with Pivot Tables and likely become a hero at work by applying and sharing this new-found knowledge. There is nothing like it on the market." - Phil, FORMER TREASURY OPERATIONS MANAGER - EXXONMOBIL

99.9% of Excel users do not use PowerPivot but those that do are in elite company. Power Pivot allows end users with no business intelligence or data analytics training to develop data models and calculations. The tide has shifted where the knowledge worker can perform analysis on millions of records without using specialized IT software or the help of business intelligence consultants. Learning PowerPivot and DAX will take your Excel skills to the very top. People who know Pivot Tables and Pivot Charts should take the next logical step and learn a skill set that is in very high demand and in short supply. Become an indispensable resource at your work place. Simplify your work and personal life by learning this extremely powerful tool.

This is the most comprehensive Excel PowerPivot and Advanced Business Intelligence course and has 47 short video tutorials. The Pivot Tables and Pivot Charts course serves as a prequel to this highly valuable course. There is zero fluff and no time wasted in this course. The instructor, Dr. Chris, has decades of experience using Excel in real-world settings solving complex business problems. There is no quicker way to learn Excel PowerPivot than to watch these videos and follow along with the free companion exercise workbooks which are downloadable. If you want to stand out among your colleagues, earn a promotion, further your professional development, save tons of hours every year, and learn Excel PowerPivot and Advanced Business Intelligence Tools in the quickest and simplest manner then this course is for you!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.

We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you're not 100% satisfied, we will gladly refund the full purchase amount!

Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…

What are the requirements?

  • Microsoft Office 2016 (Professional Plus or higher)

What am I going to get from this course?

  • An understanding of how the four components of Microsoft’s Power BI suite (Power Query, Power Pivot, Power View, and Power Map) work together to provide amazing data analysis possibilities, all within Excel
  • How to import data from various data sources into Excel, both with older tools and the newer Power Query tools, with emphasis on the latter
  • An understanding of the relationship between the Excel Data Model and Power Pivot
  • An understanding of how Power Pivot adds significant power to Excel’s existing data analysis tools
  • How to use the Power Pivot user interface, and how to create pivot tables with Power Pivot
  • How to use the DAX language in Power Pivot to create calculated columns and measures, and why DAX is so powerful
  • How to create named sets, hierarchies, and KPIs (key performance indicators) with Power Pivot
  • How Power View and Power Map can be used to create insightful reports and maps with very little work

What is the target audience?

  • Any competent Excel users who want to be on the leading edge with Excel’s latest and most powerful data analysis tools

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Course
Welcome to Excel 2016 Power Pivot and Advanced BI Tools Course
Preview
04:04
How to download Exercise Files and Handouts
Article
REMINDER: Turn on HD
1 page
Section 2: Power Query and Other Tools for Importing Data
Overview of Importing Data into Excel and Power Query
Preview
03:53
Introduction to Relational Databases
07:22
Introduction to Queries
07:09
Introduction to Power Query
Preview
03:32
Power Query User Interface
08:44
More Power Query Possibilities
10:13
Importing Data from the Web
04:17
Using Microsoft Query
06:31
Importing Azure DataMarket Data
04:19
Section 3: Power Pivot for Analyzing Data
Overview of Pivot Table Technologies
03:49
Introduction to OLAP
07:06
Understanding the Excel Data Model Versus Power Pivot
03:28
Pivot Tables Based on a Data Model 1
08:25
Advantages of the Excel Data Model over Regular Excel Pivot Tables
02:44
Advantages of Power Pivot over the Excel Data Model
02:50
Migrating to Power Pivot for Excel 2016
Preview
02:36
Help in Power Pivot
02:05
Power Pivot User Interface
05:16
Getting Data into Power Pivot
05:51
Creating Relationships in Power Pivot
07:42
Building Pivot Tables in Power Pivot
07:13
More on Building Pivot Tables in Power Pivot
06:46
Working in Data View in Power Pivot
04:16
Introduction to DAX in Power Pivot
07:20
Learning about DAX Functions
05:09
Creating Calculated Columns with DAX
08:16
Using the RELATED and RELATEDTABLE Functions
06:00
Whether to Denormalize an Excel Data Model
06:03
Creating Measures with DAX
07:49
One Huge Benefit of DAX Measures
04:21
Understanding Pivot Table Evaluation
07:25
Many-to-Many Relationships in Power Pivot
05:09
Counting Distinct Values in Power Pivot
06:39
Using the CALCULATE Function 1
07:46
Using the CALCULATE Function 2
08:39
Using Date Functions in Power Pivot
06:46
Using a Parameter Table in Power Pivot
05:47
Hierarchies in Power Pivot
06:47
Named Sets in Power Pivot
06:38
KPIs in Power Pivot
05:30
Cube Functions in Power Pivot
04:23
Section 4: Power View and Power Map for Creating Reports
Introduction to Power View
04:02
Power View User Interface
06:15
More Power View Possibilities
09:57
Introduction to Power Map
05:26
Power Map User Interface
08:42
More Power Map Possibilities
05:12
Section 5: Conclusion to Course
Conclusion to Power Pivot and Advanced BI Tools Course
02:19

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Optima Train, Practical Training for Today's Knowledge Worker

Optima Train is a US-based training company using cutting-edge adult learning methodology to make our customers more effective in the workplace.

Optima Train has the most comprehensive coverage of content created by experts with deep knowledge of how applications are used in the workplace.

We are intricately linked to our customers. While most training companies have a tool-centric approach that leads to relatively low knowledge retention, Optima Train has a results-oriented approach.

Ready to start learning?
Take This Course