Define the objectives for this business intelligence tool,
Define the business indicators, dimensions and statistics that will be compiled and used to evaluate each indicator and the performance of the virtual market with regards to each stakeholder
Design the supporting data warehouse – a multidimensional database emulated by a relational engine (star data model) – to store the indicators metrics,
The procedures to extract, clean and aggregate information from the operational database (MySQL) of the virtual market (ETL),
Job related skills
OLAP
Datawarehouse
Multidimensionla databases, Star and Snowflake data models