What is Business Intelligence? Business Intelligence systems consolidate data across disparate systems into a single data warehouse. A centralized data warehouse provides the ability to relate data from all systems, and perform analysis across all aspects of your business. Microsoft business intelligence expands on your current investments in Microsoft SQL Server, SharePoint Server 2010 and Microsoft Office. Our solution integrates these three components to provide a complete, end to end solution empowering you to make better, more informed business decisions.
| Presentation Layer
Utilize SharePoint Server 2010 to present data to the users: PerformancePoint Services - Dashboards, Scorecards, KPIs Excel Services / PowerPivot - Charts, Graphs all stored centrally in SharePoint Visio Services - Data overlaid on diagrams to aid in putting information into context SQL Server Reporting Services in SharePoint Integrated Mode Custom Bing Maps - provide a fully functional Bing Map overlaid with your data, providing a geographical view of content.
|
| 
| Data Warehouse Design
Data Warehouses are SQL Server databases using a star schema to hold all of the fact and dimension tables required for analysis across the source systems. The new data warehouse will act as the destination for the ETL routines, and the source of OLAP cubes and reports. |
| 
| Extract, Transform, and Load Routines
Microsoft SQL Server Integration Services provides the tools to build extract, transform, and load routines required to populate the data warehouse. These SSIS packages can be scheduled to run at appropriate intervals to ensure that the data warehouse is up to date. The ETL routine can also create layers of data within the warehouse, providing the ability to surface trends.
|
| 
| Data Cubes
Microsoft SQL Server Analysis Services provides the ability to create multi-dimensional OLAP cubes using the data warehouse as the source. These cubes provide pre-aggregated calculations across the hierarchies defined within the cube dimensions and act as the source for dashboards, KPIs, scorecards and interactive charts. |