Awesome Power BI

💛 💛 💛 💛 💛

It is so easy to start with Power BI, but hard to master it.

"Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports."

Power BI Heroes at YouTube 🌟
- Special Videos
Blogs
Podcast
Learning ⭐
Power BI Desktop Feature Summary
Power BI Service and Mobile Feature Summary
Power BI Samples
Official References
- Docs and Whitepapers
- Roadmap
- API and PowerShell
Power BI Family and Tools
- Power BI Family
- Tools
Power BI Report Server
Books
Conferences, Groups and Social Media
Exam
- Exam DA-100 - New
- Exam 70-778
Visuals
Storytelling
DAX
M
Special Features and Advanced Topics
- Q&A
- Dataflows
- Aggregation
- Machine Learning
- Advanced Topics
- Power Platform
- Python
- R
Drivers
Datasets
Templates and Showcases
Styles, Icons and Themes
Competitive Analysis
Data - Job Descriptions

Power BI Heroes at YouTube

sorted alphabetically ❤️

Adam Saxton and Patrick Leblanc Guy in a Cube
Alex Dupler & Alex Powers Two Alex
Avi Singh PowerBIPro
Bas Dohmen How to Power BI
Chandeep Goodly
Injae Park Power BI Park
Matt Alington Excelerator BI
Matthew Roche BI Polar
Microsoft Microsoft Power BI
Reza Rad and Leila Etaati RADACAD
Ruth Pozuelo Martinez Curbal
Parker Stevens BI Elite
Pragmatic Work
Sam McKay Enterprise DNA
Will Thompson Analyze & Visualize Data with Power BI
Workout Wednesday

Special Videos

The Unified Data Platform for the Era Of AI | Microsoft Fabric Community Conference Day 1 - Microsoft Fabric
Chris Webb - Fabric Direct Lake Deep Dive ~53min - Ben Howard
AI and ML with PowerBI - Crash Course - Data Science Dojo
Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick) - Havens Consulting
Power BI for BI pros and Data Engineers (MSBuild) - Priya Sathy (May 2021)
Common mistakes in big data models - SQLBI (April 2021)
Understanding memory used by Power BI - SQLBI (February 2021)
Power BI Dev Camp: Developing Custom Visuals for Power BI - Microsoft Power BI (February 2021)
Why Dataflows With Matthew Roche - Havens Consulting (November 2020)
HTML Content Custom Visual - PowerBI.Tips, Daniel Marsh-Patrick (October 2020)
Power BI Dev Camp: Writing PowerShell scripts for Power BI - Microsoft Power BI (October 2020)
Introduction to XMLA endpoints - Microsoft Power BI (August 2020)
Performance, Optimization, and Intelligent Error Handling in Power Query - Microsoft Power BI (July 2020)
Thank You for 5 Years - Happy Birthday Power BI
DAX Studio Release 2.11.1 (Tutorial) (July 2020)
Data modelling 101 with Power BI (June 2020)
How to build modern IoT solutions with Cosmos DB and Power BI (June 2020)
Data preparation tricks you should know for Power BI solutions - Microsoft Power BI
From Insight to Action: Driving a Data Culture with Power BI - Microsoft Power BI (May 2020)
MBAS Recap with BIFocal - Guy in a Cube (May 2020)
How To Get Started with Power BI Dataflows and the Common Data Model - AgileThought (April 2020)
Let's Talk Paginated Reports In Power BI (Premium) - Guy in a Cube (March 2020)
Creating custom visuals in Power BI using R script, JSON, and Charticulator - Community Webinars (March 2020)
Dataflow and shared dataset multi-developer architecture for Power BI - Microsoft Power BI (March 2020)
Data modelling in Power BI Desktop - Microsoft Power BI (February 2020)
Self Service AI in Power BI Desktop (Community Webinar) - Microsoft Power BI (February 2020)
Best practices in visualization creation in Power BI Desktop - Microsoft Power BI (February 2020)
How to build custom visuals without code with Power BI - Mike Carlo (January 2020)
Microsoft Power BI: BI power hour - All the BI gangs are here (June 2019)
Microsoft Power BI: Premium capacity (June 2019) - In what cases you should use it, how to perform capacity planning in various deployment scenarios, and how your users can leverage unique features in Premium to utilize the Premium capacity more efficiently.
Fusing AI and data visualization (October 2018, Ignite 18)
Data prep and wrangling with Microsoft Power BI Desktop - Miguel Llopis (July 2018)
Microsoft Power BI: The future of modern BI - Roadmap and Vision
Enterprise-grade BI with Power BI dataflows - Cristian Petculescu, Mohammad Ali
Analyzing country data in less than 60 minutes - Marc Reguera
Understanding relationships in DAX - Alberto Ferrari
Storytelling with Power BI - Jeff Lumpkin
Dataflows The Integration Solution for Power BI

