Microsoft Power Map For Excel Mac

Power Map for Excel If you have a subscription for Microsoft 365 Apps for enterprise, you have access to Power Map for Excel as part of the self-service business intelligence tools. Whenever any new Power Map features and performance enhancements are released, you'll get them as part of your subscription plan. Install Windows on Mac using Boot Camp; Power BI's support for Mac Devices. To give you a little context about Microsoft's plan on supporting Power BI on Mac devices, they are not considering developing Power BI desktop for Mac devices anytime soon. You can also visit this link to keep track of their upcoming plans. Microsoft's response on.

Posted December 23, 2013

By Arshad Ali

Introduction

Power Map is an Excel add-in under the Microsoft Power BI umbrella that extends the capability of Power View by enabling end users to visualize data in a 3D visualization format. It lets you plot geographical and temporal data visually, analyze it in 3D visualization format and create an interactive, guided cinematic tour to discover new insights by seeing your data in geographic space and seeing time-stamped data change over time (which you might not have seen in traditional 2D tables and charts) and to share it with others.

In my last article, Understanding Microsoft Power BI - Self Service BI Solutions, I talked in detail about Microsoft Power BI self-service solution and its different components.

Power Map For Excel 2013

In this article, I am going to talk about Power Map in detail, how to install it and how to get started using it.

Installing Power Map Excel Add-in

The Power Map (code name for this feature was 'GeoFlow') is a free Excel add-in (supported in Excel 2013) that can be installed from the Microsoft Download Center. To install Power Map Excel add-in, you require Microsoft Office 2013 Professional Plus, Office 365 ProPlus. You can find more information on this, under Software Requirements section in the Microsoft Download Center

Once installed, you need to go to the File menu and click on Options as shown below, to enable the add-in for use:


Enable the Add-in

Click on Add-Ins tab on the left side and then from the Manage combo-box, select COM Add-Ins as shown below and the click on Go button:


Manage COM Add-ins

Microsoft

On the COM Add-Ins dialog box, check “Microsoft Power Map Preview for Excel” and then click on OK button:


Microsoft Power Map Preview for Excel

Now if you go to INSERT tab, you will notice the Map icon appears on the right side of the image, as seen below:


Map Icon

Getting Started with Power Map for Excel

Power Map provides interactive, 3D visualization with geospatial and temporal data. It enables information workers to discover and share new insights from data through rich, 3D visualization on a globe with fluidic appearance, guided cinematic tours and seeing time-stamped data change over time (which you might not have seen in traditional 2D tables and charts) and to share it with others.

Power Map is one of the Excel add-ins available as part of Microsoft Power BI - a cloud based self-service BI solution for the enterprise - for visualization of the data in a completely different way. Power Query is another add-in, which provides an intuitive and interactive user interface that can be used to search, discover, acquire, combine, refine, transform and enrich data. I am going to use Power Query to search some data and then use the same data for visualization in Power Map.

To search data online, click on the Online Search icon under Power Query tab as shown below:


Online Search Icon

In the text box of Online Search, I searched for “India population” and here is the result of my search. I also see one result for the state wide literacy rate for Indian form Wikipedia. Let me use this data to visualize it in the Power Map with 3D visualization:


Online Search Results

Once you have installed the Power Map and enabled it (as discussed above), you need to go to the Insert tab and then click on the Map icon and then click on Launch Power Map as shown below:


Launch Power Map

And this is what the Power Map report designer interface should like; you can see one default scene already created on the left side and on the right side you can see the interface, which shows the structure of your data. In the middle, you can see the globe where your data will be plotted.

When we start creating a Power Map report, first of all, we need to map the geography or geospatial data.


Map the Geospatial Data

In the result-set, I have Indian state names as geography data and hence I have mapped it with State/Province as you can see below. Your data can contain other geospatial data that can be mapped here like latitude, longitude, city, state, country, zip, address, etc.


Geospatial Data

Once you have done with this mapping, click on the Map it button to move onto the next screen where you need to identify the column you want to analyze. I want to analyze Literate Persons percentage (with each column or measure you can specify the aggregation function; in my case as I have calculated percentage already in my data and hence I have not used any aggregation function) in my map report as heat map and hence I have selected it as shown below:


Identify the Column to Analyze

And this is how the heat map report looks for the literate persons percentage in Indian states as per data I have in the excel workbook.


Heat Map

