Online Book: Power BI From Rookie to Rockstar

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

download

The idea of writing a book on Power BI is not new for me, I’ve been thinking about it for a while, even before first release of Power BI Designer. However Power BI is fast paced technology, Microsoft Product team is doing great job with monthly , and sometimes even more frequent updates. With this fast pace release any book publishing would be out dated once the book comes out in the market. Publishing a book takes time, writing TOC, then chapters, building demos, peer reviews, proof reading, test, feedback, revise on reviews, and publishing take long time. I’ve been in publishing process of some books and I am completely aware of that. So I though it would be better to write a book online on this blog rather than spending heaps of time on paper publish. There are some reasons that I thought about writing this book online and writing that for free which I like to mention in this preface.

** Table of Content with link to articles is down at the bottom of this post

Why I Don’t Publish it ….

There is nothing wrong with publishers such as Apress, Wrox and etc, these are great publishers. However I have to spend lots of time to get them read my proposal first, and then set the schedule, and write, review…. to publish. This is a long way as I mentioned above. With fast-paced technologies such as Power BI this long process won’t work, actually the time that book be available in the market it will be out-dated for sure. When I write it online, I can write faster, I can write like a blog post, and I can write it everyday. If technology updates, I’ll write an update blog post. It is all easy and on-time.

Why Free?

I never write book for money, I write because I like to get a wider audience in front of me, and tell them about the great product, and best practices of doing things with that and so on. With famous publishers I would definitely get more audience. However when the content be available for free, and online then everyone would read it, search engines would direct audience to this content, and audience range will expand.

Why Power BI?

0

Haven’t you heard the news? Power BI Desktop released with superb features, there is a massive push in Microsoft for updating Power BI regularly and frequently which makes this product better and better each month, There are so much awesome things that you can do with Power BI, and many other reasons. I actually have to search for reasons why not Power BI!

How Frequent Would I Write?

8140770540_b986f6cb54_b

Well, I planned for writing at least a post every day for that, and with the count of days till end of the year (about 147 days from now), even if I could make only 100 days of writing on this book, I’ll be able to have it in a very good stage at end of 2015. That said, the content would be available everyday, so you won’t need to wait till end of the year to read something. you can just read it everyday. I encourage you to subscribe to this blog to receive email when the content is available.

What I Expect From You?

Feedback, Comments, Questions, Real-World Challenges about Power BI. I’m writing blog posts anyway, it will get better and better if I get feedback from you. I can put more examples if I know your real-world challenges with Power BI. I can answer your questions along the way, that answer might help some others with similar problems as well.

Who Is This Book For?

BI Developers and Consultants who want to know how to develop solutions with this technology. BI Architects and Decision Makers who want to make their decision about using or not using Power BI in their BI applications. Business Analysts who want to have better tool for playing with the data and learn tricks of producing insights easier. The book titled “Power BI From Rookie to Rockstar”, and that means it will cover wide range of readers. I’ll start by writing 100 level and we will go deep into 400 level at some stage. So if you don’t know what Power BI is, or If you are familiar with Power BI but want to learn some deep technical topics about Power Query M language, then this book is for you.

 

 

Table of Content

download1

