SharePoint Data Warehouse

Better data visualization

Improved user experience

Optimized performance

Challenge

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

Logo
  • Reports are nested directly to SharePoint sites, so users see everything they need in one place
  • Part of the implementation was a system setting to optimize the server performance
  • Forms in SharePoint were changed or simplified in order to improve the user experience

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:

Data warehouse, which is SQL server database, that contains cleansed and consistent data related to sales, invoicing, service and operations processes. It includes a history of former systems.

Reports displaying Salesmen performance overview, sales statistics, Service activities overview etc.

Data pumps. Data were loaded directly from SharePoint content database, including all relations. The warehouse is synchronized every half an hour, so users get their data almost real-time. Another part of the data is taken from the accounting system.


Technologies used

KONTAKT

Сhcete dokonalé řešení
pro svou firmu?

Pattern

Spojte se s námi

Zajímavý fakt

Did you know that on average we respond within 3 hours?

You know we're not afraid of any challenges?

Did you know that we have 5-10 litres of coffee flowing every day?

    I agree to the processing of personal data according to GDPR