Awesome Power BI

Table of contents

• Visuals
• Power Pivot
• DAX
• M and Power Query
• Power BI tools
• Parameters and Templates
• Dataflows
• Aggregation
• Styles and Themes
• Competitive Analysis
• Repository
• Books
• Groups
• Site
• YouTube

Visuals

• Power BI Visuals

Power Pivot

Tool

• power-pivot-utilities Power Pivot Utilities in an Excel add-in (based on a collection of VBA macros) that helps documenting PowerPivot models and facilitates the creation of pivot tables connected to the data model.

DAX

Site

• DAX Guide - Marco Russo and Alberto Ferrari
• Data Analysis Expressions (DAX) Reference
• DAX 101 (Video) - Alberto Ferrari
• SQLBI Introducing DAX Course
• powerdax
• daxpatterns
• dax.guide
• daxformatter

Tool/library

• DaxEditor DAX Editor VSIX project
• http://powerdax.com/Downloads/
• DAX Formatter
• DAX Studio

M and Power Query

Site

• Basics of M - Power Query Formula Language
• Quick tour of the Power Query M formula language
• Power Query M function reference

Tool/library

• PowerQueryFunctional Power Query utility library with a functional twist
• m-tools A collection a useful tools for building Microsoft Power BI queries
• pquery A collection of functions for use in Excel Power Query
• Power-BI-Desktop-Query-Extensions Various M Queries that you can use to make life easy-peasy
• PowerQueryExtensions Modules that extend the functionality of Power BI/Power Query
• atom-language-m Power Query Formula Language (informally known as 'm') support in atom
• LibPQ Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)
• M Collection of cutom M functions for Power Query and Power BI
• RM R functions who are wrapped into M function code to run in Power BI
• M-Guide Collection of native M functions with unexpected behaviour and their workarounds
• Power-Query Set of Functions for Power Query
• Power-Query-Excel-Formats A collection of M code to get various formats from Excel sheets in Power Query
• PowerQueryModules Power Query Modules used in Power BI desktop
• power-query-library Power Query common library

Connector

• DataConnectors
• PowerQueryConnectors A collection of data connectors for Power BI
• FacebookAds FacebookAds PowerBI data connector
• YoutubeAnalytics A Microsoft Data Connector or Power Query Connector for YoutubeAnalytics data q

Power BI tools

• Power BI Helper

• PowerBI_Desktop_Export_CSV a Powershell script to query and export a CSV from Power BI Desktop

• PowerBI_Desktop_VBA_Excel Connect to PowerBI desktop using VBA only

• PowerBI_Desktop_ETL PS script to automate an ETL job in PowerBI Desktop

• PowerBI_Desktop_Refresh PS script to refresh a PowerBI Desktop

Parameters and Templates

• Parameters and Templates - Deep Dive into Query Parameters and Power BI Templates

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

Aggregation

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

Styles and Themes

• Power BI Style Library!
• Themes Gallery
• Theme Generator

Competitive Analysis

• Power BI vs Tableau: A Data Analytics Duel
• Microsoft Power BI vs Qlik vs Tableau 2018

Embedded

• powerbi-responsive Create responsive, embed-able reports from Power BI

Repository

• Hugoberry
• ImkeF
• IvanBond
• djouallah
• hohlick
• acaprojects

Books

Power BI Books

Featured 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

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

Groups

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

Communities and Groups

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

Site/blog

• http://www.powerpivot-info.com/
• https://querypower.com/
• http://radacad.com
• https://powerbi.tips
• https://powerpivotpro.com
• 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
• thebiccountant

Youtube

• Adam Saxton and Patrick Leblanc Guy in a Cube
• Avi Singh PowerBIPro
• Matt Alington Excelerator BI
• Microsoft Microsoft Power BI
• Ruth Pozuelo Martinez Curbal
• Will Thompson Analyze & Visualize Data with Power BI

🔝