Data mart solution for professional services companies

Data mart solution for professional services companies _

For one of our clients, we worked on a data mart solution. 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.

Client _

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

Business case _

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

Industry _

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

Challenges _

When addressing users with little or no expertise in BI, our team had to overcome the following challenges:

  • Build a data mart solution that’s easy to understand and use by all users.
  • 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 in order 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.

Interested to know more about our expertise in office automation solutions?

29 years in business | 2700 software projects | 760 clients | 24 countries

We turn ideas into software. What is yours?

Get in touch

13 + 7 =