|
Home > Data > Get Data > Power Pivot Power BI ResourcesHere 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. |

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:
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.
In the video below, Kevin Stratvert presents an introduction to Microsoft Power BI, in a step-by-step tutorial.
Video Timeline:
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
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.
In the video below, Kevin Stratvert presents an introduction to Microsoft Power BI, in a step-by-step tutorial.
Video Timeline:
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
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.
In the video below, Ken Puls presents an introduction to Microsoft Power Query, and its importance in working with data.
Video Timeline:
-- 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)
These courses use video lessons to demonstrate the Power BI techniques, tools and formulas.
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.
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.
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.
Create Pivot Table in Excel 2013
Power Pivot for Excel Virtual Lab
Powe rPivot from Identical Files
Last updated: September 18, 2024 9:54 AM