Datamart solution for professional services companies

Client _

  • Hybrid cloud data services company
  • >10000 employees
  • USA

Business case _

  • Centralize distributed data sources
  • Speed up the reporting process at company level

Industry _

  • IT Services
  • Professional services
  • Office automation

Services _

  • Custom software development
  • Managed services

Project type _

  • Operations
  • ETL backend
  • Customer support

Technology _

  • SQL Server
  • SQL Server Analysis Services
  • SQL Server Integration Services
  • Reporting Services
  • NetApp SnapManager for Microsoft
  • SQL Server
  • ETL
  • Tableau
  • Power BI
  • Excel
  • Splunk
  • Pentaho
  • Java
  • Groovy
  • Junit
  • Jetty
  • Tomcat
  • Jenkins
  • Maven
  • Continuous Integration

Description _

We have developed a system of multiple ETL processes for data aggregation from multiple sources, while building a set of Microsoft SSAS cubes to be consumed by various clients like Tableau and Excel.

Challenges _

When addressing users with little or no expertise in BI, we were required to:

  • Build a solution that’s easy to understand and use.
  • Integrate structured and unstructured data from multiple different websites.
  • Provide intuitive access to information.
  • Provide valuable insights for business decisions in real time.

Solutions _

We met client’s high expectations with a series of cross-technology solutions:

  • Development of an online platform to centralize the system’s analysis and reporting features.
  • Development of custom and configurable web crawlers to grab structured and unstructured data from different websites.
  • Integration of data received by email and RSS feeds.
  • Development of a series of ETL processes to build a data warehouse.
  • Development of Microsoft SSAS cubes.
  • Providing a comprehensive set of reports for DeltaMaster visualization and analysis tool.
  • Implementing a notification mechanism and an automatic newsletter generation and publishing.
  • Maintenance and support.
29 years in business | 2700 software projects | 760 clients | 24 countries

We turn ideas into software. What is yours?

Get in touch

5 + 3 =