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

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 12 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, Power BI Summit, and Data Insight Summit.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
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.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.