In the next view, I changed the report type to column or bar and added male literacy percentage and female literacy percentage along with the total literacy percentage as before. And in just a few seconds, I have a different Power Map report view in 3D format as you can see below. The best part of this report is, it’s fully interactive 3D visualization on a globe with fluidic appearance; you can zoom-out, zoom-in, move in different directions, etc. If you hover over any of this bar, you can see its value:


Power Map Report

Well suppose you don’t like the above report and you want to change it to be pie-charts, very similar to what is shown below. For that you just have to change the report type and that’s all; with a single click you have a different visualization to gain insights:


Pie Charts

As I said before, Power Map allows you to create cinematic effects on a globe with fluidic appearance; to do that you can create different scenes (each scene might have multiple layers). For example, as you can see below, I have created three different scenes. The first scene, for total literacy percentage, the second sheet for male literacy and the third sheet for female literacy visualization. Once you are done with creating these scenes, you can click on the Play Tour icon as shown below for a nice fluidic cinematic tour in 3D format. This gives a really nice visual treat to the eyes and at the same time better insights into your data. As I said before it’s fully interactive so you have control to zoom-in, zoom-out, and move in different directions to visualize your data from different directions.


Play Tour

There are couple of other options in the Power Map report designer, like you can change the theme of the report, add map labels, analyze data in flat map instead of globe, find any specific location on the map using search, add text boxes for comments or annotations, etc.


Power Map Report Designer Options

For example, as you can see below I added map labels and place names to the report. This gives an even better clarity on the place or location:


Map Labels and Place Names

Power Map reports are saved as part of your Excel document. When you open the Excel document and click on Launch Power Map, it will give this dialog to choose if you want start an already existing tour (saved as part of Excel document) or you want to start a new tour of creating Power Map report.


Launch Power Map

If you have data with a time dimension, you can place time dimension under Time in the Power Map designer and can see your report (time-stamped data) changing over the period of time when you play it.

Please note, Power Map is in Preview stage right now and features mentioned in this article might change in final release of the product.

Conclusion

Power Map is an Excel add-in under the Microsoft Power BI umbrella that extends the capability of Power View by enabling end users to visualize data in 3D visualization format. It lets you plot geographical and temporal data visually, analyze it in 3D visualization format and create interactive, guided cinematic tours to discover new insights by seeing your data in geographic space and seeing time-stamped data change over time and to share it with others. In this article, I talked about how to install the Power Map Excel add-in and how to install, enable and get started with using Power Map.

Resources

Power BI for Office 365

Power Map Sample Workbooks





Latest Forum Threads
SQL etc Forum
TopicByRepliesUpdated
MySQL rollbackUAL2250August 21st, 09:56 PM
Complex Search QueryGalway0May 20th, 10:04 PM
change collation at oncesupercain2May 15th, 06:18 AM
SQL Features, tools and utilities questionNeomite1April 10th, 09:13 AM

-->

Note

For a list of Office products covered by this privacy information, see Privacy controls available for Office products.

Office consists of client software applications and connected experiences designed to enable you to create, communicate, and collaborate more effectively. Working with others on a document stored on OneDrive or translating the contents of a Word document into a different language are examples of connected experiences.

Connected experiences that analyze your content

Connected experiences that analyze your content are experiences that use your Office content to provide you with design recommendations, editing suggestions, data insights, and similar features. For example, PowerPoint Designer or Translator.

The following table provides a list of connected experiences that analyze your content and also provides links to more information about them.

