3D MAP: A DYNAMIC TOOL
Data visualization is the trending topic in recent as we gather and examine a more and more no. of data. On the off chance that you have attempted the Power Map include in Excel, referred to now as 3D Maps in new version of Excel, you may have been astonished at how easy it is to create a heat map for standard geographic regions. On the off chance that you see much more profound, you can figure out how to make heat maps for custom limits. With 3D Maps, you can plot geographic and transient information on a 3-D globe or custom guide, demonstrate it after some time, and make visual tour you can impart to other people.
You’ll need to use 3D Maps to:
• Map information: Plot more than a million lines of information outwardly on Bing maps in 3-D design from an Excel table or Data Model in Excel.
• Share stories: Capture screen captures and construct realistic, guided video tour you can share extensively, captivating gatherings of people more than ever. Or on the other hand send out tour to video and offer them that path too.
• Discover experiences: Gain new understandings by review your information in geographic space and seeing time-stamped information change after some time.
and much more……
How to develop a 3D map in excel
• Prepare your information: You should have no less than one geographic incentive in each column of information. This could be City, Country, Region, Zip, State, Address or Latitude/Longitude information.
• Format your information into an Excel Table.
• Click any cell in the table, at that point tap the 3D Map catch in the Insert tab.
• Click New Tour (If you are utilizing 3D Maps out of the blue, you may need to Enable the Data Analysis include to utilize the component.)
• Another 3D maps window will open. Excel expectations will endeavor to distinguish the Location field from the worksheet. In the event that it doesn’t, click Add Field and select the right area section from the dropdown menu.
• Adjust the zoom to best view your information. Excessively close and you will miss a few information. Too far and the information can look as well “swarmed”.
• Select the perception compose. On the off chance that the default bar diagram isn’t the correct sort for your information, look over the line of sorts.
• If your information contains numerous esteems related with every area, add those fields to the Values sheet. Click Add Fields and select from the dropdown menu. Excel expectations will add the qualities to the guide and make a legend.
• Adjust information esteems by tapping on the bolt alongside the field. Pick a choice from the dropdown menu.
Here you can enjoy the more functions of it. Excel’s new 3D Maps adds more functionality like Scenes and tours that offers user-friendly playback of time-based data changes. It’s great that Microsoft has included map functionality as standard and built 3D Map in Excel 2016.
In the next few years, data visualization will put its strong foothold in different industry verticals like HR, Manufacturing, Healthcare, Education etc. We already have some specialized products for Marketing Analytics, Product Analytics, HR Analytics, etc. We will see more of these that can change the way of thinking in future, still… “CHANGING”!
Akhilesh Kumar Prajapati
