On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the SQL Server BI components directly in the initial install, as well as enhancements made to the business intelligence (BI) capabilities in Excel. Here are the details:
- Much of the core PowerPivot functionality, including the xVelocity in-memory analytics engine, has been built into the Data Model in Excel. This brings the capability to import millions of rows into a table and create relationships between the tables, including disparate data sources. When you add a connection, you can now choose to import multiple tables
- The PowerPivot add-in is now by default installed together with Excel. All you need to do is enable it in the options. There are a few new features in there like Categorizations and new datamarket integration
- Pover View has now also become an add-in in Excel so you can now work with Power View offline in Excel. It can be either connected to the Excel data model or to an external Analysis services instance. SharePoint is not required. Power View also supports some new visualizations like charts, pie charts, themes and more
- Quick Explore, Trend Charts, Quick Analysis and Flash Fill: Improve productivity by easily shaping your data with Flash Fill; using Quick Analysis to preview and apply conditional formatting, suggest and create charts, PivotTables, and tables; and use Quick Explore to easily navigate multidimensional and tabular data models and create Trend charts to analyze information over time.
- Interact with Excel pivot tables on the web and share with anyone. See Using Pivot tables in the Office Excel Web App
What’s New in Office 2013 BI – (Part 1 – Personal BI with Excel), What’s New in Office 2013 BI: (Part 2 – Power View Enhancements), What’s New in Office 2013 BI: Part 3 – Improved Productivity, What’s New in Office 2013 BI: Part 4 – New Features in Excel Web Reports