NameMore information
3D Maps*Get started with 3D Maps
Analyze Data (previously named Ideas)Analyze Data in Excel
Automatic alt txtEverything you need to know to write effective alt text
Chart recommendationsCreate a chart with recommended charts
Class Notebook add-ins (OneNote)Getting Started with the OneNote Class Notebook: A Walkthrough for Teachers
Data typesExcel data types: Stocks and geography
DictationDictate in Microsoft 365
Editor1Microsoft Editor checks grammar and more in documents, mail, and the web
Friendly links in OutlookFriendlier link names in email
Ink to Text, Ink to Shape, Ink to Math2Change handwritten ink to shapes, text, or math in PowerPoint for Microsoft 365
Insert data from pictureInsert data from picture
Learning ToolsLearning Tools
Live captions & subtitlesPresent with real-time, automatic captions or subtitles in PowerPoint
Map chart*Create a Map chart in Excel
Maps in Power ViewMaps in Power View
Office Presentation ServiceBroadcast your PowerPoint presentation online to a remote audience
PivotTable recommendationsCreate a PivotTable to analyze worksheet data
PowerPoint DesignerCreate professional slide layouts with PowerPoint Designer
Presenter Coach (PowerPoint)Rehearse your slide show with Presenter Coach
Publish to Microsoft StreamTurn your presentation into a video
Publish to Power BIPublish to Power BI from Excel
Research*Add or change research services
Scan a business cardScan or tap to add contacts on Outlook for Android
Sharing notificationGet notified when members of your team update your shared file
Similarity checker* (a feature of Editor)Check your document for similarity to online sources
Smart Lookup*Get insights into what you're working on with Smart Lookup
Suggested repliesUse suggested replies in Outlook
Tap for Word (Add from files)Find and use the content you need, when you need, without leaving Word
Text predictions (a feature of Editor)Make writing faster with text predictions in Word
Transform to Web PageTransform your Word document into a Sway web page
TranslatorTranslate text into a different language

1 Basic functionality of Editor remains available even if you're not connected to the internet. That same basic functionality also remains available if you decide to disable the use of connected experiences that analyze your content. In both cases, no data about the use of Editor is sent to Microsoft.

2 For devices running Android, these ink capabilities remain available even if you're not connected to the internet. These ink capabilities also remain available on devices running Android even if you decide to disable the use of connected experiences that analyze your content. In both cases, no data about the use of these ink capabilities is sent to Microsoft.

Note

*When users are signed in with a work or school account, the connected experiences listed above in italics are optional and are provided under the terms of the Microsoft Services Agreement and privacy statement, and other terms may also apply. For more information, see Overview of optional connected experiences in Office. If you're an admin, these connected experiences can be managed by privacy controls for connected experiences or by the Allow the use of additional optional connected experiences in Office policy setting.

Microsoft

Connected experiences that download online content

Connected experiences that download online content are experiences that allow you to search and download online content including templates, images, 3D models, videos, and reference materials to enhance your documents. For example, Office templates or PowerPoint QuickStarter.

The following table provides a list of connected experiences that download online content and also provides links to more information about them.

NameMore information
Calendar appsWhat are Calendar Apps?
Cloud fontsCloud fonts in Office
FAQsWhen you choose Settings > Help & Feedback > FAQs on Outlook for iOS and Android, you are taken to either Outlook for iOS Help or Outlook for Android Help.
Ink EffectsDraw and write with ink in Office
Insert IconsInsert icons in Microsoft Office
Insert Microsoft FormsInsert a form or quiz into PowerPoint
Insert Online 3D Models*Get creative with 3D models
Insert Online Pictures*Insert pictures
Insert Online Video*Insert a video from YouTube or another site
Interesting Calendars*Subscribe to a calendar about your favorite sports teams or TV shows on Outlook for iOS and Android.
Location suggestions*When you add a public place with a street address to a calendar item, Outlook for iOS and Android will also include the full street address in the Location field.
Maps in event detailsThe event details page will show a map based on the address of the location of the event on Outlook for iOS and Android.
Office HelpWhen you choose Help > Help on the ribbon or use F1 in an Office app
Online Shape Search (Visio)Find more shapes and stencils
PowerPoint QuickStarter*Research a topic with PowerPoint QuickStarter
Researcher*Research your paper easily within Word
Tell Me3Do things quickly with Tell Me
TemplatesDownload free, pre-built templates
Travel time estimates in Up Next*When you choose to allow Outlook for iOS and Android to access your location, an estimate of your travel time to your next event will be included in the Up Next card at the top of your inbox.
What are Time to Leave notifications?
Weather Bar* (Outlook)Change the calendar Weather Bar forecast city
Weather on calendar* (Outlook mobile)How do I turn on weather on calendar on Outlook mobile?

3 Basic functionality of Tell Me remains available even if you're not connected to the internet. That same basic functionality also remains available if you decide to disable the use of connected experiences that download online content. In both cases, no data about the use of Tell Me is sent to Microsoft.

Note

*When users are signed in with a work or school account, the connected experiences listed above in italics are optional and are provided under the terms of the Microsoft Services Agreement and privacy statement, and other terms may also apply. For more information, see Overview of optional connected experiences in Office. If you're an admin, these connected experiences can be managed by privacy controls for connected experiences or by the Allow the use of additional optional connected experiences in Office policy setting.