Blogs

Alex J. Garcia Smart Power BI - Helping Organizations to Use Power BI
Blue Granite - blue-granite.com
BI Gorilla - gorilla.bi
BI Survey (Blogs) - bi-survey.com | The world's most complete overview of Power BI blogs
Capstone Analytics - We bring analytics to your fingertips
Daniil Maslyuk XXL BI - More than Excel BI
Data witches
DataZoe Power BI (Zoe Douglas) - datazoepowerbi.com
Dave Ruijter Modern Data and AI
David Eldersveld DataVeld
Kasper On BI - All about Power BI, Modelling, DAX and Microsoft BI
Imke Feldmann The BIccountant
Mara Pereira Data Pears - Power BI tips and tricks
Marco Russo and Alberto Ferrari SQLBI
Mark Walter Story BI
Marthe Moengen Data Ascend - data-ascend.com
Matthew Roche BI Polar
Mike Carlo & Seth Bauer PowerBI Tips!
Numerro | Power BI blog - numerro.io
Reza Rad RADACAD
Prathy Kamasani Prathy's blog
SQL Server Power BI Tips

Podcast

Will Power BI's Reign last? w/ Patrick LeBlanc - (September 2020)
Expert's Talk - Do you want to know what other Power BI experts think about certain aspects of Power BI? Here they share their expertise.
Power BI & More at Apple and Listen Notes - Ulrik Carlsson
BIFocal

Learning

Power BI Guided Learning - Microsoft Docs
Power BI Microsoft Learn - Learn new skills with step-by-step guidance ⭐
Power BI Paginated Reports in a Day
Data Visualization with Power BI - DataCamp
Power BI Introduction - Robert Sheldon (redgate Hub)
Power BI Premium Demo
Power BI webinars
Virtual workshops and training - Our interactive virtual workshops and training sessions are taught live by Microsoft associates.
Power BI Events Catalog - events.microsoft.com
Power BI implementation planning ⭐

Power BI Desktop Feature Summary

2024

2023

2022

2021

Previous years

Power BI Desktop Feature Summary History

Power BI Service and Mobile Feature Summary

2020

2019

Power BI Samples

Power BI Features Summary Samples
Power BI Dataset/Desktop Samples
Themeable Backgrounds for Power BI - Chris Hamill (May 2020)

Official References

Docs and Whitepapers

Official Power BI Docs
Power BI guidance documentation - Microsoft Docs
Power BI Whitepapers

Roadmap

Microsoft Power BI roadmap - The Power BI public product roadmap provides a glimpse into the capabilities that will become available in the next wave of product updates.
- What's new and planned for Business intelligence
Power Platform: 2020 release wave 1 plan
Power BI Ideas (Top Ideas)
Power BI Release Plan (PBI Report) - Alex Powers

API and PowerShell

REST API - Power BI REST API provides service endpoints for embedding, administration, and user resources.
Microsoft Power BI Cmdlets - Microsoft Power BI Cmdlets for Windows PowerShell and PowerShell Core
PowerShell script to publish Power BI reports - Andrzej Leszkiewicz (January 2021)

Power BI Family and Tools

Power BI Family

Tools

