Top 10 Blog Posts of 2016

Posted by on Jan 4, 2017 in Power BI, SQL Server | No Comments


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
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 *