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
Here is an animated globe showing the new year dawning across time zones. Created using Power Map. You can also create it using Excel 2013 onwards. In the next article,
Often we get data which is distributed in multiple column sets. Here is how you can convert it to good data (tabular column format) using Power Query. Watch the video.
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.
Office 365 plans which include Office Pro Plus are capable of running Power Pivot, Power Query, Power View and Power Map. Extremely powerful tools. Highly popular with users and top
Presentation download with reference links Download the Presentation (3 MB). I have added lots of links to related articles and external references including books written by stalwarts in Excel analytics
Power Query is an amazing tool for importing and cleaning up data from various sources. The problem was that it required you to have professional version of Office. Now that
There are two simple approaches in reversing row order. One is to add an extra column with serial numbers and then sort on that column in descending order. This works
It is a powerful but often ignored feature of Power Pivot. It allows you to describe the meaning of the data column – independent of its field name. Estimated
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
