SharePoint Server 2013 helps in that, and there are several ways to do it. For example, you may want to share such an analytical map with others through a corporate dashboard ( 8:44). Whilst being able to do such advanced form of analytics without leaving Excel is power-to-the-user at its best, it also scales well to the needs of an organisation. Indeed, it is much easier to do than to explain in words, so have a look at the demo ( 1:12), and repeat the steps to learn it. You can even break this down by categories creating a map of little pie-charts, as shown in the demo. Excel’s new Data Model (which uses xVelocity technology and the PowerPivot ribbon interface) will automatically aggregate sales at the city level, and so on, when you just display the city data point on a map. If you are new to this, all this means is that you just need to have a simple table, for instance one that includes every sale that you want to analyse, including the name of the city where the sale took place. ![]() This is all done automatically for you, thanks to xVelocity In-Memory Analytics Engine, which also ships as part of Excel 2013, and which you can access through the Excel PowerPivot ribbon. There are some more interesting, advanced, yet very easy to use geospatial analytics features, too: you can have your data automatically aggregated at the different levels of a geographical hierarchy, for example to see sales by country, state, or at the city level. Best of all, it is not even necessary to store longitude and lattitude information in your data! As long as you have a textual name of a city, country, or region, Power View is able to automatically geocode your data so it appears in the right place on the map. Power View is a standalone component of Excel 2013, no longer requiring a SharePoint Server! This means it is now possible to quickly and easily create ( 2:05) fully interactive, zoomable maps of the world, while showing your own data on them.
0 Comments
Leave a Reply. |