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. |
Power BI, Power Pivot, Power QueryTogether, 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:
|
Power BI Introduction -- TutorialsThese 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 |
Power Pivot Introduction -- TutorialsThese 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 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 CoursesThese courses use video lessons to demonstrate the Power BI techniques, tools and formulas. Power BI WebinarThis 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 Pivot for Excel CourseThis 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 CoursesKen 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. |
More LinksCreate Pivot Table in Excel 2013 |
Last updated: December 6, 2023 2:30 PM