I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already know – Pivot Tables. That is why the course is called Pivot Table to Power BI.
Although Power View and Power BI reports are similar, Microsoft is focusing on the later. Power BI platform is being separated out from Excel for many reasons. One of the reasons is to eliminate the dependence upon Silverlight (technology used to create Power View, which is now being phased out).
Here is a 2 minute video which explains how to convert Excel based Power BI components like data mode, queries, relationships and Power View dashboards into Power BI Desktop. Once converted, you can publish these to the Power BI portal.
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here.
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 field.
Thank you for the overwhelming response for Data Analytics webinar video. More than 800 attendees, 70+ questions.
Watch the video on YouTube (use 720P) or Download (MP4, 188 mb, 60 min) and view on your PC. A big thank you to the Microsoft and Economic Times team for making this possible.
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 reading time 8 min
Pictures in Excel reports:
This is available only with Excel 2013 Professional Edition and Office 365 Edition. Try it out right now. Enhance your reports. Make them more visual and easier to interpret. Use logos, product shots, country flags, features, people, locations, buildings, spare parts, posters, icons, anything visual.
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
Estimated reading time 7 min.
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 7 min
In this article, we will explore more benefits of using Power View in comparison with Pivot Table.
Estimated reading time 12 min