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.
Download Free PDF Version
** 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.
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?
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?
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
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
- Introduction to Power BI
- Getting Data
- What Is Power Query? Introduction to Data Mash-up Engine of Power BI
- Get Started with Power Query: Movies Data Mash-Up.
- Power BI Get Data from Excel: Everything You Need to Know.
- Power BI Get Data: From Azure SQL Database.
- Meetup Data Source for Power BI
- Power BI and Spark on Azure HDInsight; Step by Step Guide.
- Data Transformation with Power Query
- Data Preparation; First and Foremost Important Task in Power BI
- Warning! Misleading Power Query Filtering.
- Flawless Date Conversion in Power Query.
- Make Your Numeric Division Faultless in Power Query.
- Pivot and Unpivot with Power BI
- Grouping in Power Query; Getting The Last Item in Each Group.
- Append vs. Merge in Power BI and Power Query.
- Power Query Functions
- M: Power Query Formula Language
- Power Query Use Cases
- Do You Need a Date Dimension?
- Script to Generate Date Dimension with Power Query M – With Financial Columns.
- Be Fitbit BI Developer in Few Steps: First Step Get Data from CSV.
- Be Fitbit BI Developer in Few Steps: Step 2 Loop Through All CSV Files.
- Power Query Not for BI: Event Date and Time Scheduler – Part 1.
- Power Query Not for BI: Event Date and Time Scheduler – Part 2.
- Power Query Not for BI: Event Date and Time Scheduler – Part 3.
- Data Modeling
- M or DAX? That is the Question!
- Secret of Time Intelligence Functions in Power BI
- Lost Customers DAX Calculation for Power BI
- Scenarios of Using Calculated Tables in Power BI
- Solving DAX Time Zone Issue in Power BI
- Overwrite Interaction of Power BI with DAX.
- Previous Dynamic Period DAX Calculation.
- IF and Filter are Different! Be Careful (DAX)
- Data Visualization
- Control the Interaction in Power BI Report
- Grouping and Binning; Step Towards Better Data Visualization.
- Custom Visuals in Power BI; Build Whatever You Want
- Power Behind the Line Chart in Power BI; Analytics.
- Stacked Chart or Clustered? Which One is the Best?
- Power BI Waterfall Chart: What’s That All About?
- Storytelling with Power BI Scatter Chart
- KPIs and Power BI; Visualization Aspect
- Filtering Slicer Resolved in Power BI
- Be Fitbit BI Developer in Few Steps: Step 3 Visualization.
- Map Visualization
- Power BI Service
- Sharing Content
- Security in Power BI
- Real-time Dashboards
- Performance Tuning
- Power BI for Developers
- Integrate Power BI into Your Application: Part 1 – Register your App.
- Integrate Power BI into Your Application: Part 2 – Authenticate.
- Integrate Power BI into Your Application: Part 3 – Embed Content
- Integrate Power BI into Your Application: Part 4 – Refresh Data Set
- Integrate Power BI into Your Application: Part 5 – Data Source Management
- Power BI Training.