Power BI Resources Collection

I have been working with Power BI pretty much since it was released and while there were not too many resources available back then, this has changed dramatically. Here I try to give a consolidated overview of those that I find most useful. Let me know, if you have any others.

YouTube

  • The official Microsoft Power BI channel. Go there now and subscribe. The videos showing the monthly Power BI Desktop Updates alone, are worth it. And then there is lots of other stuff.
  • Pragmatic Works distills the monthly Power BI Desktop updates to – what they judge – is most relevant. Additionally they frequently demo and explain the Custom Visuals (95 of them at the time of writing this) popping up more and more frequently.
  • True, Microsoft Mechanics is not dedicated to Power BI alone, but they often do videos on the topic. So it’s worth taking a look.
  • As you will find below, Enterprise DNA has extensive information for their members. But if you are not willing to pay for it, they also offer tons of free content on their YouTube Channel. Really helpful to get into – or better with – all things DAX. And – believe it or not – they provide a new free Power BI tutorial every weekday!
  • Guy in a Cube brings you Power BI related videos, which go to a deeper level than the usual tutorials.

Training & Certifications

  • Sam McKay’s “Enterprise DNA” is laser focused on the calculation and visualization of all things analytical or statistical. It is a treasure trove of courses including downloadable resources (pbix files and related sample data) for a wide range of topics. A one-time fee of appr. USD 600 will give you life time access to the above plus a well visited and maintained forum. Highly recommended.
  • Pragmatic Works offers “Power BI Pack“, a collection of 8 courses. For USD 595/user/year you get full access. They also offer a free trial to sample their goods. Spoiler alert: they are worth it.
  • Exam 70-778 by Microsoft is called Analyzing and Visualizing Data with Microsoft Power BI. For USD 165 you can get certified. The related course can be found on edX. Hint: they also offer a wide range of other courses related to Data Analysis and Statistics.

Useful Sites

  • The official Power BI Community is an indispensable resource. From an extremely active forum, to online support, to a lively community blog, events and ideas, they have it all. Plus a ton of downloadable material.
  • Power BI Tips and Tricks is – as the name implies – filled with useful information including Custom Layouts for you to download and customize. One of my favorites is certainly their Theme Generator, which allows you to easily crate your custom theme to be imported into Power BI.
  • From online tips, tutorials and trainings to bestselling books and custom mentoring. On sqlbi, Marco Russo, Alberto Ferrari and Daniele Perilli provide it all. Hint: the site also provides a DAX Formatter to help you structure your DAX statements.

Tools & Downloads

While the sites above also offer tools, here are some additional ones.

  • DAX Studio –  a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing and query execution breakdowns.
  • Power BI Helper Tool – a tool that saves you some time for cleaning up a Power BI report by identifying unused tables, measures and more.
  • Looking for a (complicated) DAX measure and you are certain that others were looking for it, too? Take a look at the Quick Measures Gallery and save yourself some time and hassle. No need to re-invent the wheel, is there?
  • Looking for inspiration for report layouts and design? The Report Theme Gallery has you covered. Tons of reports in all shapes and colors for you to peruse and leverage.
  • Last – and perhaps least – my own attempt at being useful. Get DAX syntax highlighting in Notepad++.

Conclusion

That’s it for now. I am fully aware that this is not an exhaustive collection and I will be happy to extend this post with any useful input you can and want to provide. I still hope it is a good jump off point for those new to Power BI and saves them from having to find the individual bis and pieces (as I had to).

Related Posts

Power BI Certification by Enterprise DNA M aka Power Query and Notepad++ Interactive CV

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.