Recent Posts

• View New Video: SE Awarded Three Separate 2015 “Partner of the Year” Awards at Microsoft’s World
• Scalability Experts Announce Go-To-Market Partnership Agreement with Gridstore
• Scalability Experts Wins Second Award at Microsoft’s WPC Event

Categories

• Business Intelligence
• Data Platform
• General
• Virtualization & Cloud Services

• Subscribe to the SE Blog
• Follow us on FaceBook
• Follow us on Twitter

Office 2013 - New Features and How they relate to MS Business Intelligence!

08.29.12 Business Intelligence View Comments

 

Office 2013 - New Features and How they relate to MS Business Intelligence!

Office 2013 was released to customer preview on July 17th.   Over the next few weeks, I will high light the new features and provide a deeper look into each one as they relate to MS BI.  Top Features to take notice of include:

Excel

Instant data Analytics – This feature allows you to convert a simple data set into an analytical chart quickly with a minimal number of clicks.

Flash Fill – Fill a complete column of data based on what you have typed in one cell and copies that pattern in the remaining columns.

Richer Data Label for Charts – Format you data labels with additional data

New PivotTable Features – Numerous changes to the PivotTables have been implemented.  A full post will be need to list them all.  A few to note are:
•Excel Data Model  - Allows multiple tables to be used in excel for your data analysis without the need to create a PowerPivot model.
•New TimeLine Filter – Analyze data across different time periods
•Drill up, Down and Cross Drill into your data
•OLAP Calculated Fields – Create calculated fields in Pivot Tables.  This has been needed for some time.
•Charts and Pivot tables can be decoupled from each other
•PowerView – Is now available within Excel.

Sharepoint

PerformancePoint Services
•Dashboard Migration – Copy a dashboard and it dependencies from server to server or site collection to site collection
•Enhanced Filters – Allows users to filter and search within a filter.
•BI Center Update – You can now use folders
•Analysis Servers Effective User – Kerberous is no longer needed for SSAS authentication.  Authentication can now use the EffectiveUserName property to verify authentication.
•iPad Support – Safari web browser support.
 

To learn more about Scalability Experts Business Intelligence Services, please visit our Business Intelligence Solution page.

 

comments powered by Disqus