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