SQL and OLAP cubes development
About project
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.
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.
Business effect
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
Dmitry B.
Engineer
Frank Sh.
Analyst
Areas of use
The case is useful for various companies that use analytical cubes to build reporting and that lack a Pivot Table.
