Home > Business Intelligence, Denali, SQL Server, SSRS > Power Pivot and Power View now available in Excel 2013.

Power Pivot and Power View now available in Excel 2013.

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’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.

Posted By – Suhas R. Kudekar(MCC)

  1. February 13, 2013 at 1:36 am

    We’re a group of volunteers and starting a new scheme in our community. Your website offered us with valuable information to work on. You have done an impressive job and our entire community will be grateful to you.|

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: