Friday, 24 August 2012

Business Intelligence : New capabilities delivered for end users in Excel 2013

  • Ability to analyze data ranging from a few rows to hundreds of millions of rows with extreme analytical performance on your desktop using Excel data models powered by xVelocity in-memory analytics engine
  • Opportunity to speed up analysis in Excel by easily cleaning up and shaping your data with Flash Fill; by previewing, applying conditional formatting, creating tables, charts and PivotTables using Quick Analysis; by easily navigating multidimensional and tabular data models and creating trend charts to analyze information over time using Quick Explore.
Quick Explore enables a user to look at the product categories summarized by Sales Quantity with 1 click:

Quick Explore

Quick Analysis suggests a Pivot Table type with a preview of actual data:
Quick Analysis

  • Empower users of all levels to access, mash-up and analyze data from virtually any source and rapidly create compelling analytical applications with PowerPivot.
PowerPivot Diagram View shows the data relationship:
PowerPivot Diagram View

  • Provide stunning data visualization to discover new insights at the speed of thought with a highly interactive and familiar data exploration, visualization, and presentation experience for users of all levels with Power View. 
Interactive visualization with Power View in Excel 2013:
Power View in Excel 2013

New capabilities delivered for IT:
At the same time, we are strengthening our IT management and oversight capability by
  • Enabling discovery and assessment of user-created spreadsheets with SharePoint 2013
  • Enabling comparing spreadsheets, tracking lineage, conducting interactive diagnostics and creating spreadsheet analysis reports with Inquire in Excel
SharePoint 2013 discovery and assessment criteria setup:
SharePoint 2013 discovery and assessment
Inquire in Excel showing spreadsheet lineage and workbook analysis:
Inquire in Excel

1 comment:

  1. Big Thanks for this wonderful read. I enjoyed every little bit of reading and I have bookmarked your website to check out new stuff of your blog a must read blog.
    best institute for big data in chennai
    best big data training in chennai