Awesome Power BI

💛 💛 💛 💛 💛

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

"Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device."

Table of contents

• Power BI Heroes at YouTube 🌟
  • Special Videos
• Blogs
• Learning ⭐
• Power BI Desktop Feature Summary
• Official References
  • Docs and Whitepapers
• Power BI Family and Tools
  • Power BI Family
  • Tools
• Power BI Report Server
• Books
• Conferences, Groups and Social Media
• Power BI Samples
• Exam 70-778
• Visuals
• DAX
• M
• Drivers
• Datasets
• Special Features and Advanced Topics
  • Dataflows
  • Aggregation
  • Machine Learning
  • Advanced Topics
  • Power Platform
  • Python
  • R
• Storytelling
• 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
• Microsoft Microsoft Power BI
• Ruth Pozuelo Martinez Curbal
• Sam McKay Enterprise DNA
• Will Thompson Analyze & Visualize Data with Power BI

Special Videos

• 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)
• 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
• David Eldersveld DataVeld
• Imke Feldmann The BIccountant
• Marco Russo and Alberto Ferrari SQLBI
• Matthew Roche BI Polar
• Mike Carlo & Seth Bauer PowerBI Tips!
• Reza Rad RADACAD

---

Learning

• Power BI Guided Learning
• Power BI Introduction - Robert Sheldon (redgate Hub)
• Power BI Premium Demo

---

Power BI Desktop Feature Summary

2019

• 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

2018

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

---

Official References

Docs and Whitepapers

• Official Power BI 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.

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
• Coolors - The super fast color schemes generator.
• Online Image Color Picker

---

Power BI Report Server

• Power BI Report Server
  • Power BI Report Server - Power BI Report Server is the on-premises solution for reporting, with the flexibility to move to the cloud.
  • Power BI RS vs Power BI Service
  • Install Power BI Report Server
  • Install Power BI Report Server (RADACAD)
  • What's new in Power BI Report Server
• Settings and Troubleshooting
  • Error Logs and Troubleshooting
  • Querying ReportServer Database
  • Connect to Power BI Report Server with SSMS
  • The service is not available (Error)
    • The Report Server Web Portal Urls And Web Service Urls Don’t Match
    • The Service is Not Available (LuCELL)
    • Go to Report Server Configuration Manager, Backup the Encryption Keys and change the Service Account to "Network Service"
• ReportServer Database
  • Dynamic row level security with Analysis services tabular model
  • SSRS ReportServer Database Overview and Queries
• Security
  • Configure Windows Authentication on the Report Server
  • Configure Kerberos to use Power BI reports (Video)
  • Configure Custom or Forms Authentication on the Report Server
• Web Portal
  • Branding the web portal
  • Manage content in the web portal
  • Work with shared datasets
  • Create shared data sources and datasets for your reports (Video)
• Power BI Desktop for PBI RS
  • Power BI Desktop optimized for Power BI Report Server
  • Filter a report using query string parameters in the URL
  • Embed a Power BI Report Server report
• Power BI Report Builder (Paginated reports)
  • Working with paginated reports
  • Working with subscriptions
  • Working with snapshots
• Report Designer - SQL Server Data Tools (SSDT) for VS
  • Download and install SQL Server Data Tools (SSDT) for Visual Studio
• Mobile Report Publisher
  • Create mobile reports with SQL Server Mobile Report Publisher
  • Mobile Report Publisher – Dashboards Everywhere - Robert Cain
• KPI
  • Working with KPIs in Reporting Services
• APIs
  • Power BI Report using Shared Dataset
  • Power BI Report Server REST API

---

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
• Difinity Conference
• Power Platform Summit
• Data Platform Summit
• Power Platform World Tour

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.

---

Power BI Samples

• Power BI Features Summary Samples
• Power BI Dataset/Desktop Samples

---

Exam 70-778

• Exam 70-778 - Analyzing and Visualizing Data with Microsoft Power BI
• Microsoft Power BI Exam Ref 70-778 - Daniil Maslyuk
• Preparing for Power BI Certification Exam 70-778: Level 1 - Ted Pattison
• Prepare for the Power BI Certification (70-778) - Guy in a Cube

---

Visuals

• Power BI Visuals - Marketplace visuals (217 Viz on September 2019)
  • Visual Awesomeness Unlocked: Pulse Chart - Lukasz Pawlowski
• Key Influencers
  • Exploring Key Influencers Algorithms with citizen tools (March 2019)
• Visual Vocabulary
  • Visual Vocabulary - Website
  • Visual Vocabulary - Poster
• Developer
  • Create custom visuals for Power BI
  • D3.js - Data-Driven Documents
  • TypeScript
  • Node.js
• Related Articles
  • Certifying Custom Visuals For Power BI

---

DAX

• DAX basics in Power BI Desktop
• Row Context and Filter Context in DAX - Understanding the difference between row context and filter context is important in using DAX correctly.
• DAX Guide - Marco Russo and Alberto Ferrari
• Data Analysis Expressions (DAX) Reference
• DAX 101 (Video) - Alberto Ferrari
• Advanced DAX (Video) - Alberto Ferrari
• SQLBI Introducing DAX Course
• 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
• 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

---

Drivers

• 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio
• Microsoft Access Database Engine 2010 Redistributable
• MySQL Connectors and APIs
• PostgreSQL

---

Datasets

• Awesome Datasets

---

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

Dataflows

• Power BI dataflows January updates
• Power BI Dataflows FAQ - Matthew Roche
• Power BI data prep with dataflows - Adi Regev
• A quick look at Power BI dataflows - Adam Saxton
• Introducing Power BI data prep with dataflows - Matthew Roche
• What is a Power BI dataflow? A deep dive on Dataflows for Power BI - Ruth Martinez
• What are the Use Cases of Dataflow for You in Power BI? - Reza Rad

Star Schema

• Understand a star schema and the importance for Power BI

Shared Dataset

• Use datasets across workspaces

Aggregation

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

Machine Learning

• Creating Machine Learning models in Power BI
• AI in Power BI (Video) - AI can help everyone in an organization automatically find patterns in their data, understand what the data means, and predict future outcomes to help business drive results.

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

R

• Create Power BI visuals using R

---

Storytelling

• Bill Shander
  • How to Tell Stories and Weave a Cohesive Narrative With Data
  • Do Less
• Hans Rosling
  • The best stats you've ever seen | Hans Rosling
• Neil Halloran
  • The Nuclear Threat - The Shadow Peace
• 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)

---

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: A Data Analytics Duel
• Microsoft Power BI vs Qlik vs Tableau 2018

---

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

🔝

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