Managed Analytics Services to Support Strategic Market Analysis

Customer

The Customer is a US management consultancy that advises their clients on strategic, financial and marketing aspects of their businesses.

Challenge

Having unique market data from disintegrated sources, the Customer wanted to conduct strategic analysis of the airline industry market and provide this information as a service.

Solution

As the Customer had clear requirements regarding the analysis but wanted the outsourcing partner to take responsibility for the technical embodiment, our consultants offered the Customer managed analytics services.

With these services, the Customer did not have to worry about BI infrastructure deployment and management. This, as well as the solution’s performance, availability, security and data quality management, was totally the responsibility of ScienceSoft.

To enable the Customer to get insights from the 10-year history of external data, our team deployed a BI solution on a dedicated server in ScienceSoft’s data center. The solution consisted of a data warehouse, an OLAP cube, and a web interface. To extract the data from Microsoft Excel and faultlessly load it into a data warehouse, our team also implemented an ETL process.

Within the OLAP cube, ScienceSoft created 10 dimensions, such as:

  • Airlines
  • Countries
  • Dates
  • Airline by country
  • Airline by size
  • Airline by carrier type
  • Airline by ownership.

The OLAP cube also contained the following measures:

  • EBIDTA
  • Revenue
  • Debt
  • Net income
  • Growth over year.

A friendly web interface allows the Customer to check prebuilt reports, as well as aggregate, slice and dice the data. Its another advantage is the possibility to set permissions to let a user access the reports from both their desktop or mobile.

Results

For a monthly subscription fee, the Customer is getting pre-built reports where they can find valuable insights, as well as explore a particular aspect of their interest in more detail. The Customer is also able to provide this information as a service by granting access to the reports to their clients.

Technologies

Microsoft SQL Server (a data warehouse), Microsoft SQL Server Integration Services (ETL), Microsoft SQL Server Analysis Services (an OLAP cube), Kyubit Business Intelligence (a web interface).

MORE CASE STUDIES
COVID-19 – An update to our clients
In the uncertain time of Coronavirus (COVID-19) outbreak, I want to assure you that ScienceSoft remains fully operational and dedicated to supporting the continuity of our customers’ businesses. Most of ScienceSoft’s employees work remotely, and we’re equipped to provide our services in new conditions, with no impact on the quality of service or communication.
In the uncertain time of Coronavirus (COVID-19) outbreak, I want to assure you that ScienceSoft remains fully operational and dedicated to supporting the continuity of our customers’ businesses. Most of ScienceSoft’s employees work remotely, and we’re equipped to provide our services in new conditions, with no impact on the quality of service or communication.
Stay safe and healthy,
Nikolay Kurayev,
Chief Executive Officer at ScienceSoft