SharePoint Data Warehouse

  • Client:Hypokramed
  • Released:February 2013

Challange

Hypokramed uses Microsoft SharePoint 2010 as a main information system. The main implemented processes are related to sales and service – the key company activities. Management wanted to monitor these activities using graphical reports and statistics.

Mockup SharePoint Data Warehouse

Solution

We used SQL Server Reporting Services to show these statistics, particularly sales performance (real versus planned), service operations, salesmen evaluation, cell phone or car utilization, etc.

At the end of a project, it contains these major components:

  1. Data warehouse, which is SQL server database, that contains cleansed and consistent data related to sales, invoicing, service and operations processes. It includes history as well from former systems.
  2. Reports displaying Salesmen performance overview, sales statistics, Service activities overview etc.
  3. Data pumps. Data were loaded directly from SharePoint content database, including all relations. Warehouse is synchronized every half an hour, so users get their data almost real-time. Another part of the data is taken from accounting system.

Customer benefit

Reports are nested directly to SharePoint sites, so users have got everything they need on one place. The part of the implementation was a suggestion of system settings to optimize the server performance. Some forms in SharePoint were changed or simplified in order to improve user experience.

If you are you looking for something similar, please contact us.