In the previous article, we saw a video of how the New Year progresses across time zones. This video shows you how to use Power Map to create the animated time zone video. Download this file and try it yourself.
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, I will illustrate how it was done. Enjoy.
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.
Hello from New Zealand. Here for 5 days conducting over 15 sessions for key customers.
We have seen how to use Power Map for Excel and create geographical visualizations. Read these articles for details. We will plot a flight path using Power Map in this article. Here is how it looks.
Yes. That is right. If you have worked with lots of customers, providing a list of customers consumes lot of space and nobody reads it anyway! Why not show the customers you have worked with in a region or globally by plotting them on a map? Here is how you do it – in just 2 minutes – if you have the data ready.
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.
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
|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
|Recently I conducted a session for BI team of a large customer.
This introduces the concept of end user BI to hard core developers.
Have a look. It will give you a different perspective.
2 hour video.