DAX Formatter - DAX Formatter is a free tool by SQLBI that transform raw DAX formulas into clean, beautiful and readable code.
DAX Studio - DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.
VertiPaq Analyzer - A useful tool to analyze VertiPaq storage structures for a data model in Analysis Services Tabular.
Power BI Helper
Theme Generator - Color Theme Generator
Power BI Data Connection file PBIDS
Coolors - The super fast color schemes generator.
Online Image Color Picker
Palettes and Theme Generator tool - powerbi.tips
Tabular Editor - Tabular Editor provides an intuitive hierarchical view of every object in your Tabular Model metadata.
- Tabular Editor Rocks! - Mike Carlo

Books

Power BI Books

Pro Power BI Architecture - Sharing, Security, and Deployment Options for Microsoft Power BI Solutions
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI (Business Skills) - Gil Raviv
Introducing Microsoft Power BI - Marco Russo and Alberto Ferrari, Kindle Edition, FREE
The Definitive Guide to DAX - BI with Microsoft Excel, SQL Server Analysis Services, and Power BI
Microsoft Power BI Exam Ref 70-778 - Daniil Maslyuk

Featured Power BI Books!

Related Books

#MakeoverMonday - Improving How We Visualize and Analyze Data
Information Is Beautiful - David McCandless
Storytelling with Data - A Data Visualization Guide for Business Professionals
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios - Steve Wexler
The Truthful Art: Data, Charts, and Maps for Communication - Alberto Cairo

Conferences, Groups and Social Media

Communities

Power BI Community - Connect, learn and discuss with business intelligence experts and peers
Power BI User Group - Your Community. Your Connections. Your Questions Answered.

Visuals

