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."

Table of contents

• Power BI Heroes at YouTube 🌟
  • Special Videos
• Blogs
• 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 and Themes
• Competitive Analysis
• Data - Job Descriptions

---

Power BI Heroes at YouTube

sorted alphabetically ❤️

• Adam Saxton and Patrick Leblanc Guy in a Cube
• Avi Singh PowerBIPro
• 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

Special Videos

• 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
• MBAS Recap with BIFocal - Guy in a Cube (May 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

• Blue Granite
• Capstone Analytics - We bring analytics to your fingertips
• Daniil Maslyuk XXL BI - More than Excel BI
• 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
• Marco Russo and Alberto Ferrari SQLBI
• Mark Walter Story BI
• Matthew Roche BI Polar
• Mike Carlo & Seth Bauer PowerBI Tips!
• Reza Rad RADACAD
• SQL Server Power BI Tips

---

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

---

Power BI Desktop Feature Summary

2020

• Power BI Desktop September 2020 Feature Summary
• Power BI Desktop August 2020 Feature Summary
• Power BI Desktop July 2020 Feature Summary
• Power BI Desktop June 2020 Feature Summary
• Power BI Desktop May 2020 Feature Summary
• Power BI Desktop April 2020 Feature Summary
• Power BI Desktop March 2020 Feature Summary
• Power BI Desktop February 2020 Feature Summary

2019

• Power BI Desktop December 2019 Feature Summary
• Power BI Desktop November 2019 Feature Summary
• Power BI Desktop October 2019 Feature Summary
• Power BI Desktop September 2019 Feature Summary
• Power BI Desktop August 2019 Feature Summary
• Power BI Desktop July 2019 Feature Summary
• Power BI Desktop June 2019 Feature Summary
• Power BI Desktop May 2019 Feature Summary
• Power BI Desktop April 2019 Feature Summary
• Power BI Desktop March 2019 Feature Summary
• Power BI Desktop February 2019 Feature Summary

Previous years

• Power BI Desktop Feature Summary History

Power BI Service and Mobile Feature Summary

2020

• Power BI Service and Mobile May and June 2020 feature summary
• Power BI Service and Mobile February and March 2020 feature summary

2019

• Power BI Service and Mobile October and November 2019 feature summary
• Power BI Service and Mobile September 2019 feature summary
• Power BI Service and Mobile August 2019 feature summary
• Power BI Service and Mobile July 2019 feature summary
• Power BI Service and Mobile June 2019 feature summary

---

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

---

Power BI Family and Tools

Power BI Family

• Power BI Desktop
• Power BI Service > Try Free
• Power BI Mobile
• Power BI Report Builder
• Power BI Report Server

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

---

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

Summits and Conferences

• Microsoft Business Applications Summit - microsoft.com
• Difinity Conference - difinity.co.nz
• Power Platform Summit - powerplatformsummit.com
• Data Platform Summit - dataplatformgeeks.com
• Power Platform World Tour - powerplatformworldtour.com
• Open Data Science Conference - odsc.com

LinkedIn Groups

• Enterprise Power BI - Sam McKay
• Microsoft Power BI - Clint Huijbers
• PowerBI - Padmanabhan Thirugnanasambandam
• Power BI - Rajoo Jha
• Power BI Group - Naji El Kotob
• Power BI User Group - Rose Spitzer
• Microsoft Business Intelligence - Frederik Vandeputte
• Microsoft Power BI Community - Pratibha Kumari Jha
• SQL Server Business Intelligence(BI) - Rajoo Jha
• Business Intelligence Professionals (BI, Big Data, Analytics) - Robbert van Vlijmen
• Power BI Developers - Sharat Chandra Jha

Twitter

• MS Power BI (Official)

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

• Power BI Visuals - Marketplace visuals (273 Viz on August 2020)
  • Power BI Visuals by Microsoft
• Power BI Custom Visuals (Resources and References) - Naji El Kotob
• Visual Vocabulary
  • Visual Vocabulary - Website
  • Visual Vocabulary - Poster
• From Data to Viz - From Data to Viz is a classification of chart types based on input data format.
• 7 Gestalt principles of visual perception: cognitive psychology for UX
• What is the F-Pattern and How to Use It for Increased Conversions

---

Storytelling

• Bill Shander
  • How to Tell Stories and Weave a Cohesive Narrative With Data
  • Do Less
  • From Numbers to Narrative (Key Takeaways)
• Hans Rosling
  • The best stats you've ever seen | Hans Rosling
• 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)

---

DAX

• Microsoft Docs
  • Introduction to DAX
  • DAX basics in Power BI Desktop
  • Data Analysis Expressions (DAX) Reference
• SQLBI
  • Introducing DAX Course ⭐
  • DAX 101 (Video) - Alberto Ferrari
  • Advanced DAX (Video) - Alberto Ferrari
  • Deep dive into DAX evaluation context - Marco Russo (June 2019)
  • DAX Guide - Marco Russo and Alberto Ferrari
  • 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)
  • Creating Calculated Columns Using DAX
  • Creating Measures Using DAX
  • Using the DAX Calculate and Values Functions
  • Using the FILTER Function in DAX
  • Cracking DAX – the EARLIER and RANKX Functions
• LazyDAX - Arnaud Gastelblum
  • Learn DAX from Examples
  • LazyDAX 2.0 (YouTube)
• 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

• Basics of M - Power Query Formula Language
• Quick tour of the Power Query M formula language
• Power Query M function reference
• Document all Power Query M code without copy pasting it (Video) - Curbal

---

Special Features and Advanced Topics

Q&A

• Editing Q&A linguistic schemas
• Q&A for Power BI consumers
• Use Power BI Q&A to explore your data and create visuals

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

• Run Python scripts in Power BI Desktop
• Create Power BI visuals using Python
• Python visualizations in Power BI Service
• Power BI Desktop and Python; like Peanut Butter and Chocolate - Rajendra Gupta

R

• Create Power BI visuals using R

---

Drivers

• Oracle
  • 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio
  • 64-bit Oracle Data Access Components (ODAC)
• Microsoft Access Database Engine 2010 Redistributable
• MySQL Connectors and APIs
• Use SAP HANA in Power BI Desktop
• PostgreSQL

---

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 and Themes

• Power BI Style Library!
• Themes Gallery
• Turning a Corporate Color Palette into a Data Visualization Color Palette

---

Competitive Analysis

• Power BI vs Tableau vs Qlik (Google Trends)
• 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
• 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

Demos

• Power BI Samples
• Tableau Solutions Gallery
• Qlik Sense

---

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

🔝

Suggest more Power BI Resources https://github.com/NajiElKotob/Awesome-Power-BI/issues