Unleash the Power of PowerPivot in Your Enterprise

PowerPivot is part of the new release of SQL Server Analysis Services, and it uses an in-memory, column-based storage mode to enable users to build models in self service mode, “on the fly”, without having to pre-aggregate or build cubes prior to querying.

With PowerPivot, users can integrate data from multiple sources including corporate databases, Excel spreadsheets and external sources, using familiar tools but gaining greater power and analysis capacity. And many organizations have shown interest in extending this new in-memory platform with a complete business intelligence suite and making it ready for enterprise wide deployments.

Panorama Necto extends PowerPivot’s capabilities into a comprehensive, enterprise-wide BI solution. With unique self-service BI capabilities including intuitive web interface, contextual discovery, social BI and a data level security layer, teams, departments and the enterprise can collaborate more effectively and make better, more informed decisions.

  • Connectivity – Easy, instant and web based Panorama solution offers the same set of tools for Relational, SSAS and PowerPivot data sources.
  • Advanced Analytics – Comprehensive front-end analytical capabilities including smart exceptions, instant calculations and additional data formatting, closing the gap to SQL Server Analysis Services functionality; optimized for PowerPivot models, handling flat and large dimensions efficiently and leveraging the new, powerful DAX language for instant calculations and aggregated measure creation.
  • Workboards – Build interactive and highly functional Dashboards using grids, charts, KPIs, heat maps and other components on top of PowerPivot data in minutes. All web based and a completely self-service solution.
  • Complete BI Suite – The entire Panorama Necto BI suite is available on PowerPivot including KPIs, Data Visualization, Analytics and more.

Videos: