Contextures

Power BI Resources

Here are some of the resources that I have used while learning about Power Pivot and other Power BI tools. I will add new resources, as I find them

Getting Started With Power Pivot

There are videos and written tutorials to help you get started with Power Pivot

Power Pivot Introduction -- Videos

In the window below, you can watch a Getting Started in Power Pivot playlist that I compiled on YouTube.

_____________________________

Power Pivot Introduction -- Tutorials

These tutorials cover the basics of getting started with Power Pivot..

Online Courses

These courses use video lessons to demonstrate the Power BI techniques, tools and formulas.

Power Pivot for Excel Course

This course is offered by Mynda Treacy, at My Online Training Hub

The Power Pivot for Excel Course includes 5.5 hours of video tutorials covering everything from installing Power Pivot, importing data, DAX formulas, PivotTables and more. Download the sample files, and follow along with the lessons.

In this hands-on project-based course, you will build a Power Pivot model from start to finish. The training is delivered online and tutorials are available to watch 24/7 at your own pace. Pause, rewind, replay as many times as you like.

Watch this sneak preview, to see a sample of the course material, then click here for more information.

Advanced Excel & Power Pivot Training Classes

This course is offered by Chandoo, at Chandoo.org

  • Combine the Advance Excel and Power Pivot courses into one bundle, to save money, or take either course separately. The Power Pivot course will take you from the basic steps, up to intermediate level in skills.
  • This course includes access to student forums, where you can ask questions, and discuss the lessons with other students in the course
  • Sample workbooks can be downloaded, to follow along the lessons

In this video, Chandoo introduces Power Pivot, and shows how to set up linked tables in Excel. This will give you an idea of his teaching style, before you decide to enroll in the Advanced Excel & Power Pivot Training course.

Power Pivot University

This course is offered by Rob Collie, at PowerPivotPro.com

  • This course covers the basics briefly, then moves on to intermediate and advanced Power Pivot formulas and techniques. There are 19 hours of video instruction, sample workbooks, Rob Collies DAX Formulas book, and a handy reference card.
  • If you are an absolute beginner with Power Pivot, go slowly through the first few lessons, to ensure that you understand the basics, before going forward. The course is packed with valuable content, and it can be overwhelming if you go too fast.
  • There are no student forums, but you can click a link to send a question to the instructor.
  • Download the sample files to follow along with the lessons.

Here is one of the video lessons from the Power Pivot University course:

Power Query Training

Excel's new Power Query add-in can do amazing things with your data.

If you'd like to learn more about it, experts Ken Puls and Miguel Escobar have launched a new website, where they will offer live, online Power Query training. You'll have two days of live online training (4 hours per day), then a live follow-up Q&A session, about a week later.

power query training

Power BI Books

These books will take you from the beginner stage, into the advanced levels of Power Pivot and Power Query. Most links will take you to the Amazon website, where you can read the review, and use the "Look Inside" feature, to examine the book, before buying it.

Excel Power Pivot and Power Query For Dummies, by Michael Alexander

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query by Ken Puls and Miguel Escobar -- Click the Read Preview button below, to see a preview of the Kindle version

Dashboarding and Reporting with Power Pivot and Excel by Kasper de Jonge

PowerPivot Alchemy: Patterns and Techniques for Excel by Bill Jelen, Rob Collie

Microsoft Excel 2013: Building Data Models with PowerPivot by Alberto Ferrari and Marco Russo

PowerPivot for the Data Analyst: Microsoft Excel 2010 by Bill Jelen

DAX Formulas for PowerPivot by Rob Collie

_________________________________

Related Tutorials

Excel Tables

Unique Count with PowerPivot

Create Pivot Table in Excel 2013

PowerPivot for Excel Virtual Lab

PowerPivot from Identical Files

Search Contextures Sites

 

Excel Tools Add-in

Free Pivot Table Tools

 

Pivot Power Premium

 

Excel Data Entry Popup List

 

 

 

Excel UserForms for Data Entry

 

Last updated: September 20, 2016 7:45 PM
Contextures RSS Feed