Home > Data > Get Data > Power Pivot

Power BI Resources

Here are some of the resources that you can use to learn about Microsoft Power Query, Power Pivot, and Power BI. With this trio of tools, you can effectively gather, analyze, and communicate your data-driven insights.

Create PivotTable

Power BI, Power Pivot, Power Query

Together, these three tools from Microsoft help you work with data efficiently, perform complex analysis, and present your findings in a compelling and interactive way.

Here's a quick summary of what the 3 tools do:

  • Gather: Power Query helps you gather, organize, and clean your data
  • Analyze: Power Pivot allows you to analyze, connect, and model your data
  • Present: Power BI helps you present and share your data analysis

Getting Started With Power BI

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

Power BI a business intelligence tool that helps you visualize and share your data in interactive and visually appealing dashboards and reports.

With Power BI, you can create impressive charts, graphs, and maps that allow you to explore and understand your data easily.

Power BI Introduction -- Video

In the video below, Kevin Stratvert presents an introduction to Microsoft Power BI, in a step-by-step tutorial.

Video Timeline:

  • 00:00 Introduction
  • 01:01 Download and install
  • 03:00 Welcome screen
  • 04:20 Sample data overview
  • 06:00 Get data spreadsheet
  • 07:40 Transform data from spreadsheet using Power Query Editor
  • 10:10 Get data from web
  • 11:25 Transform data from web using Power Query Editor
  • 13:10 Join tables by merging queries
  • 14:27 Overview of Power BI layout, including fields and visualizations
  • 16:40 Insert title
  • 17:20 Insert variety of visualizations
  • 22:10 Insert slicer
  • 23:30 Apply theme and change style
  • 25:00 Save and Publish report
  • 26:30 Share with others
  • 27:05 Wrap up

Power BI Introduction -- Tutorials

These written 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 is a data modeling tool that allows you to combine, relate, and analyze large amounts of data from different sources, to create insightful and meaningful analysis.

With Power Pivot, you can create relationships between different pieces of information, dig deeper into the connections, and uncover hidden patterns and insights.

Power Pivot Introduction -- Video

In the video below, Kevin Stratvert presents an introduction to Microsoft Power BI, in a step-by-step tutorial.

Video Timeline:

  • 0:00 Introduction
  • 1:23 Enable Power Pivot add-in
  • 3:05 Sample files overview
  • 4:06 Create data model
  • 8:55 Define relationships
  • 12:13 Calculations
  • 16:02 Measures
  • 21:24 Insert PivotTable from data model
  • 24:49 Key Performance Indicators (KPIs)
  • 27:06 Insert PivotChart
  • 28:16 Slicers
  • 29:34 Wrap up

Power Pivot Introduction -- Tutorials

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

Introduction to the Power Pivot Add-In -- Microsoft

Create a Power Pivot Workbook -- Microsoft

Add and Maintain Data in Power Pivot -- Microsoft

Analyze Data in PowerPivot -- Microsoft

Relationships between tables in a Data Model -- Microsoft

Getting Started With Power Query

Power Query helps you extract data from various sources like databases, spreadsheets, and websites.

You can use Power Query to clean and transform the data, making sure it's in the right format, and removing any unnecessary stuff, so it's ready for further analysis.

Power Query Introduction -- Video

In the video below, Ken Puls presents an introduction to Microsoft Power Query, and its importance in working with data.

Video Timeline:

  • 0:00 Introduction
  • 1:42 The Trouble With Data
  • 3:28 PQ Adds ETL to Excel
  • 4:46 Dealing With Data in Modern Excel

Power Query Introduction - Tutorials

-- Automate data cleaning with Power Query in Excel (Microsoft)

-- Learn to use Power Query and Power Pivot in Excel (Microsoft)

-- Use Power Query to Clean, Transform and Clean Data in Power BI (Microsoft)

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.

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 Power Pivot

Create Pivot Table in Excel 2013

Power Pivot for Excel Virtual Lab

Powe rPivot from Identical Files

 

 

 

Last updated: December 6, 2023 2:30 PM