What is PowerView and why is it important to IT and business users?
PowerView is an Excel 2013 feature that enables users to build integrated charts and graphs within Excel. Given a completed mashup of data, a user can then create a wide selection of reports in the familiar Excel interface. Report parts can be linked together to create a highly visual analytical tool. Click on a filter for 2012 and all related charts filter to 2012. Want to slice further by product line, then add another filter and automagically it happens.
From an IT perspective PowerView is a great tool that can give analysts another cog in the self-service delivery wheel. Once a user understands how to leverage PowerView the only remaining piece is to get the data. Users are doing this already by running reports and dumping the results to csv files or Excel files. By teaming with the Analysts to understand their data requirements, IT can product a shared dataset of commonly used fields in the format best suited for the Analysts. Then Analysts can connect to a database server and leverage the enterprise shared data when it is available. IT will always be playing catchup to the Analyst in providing the data that they need. Once that is embraced by IT and the Analysts everyone will work better together. Analysts will be collecting new data sources that they know IT can move to a shared environment for everyone to leverage. IT Data Managers will know that Analysts are going to be coming to them with new data needs and discovered data.