My Top Power BI Resources
Sometimes there seems to be too much information on internet which can lead to Decision Fatigue. I have summarized the top resources I have used when learning Power BI below.
Photo by Toa Heftiba on Unsplash
Agenda
I have summarized the top resources I have used when learning Power BI below. They cover every part of working with Power BI, from:
Getting started with Power BI Desktop
Learn how to work with Power Query
Learn how to work with DAX
Learn how to work with Advanced DAX
Data Modeling
Data Governance
Let me know if you have any other great resources that you have used to learn Power BI in my Contact form.
SQL BI
Great Resources For Learning DAX Specifically And Power BI Generally
If I could chose the people that I have learned most from in Power BI it is definitely from Marco Russo and Alberto Ferrari from SQLBI.
Their book, The Definitive Guide to DAX, was the first book that I read related to Power BI. It is often called “The Bible of DAX” because everyone have one in their bedside table.
The book is a very comprehensive guide of DAX, covering everything from what DAX is, basic functions, evaluation and row context, to how the the engine behind DAX works.
Their Youtube page is a great way to learn more specific DAX functions with a lot of short videos describing the different functions.
DAX Patters, another of their books, can be used kind of like a “Cookbook” in Power BI, where you can find most used patterns, which is especially helpful when working with Time Intelligence.
They have online courses, several other books and great blog articles that are coming out every week.
Other projects are DAX Formatter, Helps format DAX code, and DAX Guide, guide to all DAX functions.
Books
Learn All Parts Of Power Bi With The Help Of The Best Books, Written By Microsoft MVPs.
Practice is great, but books are a great way to learn Power BI as well.
The list to the left are the books that I have bought related to Power BI, and below are my comments about what you can learn specifically from the different books.
Basics of Power BI Modeling — Reza Rad (Radacad)
Best practices for relationships, star schema, fact and dimension tables and more.
This book helps to uncover all of these different aspects.
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
A lot of hands-on examples where you have to solve different problems in Power Query, with tips and solutions in the book.
DAX Patterns — SQLBI
Most common patterns that you will meet when working with DAX, especially a lot of Time Intelligence Patterns which have helped me when I got stuck with difficult measures.
Pro Power BI Architecture — Reza Rad
Creating the Power BI Model and Dashboard is just one way of working with Power BI. This books helps with the other part -> Data Governance, publishing, sharing reports and more.
Row-Level Security in Power BI — Reza Rad
Row-Level Security is about sharing the right content and giving right access to people working with your report. It is a great way to handle important data.
Supercharge Power BI — Power BI is Better When You Learn to Write DAX
Great book on learning DAX, if you are just beginning with Power BI. Covers beginner problems such as writing measures, calculated columns and most common DAX measures.
The Definitive Guide to DAX — SQLBI
The best book about DAX that you find out there.
Written by SQLBI, which are the gurus in data, covering all aspects of DAX there is.
Curbal
Comprehensive Content About Power Bi, Best Youtube Channel I Know About Power BI
Curbal is guaranteed the Youtube channel that I have used the most when working with Power BI.
Ruth, who owns the channel, has tons of tips about both DAX, Power Query, visualization, certifications and much more.
I do especially love the DAX Fridays.
In the DAX Fridays playlist she has more than 200 videos about different ways to handle DAX measures explained in a very easy and understandable way.
She also have many videos, as well as courses, regarding Power Query and the M-language, which are great.
At her homepage she has a DAX Glossary, with links to all the DAX Fridays. If you need to understand a DAX measure better, go to DAX Glossary and the related video.
Besides this she has a large community with 30 000+ members and a lot of other extra resources available.
Conclusion
In this Article I have summarized the best resources that I have found regarding Power BI. They are summarized in three main groups:
SQL BI
Power BI Books
Curbal
Questions or inquiries
If you have any questions or input please contact me on
LinkedIn: www.linkedin.com/in/elias-nordlinder
Email: Elias.Nordlinder@gmail.com
Contact Form on Webpage
Medium: https://elias-nordlinder.medium.com/
Have a great week everyone
//Elias
