Completing the Microsoft BI Stack with Pyramid

Analytics, Reporting and Dashboards

SQL Server Analysis Services and Pyramid Pyramid Analytics' BIO suite is designed to work exclusively with Microsoft's BI stack. The Microsoft BI stack provides organizations with a business intelligence platform that can cover the entire gambit from self-service BI to enterprise wide analytics.

Pyramid Analytics complements and completes Microsoft's BI offerings by providing a comprehensive, state of the art front-end toolset for consuming the business intelligence exposed through the stack. This extends from internally focused applications to cloud-hosted SAAS BI solutions.

SQL Server Analysis Services 2005 / 2008 / 2012 + PowerPivot

SQL Server Analysis Services and PowerPivot sit at the heart of Microsoft Business intelligence stack. Pyramid plays a critical role in exposing these powerful querying technologies to end users through a powerful, synergistic toolset that delivers analytics, reporting and dashboards. Further, it extends functionalities found in other parts of the Microsoft BI ecosystem (like Excel or PowerView) by delivering the types of functions, content management and tools needed in deployments that are specifically geared for delivering BI to the entire organization, for all user types from novice to expert.

SharePoint

One of the most popular ways to incorporate business intelligence into an organization's portal is through Microsoft SharePoint (MOSS). To facilitate this functionality, the stand alone Pyramid SharePoint WebPart application will install and configure all the necessary aspects of the WebPart to make it accessible from inside the portal editing environment - for both Enterprise and Standard editions of SharePoint 2010. Pyramid content can also be "connected" to PerformancePoint WebParts so the two can interact.

BING and SQL Server Geospatial

Bing

A big feature set in any BI deployment relates to geospatial presentation of data. Pyramid marries together the power of Microsoft's multi-dimensional cubing framework with the SQL Server Geospatial engine and BING maps to deliver an immersive, interactive and seamless geospatial analytical experience unmatched in BI today. The ability to plot and analyze data on a map has never become easier for end users.

Microsoft Office - Excel and PowerPoint

Pyramid provides a powerful conduit for office extensibility by providing several mechanisms to export content into the Microsoft Office platform for users that wish to drive their analysis and presentation of data beyond the scope of what pyramid itself offers.