SQL and OLAP cubes development
About project
Business effect
The task of the project was to develop a set of storefronts and OLAP cubes for building reporting. The limitations of infrastructure capacity required the construction of various optimizations.
Cubes help build and debug the company's analytical process. Assembling reports takes minutes instead of days. Indicators can be viewed in dynamics and various sections.
Solution
Tabular data sources were used to develop the analytical application.
Stages of work:
  1. Requirements gathering
  2. Building windows
  3. Building Cubes
  4. Setting Up Infrastructure
Project team
Analist
Frank S.
Engineer
Dmitry B.
Areas of use
The case is useful for various companies that use analytical cubes to build reporting and that lack a Pivot Table.
By clicking on the "Send message" button you consent to the processing of personal data
Send us a request
By sending us a request, you will receive feedback as soon as possible