Knowing Power Pivot and being able to configure relationship and data categories, will help for performance (so it seems based on my testing).ģ. Power View can be created based on a table on a worksheet and it automatically creates Power Pivot data based on the table. So it allows for rapid prototyping and development.Ģ. I can zoomed in further to the actual postcode as the granularity of the location is postcode, as shown below:Īdvantages and Disadvantages of Using PowerView MapĪlthough it’s still at its early stage as Office 2013 is only released in a Preview version, I consider Power View Map feature has the following advantages and disadvantages.Īdvantages of PowerView in Office 2013 preview as at the time this post is written:ġ. Zoomed at a State level, with funding > $1 million filter: (hovering on one of the bubble gives me a descriptive tooltip) My motive here is to see which areas have the funding gone to? Does the amount of funding yield many connections? Is there any isolated area that gets funding? The dataset I’m using has a very straight forward data structure. The program targeted premises unable to access commercial metro-comparable services, particularly those living in remote parts of Australia
The Australian Broadband Guarantee (ABG) was an Australian Government initiative designed to help residential and small business premises access high-quality broadband services regardless of where they were located. I do hope that it will be introduced as a Service Pack 1 to SQL Server 2012. The map feature is currently not available in SQL Server 2012 RTM with SharePoint 2010. Using the Australia Broadband Guarantee data set provided from, I am able to quickly and painlessly create an interesting Power View Map in Excel 2013 that I can analyze the investment the Australian government has made, at country level and down to specific Suburbs / Postcodes. With most tools if you have analytical mind and are great with visualization / design, most reports you’ll create will be useful and used – and in my opinion – Power View is definitely one of these tools.
Since the first time Power View introduced in SQL Server 2012 and made available in SharePoint 2010, I’ve always been fan of it. Here’s my thought on a fairly early version of Power View feature in Excel 2013 Preview. This is a very welcomed feature and I would sense that it will win Business adoption as an easy to use and “hopefully” affordable Self Service BI. With Office 2013 preview launched in mid July 2012, there have been ubiquitous posts on the new Power View feature in Excel 2013.
0 kommentar(er)
