This way, we will be able to keep on adding data as long as there is a link between the table and PowerPivot. Since there is no way to add additional data into this model without deleting and recreating the table, it would be a good practice to create the PowerPivot model first from linked tables, and then using the PowerPivot fields to create the Power View report. The PowerPivot model can be viewed by clicking on the PowerPivot tab and then selecting the manage tab. This is because Power View can only communicate through DAX currently, and hence needs a tabular model behind it. It is interesting to note that the data used for creating the Power View report gets imported into PowerPivot by default. They are present when you click on the Layout tab. So I get a map report below which shows the cities as bubbles with corresponding colors and size as the amount of sales.ĥ) You can also play around with other properties like Title, Legend, Data Labels and Map Background. I have dragged Sales into the Size, City into Locations as well as Color.
Note that you would need an internet connection for implementing this.Ĥ) Now you can pretty much rearrange your fields by dragging them into the areas below. You should get a warning to enable content as the data needs to be sent to Bing to get geocoded. Click on the Map icon as shown in the image below You should get a loading screen while it takes a couple of seconds to open Power Viewģ) Now click on the Country field, and then you should be able to see the Map icon appear on the menu above. In this blog, I will take you through the steps to create a map report in Power View.ġ) Open up a new workbook Excel 2013 and then enter the following data in the cells CountryĢ) Select the entire data, go to the Insert tab and click on Power View icon. Also, Bing maps automatically detects the location and hence you don’t need to provide a shapefile or even the latitude/longitude information. Unlike the maps in SSRS, here you do have the ability to zoom and pan as needed.
Power View in Excel 2013 has the ability to create maps from your data and uses Bing maps for the same. Meanwhile I can’t wait to blog about the spatial capabilities available in Power View, so I am directly jumping to the topic. In case you still haven’t looked at the new features, here is the link for it. There’s been a lot of articles written on the new features available and the integration of PowerPivot and Power View has really got everyone talking about. There has been a lot of buzz in the BI community since yesterday, and the reason is none other than the public preview of Office 2013 (Excel 2013 in particular).
0 kommentar(er)