Unlocking the Potential of Power BI's Built-In Visuals 📊📈 - Naji El Kotob
Power BI Visuals - Marketplace visuals (384 Viz in January 2022)
- Power BI Visuals by Microsoft
Power BI Custom Visuals (Resources and References) - Naji El Kotob
Visual Vocabulary
- Visual Vocabulary - Website
- Visual Vocabulary - Poster
- Data Viz Project - ferdio
- Datawrapper Academy - academy.datawrapper.de
Lisa Muth - lisacharlottemuth.com | I create, talk & write about data vis
From Data to Viz - From Data to Viz is a classification of chart types based on input data format.
Gestalt
- Exploring the Gestalt Principles of Design - Cameron Chapman
- 7 Gestalt principles of visual perception: cognitive psychology for UX
What is the F-Pattern and How to Use It for Increased Conversions
Fundamentals of Data Visualization 📚 - Claus O. Wilke (O'Reilly)
Data Visualization statcan.gc.ca - Statistics | Power from Data

Storytelling with Power BI in PowerPoint

Storytelling

Reporting is just the presentation of data , but story telling is more engaging. Effective data storytelling uses language and visualization to help the audience engage and connect with the larger meaning.

Bill Shander
Hans Rosling
- Hans Rosling's 200 Countries, 200 Years, 4 Minutes ⭐ - The Joy of Stats (BBC Four)
- The best stats you've ever seen | Hans Rosling
Cole Nussbaumer Knaflic
- SWD Chart Guide
- Storytelling with Data 📺
Neil Halloran
- The Nuclear Threat - The Shadow Peace
Stephanie Starling - freelance researcher and data journalist
Erin Ostrowsky (Pragmatic Works)
- Intro to Data Storytelling Vizualization with Power BI
Storytelling with data and Power BI
- Ruth Pozuelo Martinez
  - Storytelling with data and Power BI
  - How to effectively tell a story with your data and Power BI (Video)
Lucidworks
- Dark Data; Inveractive version
Natalia Kiseleva (eolay) - eolay.tilda.ws | Mortality caused by road traffic injury
Doug Ros eal Value (Book)](https://www.amazon.com/Data-Science-Create-Questions-Deliver/dp/1484222520)
David JP Phillips
- The magical science of storytelling (TEDxStockholm)
Isaac Reyes
- From Numbers to Narrative 📺 ~55min - Open Data Science Conference Europe 2018
HBR
- How to Tell a Story with Data
Gartner
- Use Data and Analytics to Tell a Story - Storytelling = visualization + narrative + context
Samples
- Nine Charts about Wealth Inequality in America - urban.org
- Storytelling: Minard vs. Nightingale - Robert Kosara
- The Shape of Dreams - the-shape-of-dreams.com
- The Pudding - is a digital publication that explains ideas debated in culture with visual essays.
- Data Is Beautiful (reddit)
- Data Art (reddit)
- One year later: The path to carbon negative – a progress report on our climate ‘moonshot’ - Brad Smith (January 2021)
Quotes
- “Storytelling is the oldest form of education.” -- Terry Tempest Williams
- “A great lasting story is about everyone or it will not last. The strange and foreign is not interesting--only the deeply personal and familiar.” -- John Steinbeck
- “A story that contrasts the present with the future needs a great deal of trust.” -- Doug Rose
- “Numbers Don’t Lie, But Charts Do”
- “Stories activate the same parts of our brains that are activated when processing real experiences.”
- “The data means nothing without context, without the story form around it.” -- Bill Shander
- KWYs -- Bill Shander
  - KWYRWTS "Know What You Really Want to Say"
  - KWYDIS "Know What Your Data is Saying"
  - KWYANTH "Know What Your Audience Needs to Hear"
- “A story is 22 times more memorable than facts alone.” -- Jennifer Aaker
- “ASK - Accurate . Story . Knowledge” -- Bill Shander
- "Stories make data analysis accessible to a wider audience. They also make analysis more engaging." -- Kubicle.com
Hints
- A Power BI dashboard is made up of tiles that, together, tell a story. -- Microsoft
- Each report page is telling a story. To fully understand the story, you need to know if filters are being applied and what those filters are. -- Microsoft
- A visual represents a single table, chart or diagram. A dashboard brings together several relaated charts to tell or story about the selected data. -- CFI
Do you want to learn more about storytelling?

DAX

Microsoft Docs
SQLBI ⭐
- DAX Guide - Marco Russo and Alberto Ferrari
- How to Learn DAX - Whether you are starting from scratch or have already learned the basics of DAX, this guide will show you all the steps to follow in order to master the Power BI and Analysis Services query language.
- DAX.do - Write your DAX queries, try them and share them easily with DAX.do
- Introducing DAX Course ⭐
- DAX 101 📺 ~2 hours - Alberto Ferrari
- The Whiteboard (SQLBI)
- Advanced DAX 📺 ~2 hours - Alberto Ferrari
- Deep dive into DAX evaluation context 📺 ~1 hour - Marco Russo (June 2019)
- DAX Filter Context in 1 Hour - Marco Russo (March 2021)
- CALCULATE in DAX - pills
- From SQL to DAX
- Row Context and Filter Context in DAX - Understanding the difference between row context and filter context is important in using DAX correctly.
Matt Allington
- Evaluation Contexts in DAX - Level 200 (Video)
- DAX 50 (Video) - Matt Allington
Andy Brown (redgate Hub)
LazyDAX - Arnaud Gastelblum
- Learn DAX from Examples
- LazyDAX 2.0 (YouTube)
Wise Owl Tutorials
- DAX for Power BI 📺
SSMS
- Getting Started with the SSAS Tabular Model - Robert Sheldon
- Using DAX to retrieve tabular data - Robert Sheldon
Advanced Topics
- Bidirectional relationships and ambiguity in DAX - Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable.
- Hiding future dates for calculations in DAX - This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates.
Unicode
- Unicode Characters
- UNICHAR - Returns the Unicode character referenced by the numeric value.

M

Best Practices

Best practice rules to improve your model’s performance - Michael Kovalsky (February 2021)

Special Features and Advanced Topics

Q&A

Star Schema

Understand a star schema and the importance for Power BI

Shared Dataset

Use datasets across workspaces
New Power BI Reports from a Golden Dataset - Matt Allington (June 2018)

Aggregation

Aggregations for petabyte-scale - Christian Wade
- Aggregations in Power BI Desktop
Create the Aggregated Table - Reza Rad @ RADACAD Blog
Aggregations in Power BI - Shabnam Watson

Advanced Topics

Parameters and Templates - Deep Dive into Query Parameters and Power BI Templates
Anscombe's quartet (Video) - Anscombe's quartet comprises four datasets that have nearly identical simple descriptive statistics, yet have very different distributions and appear very different when graphed.
Storing Large Images In Power BI Datasets - Chris Webb

Power Platform

Power platform vision and roadmap (Video)

Python

R

Create Power BI visuals using R

Drivers

Datasets

Awesome Datasets

Power BI Datasets

Contoso Sales for Power BI - Microsoft

Templates and Showcases

Campaign and Brand Management Solution Templates for Twitter
- Campaign/Brand Management for Twitter (Video)

Styles, Icons and Themes

Power BI Style Library!
Themes Gallery
Turning a Corporate Color Palette into a Data Visualization Color Palette
Power BI Theme Templates - Matt Rudy
Power BI Icons - Microsoft | This repository contains PNG and SVG versions of icons for Power BI

Competitive Analysis

Power BI vs Tableau vs Qlik (Google Trends)
Ron George's original sketch of Power BI (named Project Crescent) 💛
Alteryx Platform vs Microsoft Power BI
Power BI vs Tableau: A Data Analytics Duel
Microsoft Power BI vs Qlik vs Tableau 2018
Microsoft Power BI vs Google Chart - financesonline.com
Gartner Magic Quadrant for Analytics and BI Platforms
- Microsoft named a Leader in Gartner’s 2021 Magic Quadrant for Analytics and BI Platforms - Gartner (Feburary 2021)
- Microsoft named a Leader in Gartner’s 2020 Magic Quadrant for Analytics and BI Platforms - Gartner (Feburary 2020)
Kibana vs Power BI
- Kibana Vs Microsoft Power BI Comparison 2020 - comparecamp.com
- Kibana vs Microsoft Power BI - trustradius.com
Interactive MagicQuadrant BI and Analytic Platforms
Power BI Blog Portfolio ⭐ - bi-survey.com

Demos

Job Descriptions

Power BI Interview Questions - Overview (Video) - Episode 1 | Learn some of the basic overview questions you'll hear or should ask in your tech interview with a Power BI developer (Pragmatic Works).
Power BI Interview Questions - Data Shaping Finished - Episode 2 | Learn common Power BI interview questions from the experts. This episode focuses on data shaping common interview questions.
Power BI Interview Questions - DAX - Learn the best answers to give (or the questions to ask a candidate) in a Power BI DAX interview.
Data Analyst job description - Workable
Data Analyst job description - Zippia
Data Architect job description
Data Scientist job description
List of Job Descriptions
Power BI is Hiring - Microsoft

🔝

Name		Name	Last commit message	Last commit date
Latest commit History 759 Commits
DAX		DAX
Datasets		Datasets
Demo		Demo
Documents		Documents
Exams		Exams
Images		Images
Posters		Posters
Samples		Samples
TShirt		TShirt
LICENSE		LICENSE
Power BI Artificial Intelligence.md		Power BI Artificial Intelligence.md
Power BI Case Studies.md		Power BI Case Studies.md
Power BI Custom Visuals Development.md		Power BI Custom Visuals Development.md
Power BI Custom Visuals.md		Power BI Custom Visuals.md
Power BI Data Gateway.md		Power BI Data Gateway.md
Power BI Dataflows.md		Power BI Dataflows.md
Power BI Desktop Feature Summary.md		Power BI Desktop Feature Summary.md
Power BI Embedded.md		Power BI Embedded.md
Power BI External Tools.md		Power BI External Tools.md
Power BI Premium.md		Power BI Premium.md
Power BI REST API.md		Power BI REST API.md
Power BI Report Server.md		Power BI Report Server.md
Power BI Service and Mobile Feature Summary.md		Power BI Service and Mobile Feature Summary.md
Power BI Tips and Tricks.md		Power BI Tips and Tricks.md
Power BI for Dynamics.md		Power BI for Dynamics.md
Power BI for Elasticsearch.md		Power BI for Elasticsearch.md
README.md		README.md
Reports.md		Reports.md

License

NajiElKotob/Awesome-Power-BI

Folders and files

Latest commit

History

Repository files navigation