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 take 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:
- Requirements gathering
- Building windows
- Building Cubes
- Setting Up Infrastructure
Project team
Analyst
Frank Sh.
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.
