Useful Power BI resources to
consider
(Updated
2024-April-18th)
Quotes:
- "... layout your Lookup Tables at the top and your Data Tables at the bottom ... [then] relationships flow downhill." -- Avi Singh, July 2021.
- "Power BI assumes you have a dimensional model. [i.e. star, snowflake or galaxy schema]" -- Jeroen ter Heerdt, June 2022.
- "Remember, the Context Transition requires an Iteration and CALCULATE." -- Alberto Ferrari, May 2022.
- "I would say [Evaluation Context] is the single most important concept to learn about Power BI." -- Ed Hansberry, Nov 2021.
- "Creating Calculated Columns [in Power BI] should be a last resort [as they're inefficient]." -- Ed Hansberry, Nov 2021.
- "Data should be transformed as far upstream as possible, and as far downstream as necessary." -- Matthew Roche, May 2021.
- "Keep Data unchecked when using bookmarks and buttons for navigation purposes." -- Adam Saxton, April 2021.
- "...Power Query only allows you to make GET and POST requests [when accessing API's]." -- Chris Webb, Feb 2021.
- "Facts get aggregated ... Dimensions slice Facts ..." -- Ken Puls, June 2019.
- "No column from a Fact Table should EVER be used in a Dimension Field!" -- Ken Puls, June 2019.
- "One of the best ideas in dimensional modeling is this concept called surrogate keys. " -- Bryan Cafferky, Aug 2017.
- "The world of VLOOKUP is gone forever as you make the journey across to Power BI." -- Matt Allington, June 2017.
- "... [Power BI] relationships are in a way the end of VLOOKUP." -- Avi Singh, May 2017.
- "... define your [explicit] measures rather than dragging columns and using the built-in summarization..." -- Avi Singh, May 2017.
- "... when you see a repeating number pattern ... look for ... is there a relationship between the tables." -- Avi Singh, May 2017.
- "The good news is that Power BI Desktop is essentially a cut-down version of SSAS Tabular." -- Phil Seamark, March 2017.
- "... bidirectional relationships ... are probably one of the most dangerous features ... " -- Alberto Ferrari, March 2016.
Books:
- R. Rad, L. Etaati, Getting Started with Power Query in Power BI and Excel, RADACAD, 2021.
- R. Rad, L. Etaati, Mastering Power Query in Power BI and Excel, RADACAD, 2021.
- F. Puppini, B. Inmon, The Unified Star Schema, Technics Publications, 2020.
- M. Russo, A. Ferrari, The Definitive Guide to DAX, 2nd Ed., Microsoft Press, 2019 / 2015.
- P. Seamark, Pro DAX with Power BI: Business Intelligence with PowerPivot and SSAS Tabular, Apress, 2019.
- P. Seamark, Beginning DAX with Power BI: The SQL Pro's Guide, Apress, 2018.
- G. Raviv, Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, Microsoft Press, 2018.
- A. Ferrari, M. Russo, Analyzing Data with Power BI and Power Pivot for Excel, Microsoft Press, 2017.
- R. Kimball, M. Ross, The Data Warehouse Toolkit, 3rd Ed., Wiley, 2013 / 1996.
- L. Corr, J. Stagnitto, Agile Data Warehouse Design, DecisionOne Press, 2011.
- W.H. Inmon, Building the Data Warehouse, 4th Ed., Wiley, 2005 / 1992.
- R. Kimball, M. Ross, The Data Warehouse ETL Toolkit, Wiley, 2004.
Websites/Videos/Podcasts:
- Zakhar Yung, "Power BI Conditional Formatting: A Guide for Beginners", Blog Article, Dec 2023.
- Avi Singh, "What is Power BI?", YouTube video, Oct 2023.
- Avi Singh, "What are the Key Components of Power BI?", YouTube video, Oct 2023.
- Chris Webb, "The 'Visual Has Exceeded The Available Resources' Error in Power BI Desktop", Blog Article, June 2023.
- Wyn Hopkins, "How to Use Pivot in Power Query and Avoid the Errors", YouTube video, June 2023.
- Wyn Hopkins, "Excel vs. Power BI Compared", YouTube video, March 2023.
- Wyn Hopkins, "How to Sell Power BI to the Excel Crowd", YouTube video, Jan 2023.
- Chris Webb, "How Much Data Can You Load Into Power BI?", Blog Article, Nov 2022.
- Wyn Hopkins, "What is Power BI? ... How to Learn Power BI", YouTube video, Oct 2022.
- Chandeep Chhabra, "[Power Query] each & Underscore Explained", YouTube video, Oct 2022.
- Jeroen ter Heerdt, "Data Modeling", Power BI Community Times in South Florida talk, June 2022.
- Alberto Ferrari, "(DAX 101) Variables", SQLBI video, Aug 2022.
- Alberto Ferrari, "(DAX 101) KEEPFILTERS", SQLBI video, June 2022.
- Alberto Ferrari, "(DAX 101) Understanding Context Transition", SQLBI video, May 2022.
- Alberto Ferrari, "(DAX 101) CALCULATE", SQLBI video, April 2022.
- Alberto Ferrari, "(DAX 101) Filter Context", SQLBI video, April 2022.
- Alberto Ferrari, "(DAX 101) Row Context", SQLBI video, March 2022.
- Dominick Raimato, "How Do I Connect to REST APIs with Power BI? (Part 3)", Blog Article, Feb 2022.
- Dominick Raimato, "How Do I Connect to REST APIs with Power BI? (Part 2)", Blog Article, Feb 2022.
- Dominick Raimato, "How Do I Connect to REST APIs with Power BI? (Part 1)", Blog Article, Jan 2022.
- Wyn Hopkins, "How and Why to Unpivot Data with Power Query", YouTube video, Dec 2021.
- Reza Rad, "Skills Needed for a Power BI Developer", YouTube video, Dec 2021.
- Ed Hansberry, "The Skills Your Power BI Team Needs to Succeed", Vancouver Power BI & Modern Excel UG Talk, Nov 2021.
- Sourabh Dasgupta, "Power BI Masterclass: Data Modeling 101", Corporate Renaissance Group talk, Sep 2021.
- Adam Saxton, "DAX - Where Do You Start?", Guy in a Cube video, Sep 2021.
- Matthew Roche, "Roche's Maxim", DataGrillen talk, May 2021.
- Chris Webb, "Accessing API and Web Service Data using Power Query", RADACAD stream, Feb 2021.
- Matthew Roche, "Building a Data Culture with Power BI [and an Executive Sponsor]", Glasgow Data UG talk, Dec 2020.
- Ken Puls, "Excel & Power BI: Better Together", Calgary Power Platform User Group talk, Nov 2020.
- Alberto Ferrari, "(DAX 101) Evaluation of Variables", SQLBI video, Oct 2020.
- Alberto Ferrari, "(DAX 101) Measures vs. Calculated Columns", SQLBI video, Sep 2020.
- Matthew Roche, "Connecting to Excel in SharePoint Online from Power Query", YouTube video, Sep 2020.
- Reza Rad, "Data Modelling 101 with Power BI", MS Session, June 2020.
- Ruth Pozuelo Martinez, "How to Pivot Tables with Uneven Number of Columns", YouTube video, April 2020.
- Ruth Pozuelo Martinez, "Transpose, Pivot or Unpivot in Power Query?", YouTube video, April 2020.
- Ruth Pozuelo Martinez, "How to Fix the 'Too Many Elements...' Pivot Error in Power Query", YouTube video, March 2020.
- Miguel Escobar, "Handling Different Time Zones in Power BI / Power Query", Blog article, Oct 2019.
- Ken Puls, "Excel: Best Practices for Spreadsheet Modeling, Data Shaping, and Data", MS Business Applications Summit talk, June 2019.
- Phil Seamark, Jeffrey Wang, "Learning DAX? Five Things to Get You Started Fast", MS Session, June 2019.
- Gil Raviv, "MS Power Query", MS Session, June 2019.
- Avi Singh, "Power BI Pivot: Move Data from Rows to Columns Q&A", YouTube video, Aug 2018.
- Alex Petralia, "Technical Skills Every Business Analyst Should Have", Blog Article, June 2017.
- Ruth Pozuelo Martinez, "Unpivot Complex Data from Excel in Power Query", YouTube video, May 2016.
- Alberto Ferrari, "DAX 101", MS Workshop, March 2016.
- MuleSoft, "What is an API?", YouTube video, June 2015.
- Kenneth Cukier, "Big Data is Better Data", TED talk, June 2014.
- Chris Webb, "Working with Web Services in Power Query", Blog Article, March 2014.
- Wyn Hopkins, "How to Hide a Power BI Securely", YouTube video, Dec 2023.
- Wyn Hopkins, "Power BI On/Off Switch with the New Slicer Buttons", YouTube video, Nov 2023.
- Avi Singh, "How to Write any DAX Measure in Just 3 Easy Steps", YouTube video, June 2023.
- Rick de Groot, "Unpivot Columns and Keep Null Values in Power Query", BI Gorilla video, Mar 2023.
- Avi Singh, "3 Easy Ways to Create Your Power BI Calendar Table / Date Table", YouTube video, Aug 2022.
- Avi Singh, "How to Create Excel-like Fixed Reference $A$1 in Power BI", YouTube video, May 2022.
- Chandeep Chhabra, "Split by Variable Columns in Power Query", YouTube video, April 2022.
- Leila Gharani, "DAX CALCULATE Function Made Easy to Understand", YouTube video, Dec 2021.
- Patrick LeBlanc, "Use Page Navigator to go to the NEXT LEVEL in Power BI", Guy in a Cube video, Dec 2021.
- Patrick LeBlanc, "Use Bookmark Navigator in Power BI to Easily Move Through Bookmarks", Guy in a Cube video, Dec 2021.
- Alberto Ferrari, "7 Reasons DAX is Not Easy", YouTube video, Oct 2021.
- Rick de Groot, "Filter Column by List Items (Exact Match) in Power Query", BI Gorilla video, Sep 2021.
- Rick de Groot, "Replace Values in Multiple Columns based on Condition in Power Query", BI Gorilla video, Sep 2021.
- Yana Berkovich, "Visual Guidance in Power BI", Power BI Community Times in South Florida talk, Aug 2021.
- Avi Singh, "Power BI Relationships Not Working? (3/3) How to Add Missing Values Yourself", YouTube video, Aug 2021.
- Avi Singh, "Power BI Relationships Not Working? (2/3) How to Fix Missing and Blank Values", YouTube video, Aug 2021.
- Avi Singh, "Power BI Relationships Not Working? (1/3) Steps to Debug", YouTube video, July 2021.
- Rick de Groot, "Get n-th Value from Comma-Separated List in Power Query", BI Gorilla video, May 2021.
- Adam Saxton, "Mastering Power BI Bookmarks", Guy in a Cube video, April 2021.
- Ken Puls, "Quickly Solving the [Slowly Changing Dimension] SCD Challenge", Perth Power BI Usergroup Meetup talk, April 2021.
- Rick de Groot, "Performing a Full Anti Join in in Power Query - Compare Two Tables", BI Gorilla video, March 2021.
- Rick de Groot, "Documenting and Structuring Queries in Power Query", BI Gorilla video, March 2021.
- Marco Russo, "DAX Filter Context in One Hour", Power BI Community Times in South Florida talk, March 2021.
- Alberto Ferrari, "Bidirectional Relationships and Ambiguity", YouTube video, Nov 2020.
- Patrick LeBlanc, "Why You Should Use DAX Studio with Power BI", Guy in a Cube video, Nov 2020.
- Bryan Cafferky, "Understanding Slowly Changing Dimensions (SCD's)", YouTube video, Oct 2020.
- Mynda Treacy, "Getting Started with Power Query APIs", MyOnlineTrainingHub video, Oct 2020.
- Marco Russo, "How to Debug a DAX Measure [using DAX Studio]", SQLBI video, Aug 2020.
- Francesco Puppini, Bill Inmon, "Building the Unified Star Schema", UK Data Vault User Group talk, July 2020.
- Marco Russo, "Analyzing a Slow Report Query in DAX Studio", SQLBI video, July 2020.
- Chris Barber, "Data Modelling: Disconnected Tables, Snowflake and Junk Dimensions", London Business Analytics Group talk, July 2020.
- Chris Barber, "Data Modelling: From Single Table to Star Schema", London Business Analytics Group talk, July 2020.
- Adam Saxton, "How Do You Get a REFRESH DATE In Your Power BI Report???", Guy in a Cube video, June 2020.
- Patrick LeBlanc, "Conditional Navigation is an INSANE AMAZING Way to Change Pages in Power BI ", Guy in a Cube video, June 2020.
- Marco Russo, "Finding the Slowest Measure in a DAX query [using DAX Studio]", SQLBI video, May 2020.
- Adam Saxton, "Power BI REST API No-Code Options", Guy in a Cube video, July 2019.
- Peter Myers, "The Do's and Don'ts of Power BI Relationships", MS Business Applications Summit, June 2019.
- Marco Russo, "Power BI: Deep Dive into DAX Evaluation Context", MS Business Applications Summit talk, June 2019.
- Alan Murray, "Compare Two Lists in Excel using Power Query", YouTube video, May 2019.
- Bryan Cafferky, "Analysis Services: The Tabular Model and Why You Need It", YouTube video, Sep 2018.
- Bryan Cafferky, "Analysis Services: Tabular versus Multidimensional Models", YouTube video, Aug 2018.
- Parker Stevens, "Power BI - Show Parameters in Report", YouTube video, April 2018.
- Bryan Cafferky, "Dimensional Modeling: The Heart of the Data Warehouse", YouTube video, Aug 2017.
- Avi Singh, "Power Query, Power Pivot, Excel, Power BI (PPEP)", YouTube Video, Sep 2017.
- Avi Singh, "DAX Measures: Understanding Filter Context using SUMX Example (I.C.A.N. Rule) Part 2/2", YouTube video, Aug 2017.
- Avi Singh, "DAX Measures: Understanding Filter Context using SUMX Example (I.C.A.N. Rule) Part 1/2", YouTube video, Aug 2017.
- Avi Singh, "DAX Measures: Understanding Filter Context using DATESYTD Example (I.C.A.N. Rule)", YouTube video, July 2017.
- Avi Singh, "DAX Measures: Filter Context Explained in Simple Terms using the I.C.A.N. Principle", YouTube video, July 2017.
- Will Thompson, Matt Allington, "DAX 50", MS Session, June 2017.
- Chris Webb, "Working with Parameters and Functions", MS Session, June 2017.
- Ted Way, "Data Science for Analysts", MS Session, June 2017.
- Alberto Ferrari, "Advanced DAX", MS Workshop, March 2016.
- Avi Singh, "Power BI Tutorial for Beginners (1.5.3): Report Viz (Publish Dashboards)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.5.2): Report Viz (Best Practices)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.5.1): Report Viz (Drill-down, Format)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.4.5): DAX → Measures (vs. Excel Formulas)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.4.4): DAX → Measures (Composite Measures)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.4.3): DAX → Measures (Slicers & Filters)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.4.2): DAX → Measures (Analyze in Excel)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.4.1): DAX → Measures (Implicit vs. Explicit)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.3.2): DAX → Measures (vs. Calculated Columns)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.3.1): DAX → Calculated Columns", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.2.2): Relationships → End of VLOOKUPs!", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.2.1): Relationships → Data and Lookup Tables", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.1.4): Get Data → Self-Documenting Applied Steps", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.1.3): Get Data → Query Editor (Unpivot Columns)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.1.2): Get Data → Query Editor (Row Filtering)", YouTube Video, May 2017.
- Avi Singh, "Power BI Tutorial for Beginners (1.1.1): Get Data → Load", YouTube Video, May 2017.
Best viewed at
1280x720 (720p) screen resolution or higher.