Power BI is powerful, as the name suggests. But it is also confusing. Exactly what what does Power BI mean? There is no simple, single line answer. Let me try. It is a set of new tools to analyze old data in new ways. Today the simplest way to get started it to sign up for a free Power BI subscription and use Power BI Desktop tool to create your reports and dashboards. I have already written an introductory article and published a walkthrough video.
I feel this is one tool which can transform the way we work on data and analyze it. The primary reason is that it is independent of Excel. So all the bad habits which we have developed in Excel over decades simply disappear! I am planning to create a course on Udemy for Power BI Desktop. I would like your inputs on the content and any additional ideas or wish list. Read on to have a look and post your comments. You can also send a mail to me on firstname.lastname@example.org
Continue reading Power BI Desktop course – Need your inputs
See how easy it is to choose pivot tables and charts from multiple Excel files to create a single dashboard.
In this article we will see how to manage running totals and Ranking within Pivot Table calculations.
Estimated reading time 7 min Continue reading Pivot: Running Totals and Ranking
This article shows how to find difference from a specific value to other values in a Pivot Table. % Difference From is a very powerful way to understand your data more closely.
Try it out…
Estimated reading time 14 min
Continue reading Pivot : Show Values As – Part 3
Current fashion is about Big Data and Analytics. One related term is very popular – Excel Dashboards. Let us start understand the concept first and then explore the benefits and methods of creating useful Dashboards.
Estimated reading time 10 min
Continue reading Understanding Excel Dashboards – the practical way.