Advanced Analytics and Data Security

Session 3

PowerPivot offers powerful self-service BI capabilities for end users and many organizations are looking to extend it with advanced analytical capabilities for analysts and power users. NovaView Analytics for PowerPivot extends Excel capabilities with advanced smart exceptions, instant calculations, additional data formatting functionalities and more. To make PowerPivot enterprise ready NovaView adds a Data Level Security layer.

Outline:

  • The full power of OLAP, multidimensional analysis and hierarchies
  • Advanced data modeling and analytics in Excel
    • Table joins
    • Using DAX to create new columns
    • Advanced analytics in Excel
  • Advanced analytics with Panorama NovaView
    • DAX for new measures
    • MDX for calculations
  • Security
    • MS file/doc security
    • Panorama Data Security
    • Unified security model

Sign up for PowerPivot workshops

 

Panorama NovaView® and the Panorama logo are trademarks or registered trademarks of Panorama Software Ltd. All other company, product or brand names are the trademarks or the registered trademarks of their respective companies. Panorama Software Ltd. is not responsible for errors or omissions. Copyright 2006 Panorama Software Ltd. All rights reserved.