Like any other books I like to share the Table of Content here. The Table of Content is highly subject to change at this stage. I’ll update the table of content along the way.

 

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. File Sources
    5. Folder as a Source
    6. Database Sources
    7. Analysis Services Connection
    8. Get Data From Azure SQL Database
    9. Azure SQL Data Warehouse Source
    10. Software as A Source
    11. Web Source
    12. Using Web Service / API As a Data Source for Power BI
    13. R Script as a Source
    14. Power BI and Spark on Azure HDInsight; Step by Step Guide
  3. Data Transformation
    1. Query Editor
    2. Transformation GUI
    3. Row Transformations
    4. Warning! Misleading Filtering in Power Query
    5. Column Transformations
    6. Data Type
    7. Flawless Date Conversion in Power Query
    8. Adding Column
    9. Text Transformations
    10. Number Column Calculations
      1. Make Your Numeric Division Faultless
    11. Date and Time Calculations
    12. Pivot and UnPivot
    13. Grouping in Power Query
    14. Append vs Merge in Power BI
  4. Power Query Formula Language
    1. Code Behind of Power Query: M
    2. Data Types in M
    3. M Lexical Structure
    4. Working with Functions
    5. Error Handling
  5. Power Query Built-in Functions
    1. Date Functions
    2. Time Functions
    3. Text Functions
    4. Table Functions
    5. List Functions
    6. Folder.Files vs Folder.Contents: Fetch Files and Folders with Masking/Filtering
    7. Record Functions
    8. Number Functions
    9. Cube Functions
    10. Data Access Functions
    11. Type Functions
      1. Convert Time Stamp to Date Time
    12. Splitter and Combiner Functions
    13. Power Query Function’s Library; #shared Keyword
  6. M Advanced
    1. Custom Function Made Easy in Power BI Desktop
    2. Using Generators
    3. Error Handling
    4. Example of Power Query Function Using Generators, Each Singleton Function, and Error Handling
    5. Writing Complex Transformations with M
    6. Return Multiple Values from Power Query Function
    7. Dynamic M
  7. Power Query Use Cases
    1. Date Dimension With Power Query
    2. Fitbit Data Integration Part 1
    3. Fitbit Data Integration Part 2
    4. Power Query Not For BI – Part 1
    5. Power Query Not For BI – Part 2
    6. Power Query Not For BI – Part 3
  8. Data Model
    1. Loading Data into Model
    2. Introduction to Power Pivot
    3. Sort By Column
    4. Relationships
    5. Relationship with Multiple Columns
    6. Measures
    7. Formatting
    8. Calculated Columns
  9. DAX
    1. Data Analysis eXpression Language
    2. Function Categories
    3. Secret of Time Intelligence Functions in Power BI
    4. Date and Time Functions
    5. Time Intelligence Functions
    6. Math and Trig Functions
    7. Statistical Functions
    8. Text Functions
    9. Customer Retention with DAX
  10. Advanced DAX
    1. Filter Functions
    2. Calculated Tables; Scenarios of using
    3. Best Practices for Writing DAX
    4. Role Playing Dimension
    5. Relationship tips and tricks
    6. Solving DAX Time Zone Issue in Power BI
  11. Data Visualization
    1. Building Charts
    2. Customizing Charts
    3. Page Level Filters
    4. Object Level Filter
    5. Control the Interaction in Power BI Report
    6. Adding Text and Image
    7. Table View
    8. Matrix View
    9. Card View
    10. Slicer
    11. Grouping and Binning; Step Towards Better Visualization
  12. Custom Visuals
    1. Custom Visuals; Built Whatever You Want
    2. Developing Custom Visuals
    3. Azure Machine Learning and SandDance Visualization
  13. Charts
    1. Bar, Column Chart
    2. Power Behind the Line Chart
    3. Stacked Chart or Clustered, Which One is the Best?
    4. Column Line Chart
    5. Area Chart
    6. Waterfall Chart
    7. Storytelling with Scatter Chart
    8. Pie, Donut Chart
    9. Treemapping
    10. Interactive R Charts in Power BI
    11. Map
    12. Power BI Says Hi to 3D Map
    13. Map Visualization with Latitude and Longitude Only
    14. Filled Map; the Good, the Bad, and the Ugly
    15. Funnel
    16. KPI and Power BI
  14. Special Tips and Tricks
    1. Color Saturation
    2. Sparkline
    3. Colorful Slicers
    4. Using Maps in Different Levels
    5. Showing Multiple Measures
    6. Data Visualization Best Practices
    7. Filtering Slicer Resolved in Power BI
    8. Step Beyond 10GB Limitation of Power BI
  15. Power BI Services
    1. Publish to Power BI site
    2. Creating Dashboards
    3. Dashboards vs Report; Differences at a Glance
    4. Power BI Publish to Web; Questions Answered
    5. Scheduled Data Refresh
    6. Schedule Data Refresh Local Excel File from Power BI Website
    7. Datasets in Power BI
    8. Power BI Pro
    9. Groups in Power BI
  16. Security in Power BI
    1. Row Level Security
    2. Row Level Security Configuration in Power BI Desktop
    3. Row Level Security with SSAS Tabular Live Connection in Power BI
    4. Dynamic Row Level Security with Power BI Made Simple
  17. Gateways
    1. On-Premises SQL Server Live Connection with Enterprise Gateway
    2. Definitive Guide to Power BI Personal Gateway
    3. Loop Through On-Premises Files with Power BI and Schedule it to Refresh Automatically
  18. Power Q&A
    1. Introduction to Power Q&A
    2. Develop a Model that Responds Best to Power Q&A
    3. Tips and Tricks
  19. Mobile
    1. Tips for Mobile Friendly Report Development in Power BI
    2. Dashboard Design for Mobile Power BI
  20. Integration
    1. Power BI Story in Power Point Slides with Commentary
    2. Power BI Embedded; Bring the Power into your Application
  21. Real-time Dashboards
    1. Azure Stream Analytics and Power BI join forces to Real-time Dashboard
    2. Monitor Real-time Data with REST API
  22. Performance Tuning
    1. Performance Tip for Power BI; Enable Load Sucks Memory Up
    2. Not Folding; the Black Hole of Power Query Performance

 

 

TOC above is subject to change. Stay tuned for next blog posts.

 

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

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.

33 Comments

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="">