Case Study for Business Intelligense & Data Warehouse

Analytical Reporting System

Challenge

The client came to Altabel Group with a demand to create a warehouse on basis of the data from one of the procurements websites. According to the customer's requirements, functional specification and preferable technologies a number of adjustments should take place in the Oracle-based warehouse, SQL scripts for data warehouse needed to be developed, and a number of repots according to ad-hoc queries needed to be produced in Oracle Business Intelligence Enterprise Edition 10.

Solution

All the demands were successfully accomplished, as a result of close collaboration of Altabel team and our customer.

  • OBIEE 10 system regulation was realized.
  • Original variant of the scripts for data filling was developed.
  • Design and support of Data Warehouse was complete. The reports were generated on the base of the DB.

Results

The customer was satisfied with the work of our team and expressed desire for staying with us while developing further projects.

Technologies and tools

Oracle Business Intelligence Enterprise Edition 10, Oracle DB, SQL

Online Analytical Statistical System

Challenge

The client desired to design an analytical system that would allow giving report upon different user requests. According to the concept the system should work on the data from a numerous advertisement websites. The reports and statistics should be based on the data from the parsed websites.

Solution

The task of our team was to develop the system. Initially, our specialists developed detailed functional specification. In accordance with this specification a new working system ready to process queries was worked out:

  • The program was developed in Java. The data transferring is carried out with SQL scripts.
  • The adjustment of BI system tailored to process specialized queries. Microstrategy 9.2 was used to fulfill the adjustment. The data is taken from the DWH with Microstrategy. With the help of Microstrategy dashboards a corresponding usability was reached.

Results

The customer was satisfied with the results of the project. Finally, due to coordinated work of our specialists, qualified project managers and effective communication with the client all the requirements were fulfilled.

Technologies and tools

GreenPlum, MonetDb, MySQLv, JSP, EJB, Spring, Spring Security, Java

Healthcare Analytical System

Challenge

The customer realized that healthcare sector lacks powerful solutions which ensure efficient use of the data available. That was the reason why the objective of this project was to provide easier access to healthcare data and improving patient care.

All the healthcare data is gathered in Oracle-based data warehouse. The reports design process was held in Oracle BI Answers. The reports display presumed creation of specifically designed info boards.

Solution

The healthcare analytical system presents a large-scale Oracle-based data warehouse that allows making reports upon queries by different viewpoints. The task of our BI specialists was to design a set of reports to vary the way of presenting the information (diagrams, tables, procedures). Variants for reports criteria:

  • General information about the patients
  • Appointments information
  • Territorial information, etc.
  • Doctor's schedule

Results

All the requests were fulfilled. The customer was satisfied with the results of the work and expressed the desire to continue collaboration with Altabel Group.

Our developers and managers demonstrated deep understanding of the technology.

Technologies and tools

Oracle Business Intelligence Enterprise Edition 11:Oracle BI Administration Tool, Oracle BI Answers

Mobile Management System

Challenge

The company disposes SAP data warehouse and there was a need to perform ad-hoc analysis of the corporate data. The main challenge of the project was to design reports for WEB and iPad platforms. Platform for reports design was Microstrategy. Functioning data warehouse allows data transferring via MDX cubes. A set of varied reports was created.

Solution

Our client faced the necessity of optimizing their large scale data processing that would allow to simplify and optimize the daily operations of the enterprise.

Our specialists helped to develop a set of reports by the following custom queries:

  • Commodities and Equipment
  • Procurement information
  • Logistic figures, etc.
  • Workforce information
  • Economic performance
  • Objects characteristics

Results

The project is still on. Our specialists acquired in-depth knowledge in corporate day-to-day operations in order to provide high performance on the project. During the projects run our specialists demonstrated high competence in designing BI reports, which allowed our partner focus directly on in-house business flows.

Technologies and tools

SAP Business Information Warehouse, Microstrategy