Simple CSV to Interactive Dashboard – Power BI Desktop walk-through

In the earlier article, we saw how Power BI Desktop can help us create complex, interactive and useful reports from various sources of data.

Here is a detailed walk-through of how exactly to use this tool. In this video we will use the simplest possible scenario: Start with a simple CSV file, create a report, publish it on Power BI site and share it with a colleague. We will also see the Power BI mobile app in action.

Download this sample CSV file (ZIP) if you want to follow along. 12 min video. Watch it in full screen mode at highest resolution.

 

Photo credit: kevin dooley via Foter.com / CC BY

Instant benefit: Try Distinct Count wherever you are using Count

SUM and COUNT are the most common methods of summarizing data. It is easily done in Pivot Table or any other analytical tool. What is equally important is DISTINCT COUNT. But it is not commonly used. Why not? Firstly, due to lack of awareness and secondly, due to lack of that feature in Pivot Table. Let us solve both problems in the next 10 minutes.

image

Continue reading