Enterprise BI solution / Fortune 500 Co.

Client ＿

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

Business case ＿

  • Provide customized insights based on big data
  • Display KPIs
  • Employ graphical presentations

Industry ＿

  • IT Services
  • Data storage
  • Cloud

Services ＿

  • Custom software development
  • Managed services

Project type ＿

  • Web
  • BI reporting
  • Operations
  • Customer support

Technology ＿

  • SQL Server
  • SQL Server Analysis Services
  • SQL Server Clone Database
  • NetApp SnapManager for Microsoft SQL Server
  • ETL
  • Tableau
  • Excel
  • Java
  • JavaScript
  • Junit
  • Jetty
  • Tomcat
  • Jenkins
  • Maven
  • Continuous Integration

Description ＿

The solution provides world-wide secured access for different business departments and regions, into valuable data, analysis and insights. The information is presented in several views, such as:

  • Multiple business-related KPIs: bookings, revenues forecast, billable percent of hours worked by engineers, costs, margins
  • Top partners
  • Support cases
  • Dashboards and graphical / tabular reports.

Challenges ＿

In order to make it the best-usable product for the client, we had to overcome several challenges:

  • Provide the most relevant business insights to the decision makers.
  • Aggregate different data formats from wide range of heterogeneous systems (SAP, ORACLE BI, WebServices, CSV, Excel, Sharepoint).
  • Keep the data fresh for all geographic regions, across a world-wide enterprise.

From technical perspective, we worked on:

  • Keeping the data available for query while importing it.
  • Securing sensitive data.
  • Jobs running 24 / 7.
  • Continually snapshot big amount of data, within short timeframes.

Solutions ＿

We met client’s high expectations, both at usability and technical level, with a series of cross-technology solutions:

  • Highly efficient cloning / database publishing mechanism setup for uninterrupted access to consistent data, while the ETL jobs are running.
  • Configuring security mechanism to mask sensitive data depending on user access rights.
  • Development of customized Web portal for instant access to dashboards and reports with slice and dice mechanism.
  • High availability and scalability using clusters and load balancing.
Download case study as .pdf file
29 years in business | 2700 software projects | 760 clients | 24 countries

We turn ideas into software. What is yours?

Get in touch

14 + 6 =