In Excel 2013, much of
that functionality, including the infrastructure that supports it, is built
directly into the Data Model in Excel. Without installing a separate add-in,
PowerPivot and Power View add-ins are installed by default. But they are not automatically
enabled. You have to do some menu/dialog
box acrobatics to turn them on, but it’s a one-time set-and-forget
requirement.
If you are looking to quickly build out a self-service BI solution that tells the story of your data, you can now use the tool you know and love – Excel - to rapidly mash-up, explore, analyze and visualize any data ranging from a few rows to hundreds of millions of rows.
If you’d like to try it
yourself, click through File|Options|Add-Ins|Manage COM Add-Ins|Go… and then
enable the add-ins by checking them off and clicking OK.
Below diagram will give you
more idea.
Some of the Excel 2013 Features:
If you are looking to quickly build out a self-service BI solution that tells the story of your data, you can now use the tool you know and love – Excel - to rapidly mash-up, explore, analyze and visualize any data ranging from a few rows to hundreds of millions of rows.
· xVelocity
in-memory analytics:
Analyze
data ranging from a few rows to hundreds of millions of rows instantly on your
desktop using Excel data models, new in 2013 powered by xVelocity in-memory
analytics engine. More Details
· 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 using Quick Explore to easily navigate
multidimensional and tabular data models and create Trend charts to analyze
information over time.
· Power Pivot:
Access,
mash-up and analyze data from virtually any source and rapidly create
compelling analytical models with PowerPivot, now in Excel.
· Power View:
Provide
stunning data visualization to discover new insights with a highly interactive
and familiar data exploration, visualization, and presentation experience with
Power View, now in Excel. More Details
Posted by - SUHAS R.
KUDEKAR (MCTS - Microsoft Business Intelligence)
Learning Office 2010 +
SharePoint 2010 + SQL Server 2008 R2
