Microsoft Power View is a useful add-on for Excel that helps you to visualize your data so that you can share and interpret information and present it to your customers. Here’s our webinar replay.
Power View is a part of the Microsoft BI family, which also contains Power Query, PowerPivot and Power Map, plus the new BI Q&A. Having used Power Query to collect all your data, you switch to PowerPivot to model the data. You then have three options for presenting the results: Power View, Power Map and the Google-like search system BI Q&A. In the webinar (click on the video to replay it), we took a closer look at the rich visual tools of Power View, which is suited to any dashboard and ideal for presenting conclusions based on the data you collect. On a side note, we should warn you that the Excel 2010 version looks slightly different from the 2013 version we used in the webinar. If you have any questions about this, feel free to contact us.
Use the ‘map’ option to see a map view without having to switch to the separate Power Map tool. Just go to ‘map view’ on the ribbon. You can add or remove data as necessary and use slicers to specify what information you are looking for and zoom in and out. The map view allows you to spot anomalies quickly and discover patterns at a glance.
Pie charts are ideal if you have limited options, but with Power View you can apply slicers to every slice. Use the hierarchy you created up front to keep your pie charts nice and tidy. Double-clicking on a section of the chart will reveal the information from the next level of the hierarchy. White lines will be added automatically to show you where to look for more data. You can combine bar charts and pie charts interactively.
The use of line charts is pretty straightforward. But Power View allows you to add more visuals: images, logos, pictograms and other valuable extras are available in different styles, just by using the URL of an online image.
Bubble charts or scatter charts are fun to play with and combine the visual information of a map and a line chart. It is easy to set the axes and you can look at data in more detail by clicking on a particular part of the chart. If you want to see how the bubbles evolve over time, you can click the ‘play’ button at the bottom of the chart and Power View will show the bubbles changing in size to indicate how their values will vary over time.
Cookie | Duration | Description |
---|---|---|
ARRAffinity | session | ARRAffinity cookie is set by Azure app service, and allows the service to choose the right instance established by a user to deliver subsequent requests made by that user. |
ARRAffinitySameSite | session | This cookie is set by Windows Azure cloud, and is used for load balancing to make sure the visitor page requests are routed to the same server in any browsing session. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie records the user consent for the cookies in the "Advertisement" category. |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | CookieYes sets this cookie to record the default button state of the corresponding category and the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | The website's WordPress theme uses this cookie. It allows the website owner to implement or change the website's content in real-time. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duration | Description |
---|---|---|
__cf_bm | 30 minutes | Cloudflare set the cookie to support Cloudflare Bot Management. |
pll_language | 1 year | Polylang sets this cookie to remember the language the user selects when returning to the website and get the language information when unavailable in another way. |
Cookie | Duration | Description |
---|---|---|
_ga | 1 year 1 month 4 days | Google Analytics sets this cookie to calculate visitor, session and campaign data and track site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognise unique visitors. |
_ga_* | 1 year 1 month 4 days | Google Analytics sets this cookie to store and count page views. |
_gat_gtag_UA_* | 1 minute | Google Analytics sets this cookie to store a unique user ID. |
_gid | 1 day | Google Analytics sets this cookie to store information on how visitors use a website while also creating an analytics report of the website's performance. Some of the collected data includes the number of visitors, their source, and the pages they visit anonymously. |
ai_session | 30 minutes | This is a unique anonymous session identifier cookie set by Microsoft Application Insights software to gather statistical usage and telemetry data for apps built on the Azure cloud platform. |
CONSENT | 2 years | YouTube sets this cookie via embedded YouTube videos and registers anonymous statistical data. |
vuid | 1 year 1 month 4 days | Vimeo installs this cookie to collect tracking information by setting a unique ID to embed videos on the website. |
Cookie | Duration | Description |
---|---|---|
ai_user | 1 year | Microsoft Azure sets this cookie as a unique user identifier cookie, enabling counting of the number of users accessing the application over time. |
VISITOR_INFO1_LIVE | 5 months 27 days | YouTube sets this cookie to measure bandwidth, determining whether the user gets the new or old player interface. |
YSC | session | Youtube sets this cookie to track the views of embedded videos on Youtube pages. |
yt-remote-connected-devices | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt-remote-device-id | never | YouTube sets this cookie to store the user's video preferences using embedded YouTube videos. |
yt.innertube::nextId | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
yt.innertube::requests | never | YouTube sets this cookie to register a unique ID to store data on what videos from YouTube the user has seen. |
Cookie | Duration | Description |
---|---|---|
WFESessionId | session | No description available. |