Top 10 Blog Posts of 2016



2016 was the year of raising Power BI in my opinion, Here is the list of top 10 blog posts that you clicked mostly in this year;

  1. How to Do Power BI Mapping with Latitude and Longitude Only. This post was written when Power BI didn’t supported latitude and longitude only for map visualization. Nowadays you can do it easily, however there still sometimes that you need to go through this process.
  2. Online Power BI from Rookie to Rock Star. The table of content with links to all blog post series of Power BI online book. Good news is that I’m working on publishing a PDF version of it soon.
  3. How to Change Joining Types in Power BI and Power Query. Power BI and Power Query has different types of joins, this post explain how to change the join type.
  4. Incremental Load Change Data Capture in SSIS. Incremental Load is always the tricky topic, and most wanted as well. This post is full explanation of how to do Incremental Load with Change Data Capture feature in SSIS. CDC is now supported in all editions of SQL Server 2016 SP1, so this method now should be the most popular method I believe.
  5. Custom Visuals in Power BI; Build Whatever You Want. Power BI wouldn’t go this far in the market without ability to write your own custom visual and use heaps of existing ones. In this post I explained how custom visuals can be used to enhance your Power BI dashboard.
  6. Power BI Filled Map; the Good, the Bad, and the Ugly. Power BI filled map works best if you are dealing with US based geo coding, it won’t work good when you work in areas that geo coding is different, read this post to understand what type of issues you might face with this visual.
  7. Introduction to Power BI: What is Power BI? Power BI was the most interesting topic of the year, and as a result everyone was looking for an introduction to Power BI with samples, this is the post about that.
  8. Walk through Steps: I’m New to BI, Where to Start? Part 5 – Power BI. This blog post is one of 7 blog post series of I’m new to BI, Where to Start, which was very popular in 2015. In 2016 the Power BI post of that is still among the top 10 blog posts.
  9. KPIs and Power BI. There are different methods of visualizing KPIs in Power BI, with built-in KPI visual or with custom visuals. Read this post to learn about different methods of doing KPIs.
  10. Scenarios of Using Calculated Tables in Power BI. Calculated Tables are DAX generated tables which can be useful for some situations. In this blog post I’ve wrote couple of examples of scenarios that these tables can be useful.

Happy New Year 🙂

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 nine 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.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog:
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
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.

Leave a Reply