The Office 2013 Consumer Preview was released and there are some pretty awesome business intelligence highlights within it. Here is a quick summary of the features I have seen thus far that I am excited about. I will be digging deeper into these new features soon.  In the meantime, if you want to play with Power View in Excel today simply install Office 2013 from the link above and then download the demo Excel 2013 file. That is all you need to do to get started – no SharePoint install required.

BI Highlights – Power View and PowerPivot is now directly embedded into Excel 2013: powerful “in-memory” analytics, highly scalable, manageable, self-service BI will be accessible to every single Excel 2013 user – Power View new data visualizations: fully interactive, drillable geospatial mapping, pie charts, cross filtered pie charts and KPIs (finally easy map reporting in Excel or the web browser) -Power View report design and branding enhancements, images, background images and many more design themes to style and brand reports – Power View hierarchy support, multiple-level drill up and down, ad-hoc user defined drill paths and hyperlink features for web-based drill paths to other applications – Excel Quick Explore visual, interactive slicing/dicing interaction with data and charts on desktop and in the web browser: a “Proclarity-like” data exploration experience in Excel that is mobile device friendly across IE, Safari, iOS and other popular mobile device browsers – I couldn’t resist testing it tonight and I can confirm that Quick Explore features do indeed work on iPad! – SharePoint published Excel reports can also be  edited in now the web browser by exposing the pivot field lists and choosing the data to show in the report – Excel now has timeline filters, cycle charts, trend charts and a neat flash fill feature – Discovery and assessment of user-created spreadsheets with SharePoint 2013, comparing spreadsheets compliance, tracking lineage, conducting interactive diagnostics and creating spreadsheet analysis reports with “Inquire” in Excel – Excel Office Apps (“Napa” formerly called “Agave” apps) enable HTML JavaScript apps to be published to Office App Store and then be embedded into Excel sheets for dynamically displaying images, inline frames/web site URLs, read/write data, get selection or data change events on desktop and in web browsers (I saw one very cool demo of a decomposition tree within Excel 2013 using this technique) – Easier to work with external and cloud data sources: new query tables from unstructured sources, easier web services consumption, URL, and XML data imports (stock, twitter feeds), OData, REST and JSON (mash ups) – SharePoint, SharePoint online and O365 BI and mobile enhancements – New data set recommender features that can find and suggest related external data sources posted to Azure Data Market based on the data in an Excel model – SharePoint 2013 also improved site design and mobile BI web browser design features such as dynamic image renditions and “channel” enhancements that allows for easily surfacing and adapting content for presentation through multiple channels and mobile devices – Visio Services has improved data driven diagrams in mobile web browser like iPads for unlimited data visualization with improved support for touch across devices, no more Silverlight (diagrams and strategy maps are now mobile friendly),more supported data sources, like BCS and SQL Azure and also commenting is supported in mobile web browsers as well as the desktop client.

For more information on what is new for BI and SQL Server, keep an eye on  http://blogs.msdn.com/b/microsoft_business_intelligence1.

Great blog from the Power View engineering product team showcases data visualization and interactive mapping in Excel Power View tips from Sr. PM Sean Boon http://blogs.msdn.com/b/seanboon.

More comprehensive list of  what is new in Power View and  Excel 2013 for developers.