Power BI and Power Map support mapping your own data using Latitude and Longitudes. Lat-longs are available in various formats. Power BI supports only decimal format. Unfortunately lot of data still comes with the DMS format Lat-Longs. I created a simple tool: Power BI Lat Long Converter. Use it do perform bulk conversions quickly. Continue reading Power BI Lat Long Converter
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here.
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.
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 Power View. It takes just 2 minutes if you have the data ready.
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.
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
Estimated reading time 7 min.
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.
Till now we have seen various aspects of plotting geographical information.
How do you present this information to others? Often we want to show our plans in a step by step manner – going from one location / region to another.
This can be done using Power Map Tour.
Let us explore how this can be done.