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.
We have seen many methods of using Excel and related Power BI tools for analyzing data. Now, all that can be done WITHOUT using Excel – using a stand-alone tool called Power BI Desktop. Here is how you do it.
Unwanted or redundant columns can confuse the users of Pivot Table. Here is how you can remove unwanted columns from appearing in the Pivot Table field list.
This is continuation of the previous article. In this article, we will see another way of creating Histograms using Pivot Tables.
Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.
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.
We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost.
Act Now is a new idea I am trying. It asks you to do some activity and post the results.
Consider a pivot table which has many fields in row as well as column area. Now, for whatever reason, you have to transpose the pivot table. Whatever is in the rows has to go into columns and vice versa. We cannot use Paste Special Transpose with Pivots.
The only choice seems to be manually dragging and dropping fields across row and column areas. Not only is this cumbersome, but it can also lead to mistakes. Don’t worry. I just found a smarter way.
Add a Pivot Chart. Never mind which type. Choose Pie because it takes least amount of effort graphically and it happily ignores child series of data. Now click inside the chart. Choose Design tab and click Switch Rows / Column. It instantly transposes the row and column fields. Delete the chart. Job done.
This works with Power Pivots as well. For large pivot tables, you may get the maximum series limit reached error for charts. Ignore that error and continue – because in this case, the chart is just a temporary means of achieving transpose operation.
Now that we know about Recommended Charts, let us explore it in-depth. This is an implementation of artificial intelligence or machine learning at your fingertips. Don’t underestimate it… exploit it.
There are two types of charts. First type is a chart which you create to interpret data more effectively. The second type is more common. These charts are created billions of times everyday – why? Because boss wants it that way!
In this article, I am going to attempt to change the mindset of all users of Charts. Please spend 5 minutes of your time reading this article and trying out a new thought process. I am confident that it will add value to your life.