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

Posted by on Jul 12, 2017 in Power BI, Publications | No Comments
Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

2017-07-12_15h10_49

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

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.
Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">