Contextures

Home > Pivot > Create > Power Pivot

Power BI Resources

Here are some of the resources that you can use to learn about Power Query, Power Pivot, and other Power BI tools. New resources will be added as they are made available.

Create PivotTable

Getting Started With Power BI

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

Power BI Introduction -- Videos

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

Power BI Introduction -- Tutorials

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

The Top 30 Reasons You Should Be Considering Power BI by Matt Allington

Which to Use - Power BI or Excel? by Matt Allington

Download Power BI Desktop for Windows on Microsoft website

Power BI Guided Learning on Microsoft website

Power Query - Overview and Learning on Microsoft website

Microsoft Power BI Blog - learn about the latest updates

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 BI Webinar

This free webinar is offered by Mynda Treacy, at My Online Training Hub, a few times each year.

Click this link for more information on the webinar.

Power BI Webinar

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.

Skillwave Courses

Ken Puls, Matt Allington, and Miguel Escobar offer courses in Power BI, Power Query, Power Pivot, and Microsoft Excel.

See course details on their Skillwave website.

There's a free course too - Power Query Fundamentals. Start with that course, to see if the content and teaching style fits with what you need.

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.

Note: Debra Dalgleish is an Amazon Associate. As an Amazon Associate I earn from qualifying purchases.

Introducing Microsoft Power BI by Alberto Ferrari and Marco Russo

Applied Microsoft Power BI by Teo Lachev and Edward Price

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

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

Latest Microsoft Power BI News

These links take you to the latest Power BI news, on Google and other sites. For some pages, such as LinkedIn, you may need to sign in.

NOTE: Like other online search tools, use these at your own discretion.

More Links

Excel Tables

Unique Count with PowerPivot

Create Pivot Table in Excel 2013

PowerPivot for Excel Virtual Lab

PowerPivot from Identical Files

 

 

 

About Debra

Last updated: May 29, 2023 3:09 PM