Edition 3 of Free Book: Power BI from Rookie to Rock Star – 1075 Pages!


Busy schedule in last few months with lots of conferences and courses didn’t allowed me to publish 3rd version earlier. and now, here you go; 3rd edition of Power BI from Rookie to Rock Star book is available to download. this edition ended up with being 1075 pages! This book is already downloaded more than 11K times (from Feb 2017 till now). Here is the most up-to-date table of content for the book. and link to download. This edition includes updates on ArcGIS, Power BI Premium, Power BI for Developers and some other contents added to it.


Download Power BI from Rookie to Rock Star


Table of Content

  1. Introduction to Power BI
    1. Introduction to Power BI: What is Power BI?
    2. Power BI Desktop; The First Experience.
    3. Power BI Website: You’ll Need Just A Web Browser.
  2. Getting Data
    1. What Is Power Query? Introduction to Data Mash-up Engine of Power BI
    2. Get Started with Power Query: Movies Data Mash-Up.
    3. Power BI Get Data from Excel: Everything You Need to Know.
    4. Power BI Get Data: From Azure SQL Database.
    5. Meetup Data Source for Power BI
    6. Power BI and Spark on Azure HDInsight; Step by Step Guide.
  3. Data Transformation with Power Query
    1. Data Preparation; First and Foremost Important Task in Power BI
    2. Warning! Misleading Power Query Filtering.
    3. Flawless Date Conversion in Power Query.
    4. Make Your Numeric Division Faultless in Power Query.
    5. Pivot and Unpivot with Power BI
    6. Grouping in Power Query; Getting The Last Item in Each Group.
    7. Append vs. Merge in Power BI and Power Query.
  4. Power Query Functions
    1. Fetch Files and/or Folders with Filtering and Masking: Power Query.
    2. Power Query; Convert Time Stamp to Date Time.
    3. How to Change Joining Types in Power BI and Power Query.
    4. Power Query Library of Functions; Shared Keyword.
  5. M: Power Query Formula Language
    1. Basics of M: Power Query Formula Language.
    2. Custom Functions Made Easy in Power BI Desktop.
    3. Day Number of Year, Power Query Custom Function.
    4. Power Query Function that Returns Multiple Values.
    5. Get List of Queries in Power BI
    6. Exposing M Code and Query Metadata of Power BI (PBIX) File.
  6. Power Query Use Cases
    1. Do You Need a Date Dimension?
    2. Script to Generate Date Dimension with Power Query M – With Financial Columns.
    3. Be Fitbit BI Developer in Few Steps: First Step Get Data from CSV.
    4. Be Fitbit BI Developer in Few Steps: Step 2 Loop Through All CSV Files.
    5. Power Query Not for BI: Event Date and Time Scheduler – Part 1.
    6. Power Query Not for BI: Event Date and Time Scheduler – Part 2.
    7. Power Query Not for BI: Event Date and Time Scheduler – Part 3.
  7. Data Modeling
    1. Sort by Column in Power BI
    2. Relationship in Power BI with Multiple Columns.
  8. DAX
    1. M or DAX? That is the Question!
    2. Secret of Time Intelligence Functions in Power BI
    3. Lost Customers DAX Calculation for Power BI
    4. Scenarios of Using Calculated Tables in Power BI
    5. Solving DAX Time Zone Issue in Power BI
    6. Overwrite Interaction of Power BI with DAX.
    7. Previous Dynamic Period DAX Calculation.
    8. IF and Filter are Different! Be Careful (DAX)
  9. Data Visualization
    1. Control the Interaction in Power BI Report
    2. Grouping and Binning; Step Towards Better Data Visualization.
    3. Custom Visuals in Power BI; Build Whatever You Want
    4. Power Behind the Line Chart in Power BI; Analytics.
    5. Stacked Chart or Clustered? Which One is the Best?
    6. Power BI Waterfall Chart: What’s That All About?
    7. Storytelling with Power BI Scatter Chart
    8. KPIs and Power BI; Visualization Aspect
    9. Filtering Slicer Resolved in Power BI
    10. Be Fitbit BI Developer in Few Steps: Step 3 Visualization.
  10. Map Visualization
    1. How to Do Power BI Mapping With Latitude and Longitude Only.
    2. Power BI Says Hi to 3D Maps.
    3. Shape Map Better than the Filled Map.
    4. Power BI Filled Map; the Good, the Bad, and the Ugly.
    5. ArcGIS Map in Power BI; Simple, But Insightful
  11. Architecture
    1. Step Beyond the 10GB Limitation of Power BI
    2. One Data Set, Multiple Reports; Power BI Next Big Step Forward.
  12. Power BI Service
    1. Dashboard vs Report; Differences At a Glance – Power BI
    2. Power BI Q&A; How to Ask Questions?
    3. Dashboard Design for Mobile Power BI
    4. Schedule Refresh Local Files on Power BI Web Site.
  13. Sharing Content
    1. Power BI Publish to Web – Questions Answered.
    2. Groups in Power BI
    3. Content Pack; Sharing, Self-Service and Governance Together.
    4. Ultimate Sharing Strategy: Power BI Apps.
  14. Security in Power BI
    1. Row Level Security Configuration in Power BI Desktop.
    2. Row Level Security with SSAS Tabular Live Connection in Power BI
    3. Dynamic Row Level Security with Power BI Made Simple.
  15. Gateways
    1. Definitive Guide to Power BI Personal Gateway.
    2. Step by Step Walk through: On-Premises Live SQL Server Connection with Power BI Enterprise Gateway.
    3. Loop Through On-Premises Files with Power BI and Schedule it to Refresh Automatically.
  16. Integration
    1. Power BI On-Premises; Hello World!
    2. Power BI Story in PPT Slides with Comments.
    3. Bring the Power into Your Application; Power BI Embedded.
  17. Real-time Dashboards
    1. Stream Analytics and Power BI Join Forces to Real-time Dashboard.
    2. Monitor Real-time Data with Power BI Dashboards.
  18. Performance Tuning
    1. Performance Tip for Power BI; Enable Load Sucks Memory Up.
    2. Not Folding; the Black Hole of Power Query Performance.
  19. Licencing
    1. Power BI Premium. Is It For You or Not?
  20. Power BI for Developers
    1. Integrate Power BI into Your Application: Part 1 – Register your App.
    2. Integrate Power BI into Your Application: Part 2 – Authenticate.
    3. Integrate Power BI into Your Application: Part 3 – Embed Content
    4. Integrate Power BI into Your Application: Part 4 – Refresh Data Set
    5. Integrate Power BI into Your Application: Part 5 – Data Source Management
  21.  Power BI Training.
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 12 continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand, Power BI Summit, and Data Insight Summit.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.

2 thoughts on “Edition 3 of Free Book: Power BI from Rookie to Rock Star – 1075 Pages!

  • Your book and blog are terrific. I’m a newbie. I’ve programmed VBA in Excel, Access and Word. This is new to me and find it very interesting. But when I tried to create the map (page 56 in the book), my map doesn’t look like yours. The map incorrectly recognizes the addresses. Why is my map producing different results? The cities are in the wrong locations on the map.It looks like the map is taking the street address and applying it to local cities in my state. Thanks in advance for answering my question.

    • Hi Thom,
      Thanks for your kind words.
      For getting the best result for Map; it is always better to build a full address type of field. something like: Street address, City, State, Country. Because Bing map is always search based on the term provided, then better full address than an individual field. I’ll write about this in another post later sometime.

Leave a Reply