Common mistake – Power BI free version not used
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
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
Unbelievable analytics using Excel: [youtube https://www.youtube.com/watch?v=vcwPk3eUxkg?rel=0] Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection
This is a series of articles about people like me who deliver demos, conduct workshops and speak at keynotes. I will share what I have learnt about delivering high-impact demos
Earlier we saw how to create a Power View based dashboard. How to show this in PowerPoint? A better question is – WHY show it using PowerPoint? Estimated reading time
In this article, we will explore more benefits of using Power View in comparison with Pivot Table. Estimated reading time 12 min