Other connected experiences

In addition to connected experiences that analyze content and connected experiences that download online connected experiences, there are some other connected experiences available in Office.

The following table provides a list of those other connected experiences and provides links to more information about them.

NameMore information
@mentionUse @mention in comments to tag someone for feedback
Brainstorming diagram (Visio)Create a brainstorming diagram
Coming Soon (Outlook)Coming Soon
Contact Support (Outlook)When you choose Help > Contact Support on the ribbon
Custom Import (Visio)Import data to shapes in your drawing
Data Loss Prevention (DLP) policy tipsSend email notifications and show policy tips for DLP policies
Data Visualizer (Visio)Create a Data Visualizer diagram
Design Flows (Visio)Design an automated workflow in Visio
External list (Outlook)Connect an external list to Outlook
Focused Inbox (Outlook)Focused Inbox for Outlook
Information Rights ManagementOpen a file that has restricted permissions
LinkedIn contact cardLinkedIn in Microsoft apps and services
Office add-ins*View, manage, and install add-ins in Office programs(for users)
Deploy add-ins in the admin center(for admins)
Office feedbackHow do I give feedback on Microsoft Office?
Office support (Contact us)When you choose Help > Contact Support on the ribbon
Organization chart (Visio)Create an organization chart in Visio
Outlook UserVoice*How do I give feedback on Microsoft Office?
PivotDiagram (Visio)Create a PivotDiagram in Visio
Recent documentsOpen files from the File menu
Resume Assistant (or CV Assistant)*Use Resume Assistant and LinkedIn for great resumes
Room Finder (Outlook)How to control the Room Finder in Outlook
Safe DocumentsSafe Documents
Safe Documents in Microsoft 365 E5
Safe LinksATP Safe Links
Sensitivity labelsApply sensitivity labels to your files and email in Office
ShareShare your Excel workbook with others
Share a presentation (PowerPoint)
Share a document (Word)
Shared with meSee files others have shared with you
SharePoint site mailbox (Outlook)Show or hide a site mailbox in Outlook
Timeline import and export (Visio)Import and export timeline data between Visio and Project
Version historyView previous versions of Office files
While you were awayGet notified when members of your team update your shared file

Note

*When users are signed in with a work or school account, the connected experiences listed above in italics are optional and are provided under the terms of the Microsoft Services Agreement and privacy statement, and other terms may also apply. For more information, see Overview of optional connected experiences in Office. If you're an admin, these connected experiences can be managed by privacy controls for connected experiences or by the Allow the use of additional optional connected experiences in Office policy setting.

Choose whether these connected experiences are available to use

You can choose whether certain types of connected experiences, such as connected experiences that download online content, are available to use. How you make that choice depends on whether you are signed into Office with a Microsoft account, such as a personal outlook.com email address, or with a work or school account.

If you are signed in with a Microsoft account, open an Office app, such as Word, and go to File > Account > Account Privacy > Manage Settings. Under the Connected experiences section, you can choose whether certain types of connected experiences, such as experiences that analyze your content, are available to use. If you don't go to Manage Settings, all connected experiences will be available to you.

If you are signed in with a work or school account, the admin in your organization will decide whether these connected experiences are available to you. You won't see any choices for these connected experiences if you go to File > Account > Account Privacy > Manage Settings.

Note

  • If you're using Office for Mac, open any Office application and select the app menu (such as Word, or Excel) > Preferences > Privacy. This will open the Account Privacy settings dialog box where you can see your privacy options.
  • For more information, see Account Privacy Settings.

If you are the admin for your organization, you can use policy settings to determine whether these connected experiences are available to your users. If you don't use these policy settings, all connected experiences will be available for your users. For more information about using these policy settings, see the following articles:

  • Use preferences to manage privacy controls for Office for Mac.

If you choose to turn off some types of connected experiences, either the ribbon or menu command for those connected experiences will be grayed out or you will get an error message when you try to use those connected experiences.

Microsoft Power Map For Excel Mac Download

Even if you decide to turn off these connected experiences, certain Office functionality will remain available, such as synching a mailbox in Outlook, and Teams and Skype for Business will continue to work. Also, there is a set of services that are essential to how Office functions that can't be turned off, such as the licensing service that confirms that you are properly licensed to use Office.

Microsoft Power Map For Excel Mac Os

Related articles

Comments are closed.