Here are some of the resources that you can use to learn about Power Pivot and other Power BI tools. New resources will be added as they are made available.
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.
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.
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.
Online Classes – Live Training
If you’d like to learn more about it, experts Ken Puls and Miguel
Escobar 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.
Online Classes – Self-Paced
Ken and Miguel also have an online Power Query Academy, where you can go at your own pace. The course starts with the Power Query basics, and gradually builds up to advanced techniques. There are 15 modules, broken into 55 videos (over 12 hours of content). See all the course details and sign up now.
Data Master Bundle
Get the Data Master Bundle — a series of online courses from Excel with Business. The bundle includes Excel, Data Science, Business Analysis and Microsoft Access courses. Click the image below, for bundle details
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.
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.
Get the Resource List
Download a copy of the Contextures Power BI Resource List. The list is in PDF format, and you can open it with Adobe Reader.
More Links
Create
Pivot Table in Excel 2013
Management Dashboard Downloads
No comments:
Post a Comment