Completing the Microsoft BI Stack with Pyramid
Analytics, Reporting and Dashboards
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
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.
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
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