• Services
    • Digital Development
    • Quality Engineering & Assurance
    • Cloud Migration
    • Strategy
    • Experience Design
    • Data
  • Process
  • Thinking
  • Join Us
    • Careers
    • Culture
    • Events
  • Work
    • Success Stories
    • Industries
    • Partnerships
    • Technologies
  • Contact
  • Facebook
  • Twitter
  • LinkedIn
  • Google+
  • RSS Feed

Terms & ConditionsPrivacy PolicySitemap

Magenic
menu
  • Services
  • Process
  • Work
  • Contact

Excel 2013’s Impact for BI Users

April 28, 2015 // By Steve Hughes

On July 16, 2012, Microsoft made the Office 2013 Preview publicly available. As I worked through the install and saw the hype, I was really curious about some of the enhancements made to the business intelligence (BI) capabilities in Excel. Keep in mind that Microsoft has continually added BI components to the Excel product. Agree or disagree, this means that they have been positioning Excel as an “already installed” BI client for everyone.

With the previous release of Excel 2010 and PowerPivot, we were given an extremely powerful data mash-up tool that could be used by anyone and that introduced the xVelocity in-memory analytics engine (Vertipaq at that time). This was in addition to Excel’s capability to load data, create charts, use pivot tables and even perform data mining with the data mining add-in. When SQL Server 2012 was released, the capability of PowerPivot increased even more. Now PowerPivot had increased its calculation capabilities substantially and could be migrated to the new Tabular Model database in SQL Server 2012 Analysis Services.

The Big Additions to Excel 2013

As we waited to hear or see anything about the Office 2013 (a.k.a. Office 15) release, one had to wonder what would change. Now we know. The biggest, most significant BI change (in my opinion) is the inclusion of Power View in the product! Yes, you heard correctly, no longer do you need SharePoint to take advantage of Microsoft’s Power View reporting capabilities; you can now create the reports in Excel. As noted in the image below, you can take advantage of the entire set of capabilities previously only available in SharePoint:

Model Sales Over Time

Power View Changes

Also in this version, 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. If the relationships are discoverable such as in a relational database, the relationships will be built into the model:

Manage Relationships

Furthermore, this data will be stored as part of the spreadsheet, making it very portable. This is possible because xVelocity compresses the data to a manageable size and keeps the sheet very responsive.

If this is not enough for you, the PowerPivot add-in is still available and gives power users who require more advanced modeling techniques the full capabilities of the current PowerPivot release, including KPI creation, user-defined hierarchies, and perspectives.

Recommended Charts and Recommended Tables

Other New Features that May Interest BI Users & Developers

Not only did they include Power View in this release, but they added some other features that I found interesting.

  • Recommendations: Excel will now recommend PivotTables and Charts based on the data content you have in the sheet.
  • Insert a Timeline: Excel can now insert a timeline that is based on dates in the data you have.

For some more information, check out the information on Excel 2013 BI capabilities on the Microsoft site.

A Pleasant Install Experience... No Really

I also want to commend Microsoft on how simple the install was. I currently have the Office 2013 Preview and Office 2010 installed side-by-side and the install was painless. I used the download software option that was available on the Admin page of my Office 365 Preview, and I was able to start working with the Preview immediately. Besides being painless, the installer also added my PowerPivot and TFS add-ins into Excel with no additional effort from me. Kudos to the Microsoft team for making this easy.

Categories // Business Intelligence
Tags // Excel , Office 2013 , Office 365 , PowerPivot , Power View , MSBI
SHARE:
THE LATEST:
  • FEBRUARY 12, 2019 // blog
    Maybe My Mom Wasn’t Right – A Dirty Room for Automation
  • FEBRUARY 8, 2019 // blog
    Security In Five Bi-Weekly Roundup – 2/8/19
  • FEBRUARY 8, 2019 // blog
    Automation Execution – Here There Everywhere
Featured Content:
  • White Paper
    Stay Ahead of the Curve: App Dev Trends Coming In 2019

related Posts

APRIL 28, 2015 // Business Intelligence // Blog

Excel 2013–Microsoft’s BI Tool and Why You Should Use It

APRIL 17, 2015 // Business Intelligence // Blog

Managing Subscription Failures in SSRS

APRIL 17, 2015 // SharePoint // Blog

Microsoft BI – Power to the User

APRIL 17, 2015 // Business Intelligence // Blog

Guidelines for Successful Data Warehouse Projects

Contact Us

For more than 20 years, Magenic has helped some of the world’s best and biggest companies create innovative digital products quickly and seamlessly.

We move fast, look forward and collaborate with clients to get them to market sooner. Find out how we can help you Fast Forward to success.

This field is required
This field is required
This field is required
This field is required

Thanks for Contacting Magenic

One of our experts will be contacting you directly within the next business day.

Return To Home
Magenic

info@magenic.com+1.877.277.1044

  • Facebook
  • Twitter
  • LinkedIn
  • Google+
  • RSS Feed

© Magenic Inc.Privacy PolicyTerms & ConditionsSitemap