What level of data aggregation will be required by the audience?
Implement the design with MySQL Workbench as we did during the sessions.Īttached you will find the full Data Modeling report and the designed DW Schema. Identify the entities based on the selected approach (fact tables, dimension tables, and metrics). Select between using a corporate information, multidimensional approach or data vault approach. Make a decision for each one of these data quality issues.
The dataset is an event log that describes the process of how an incident within the ServiceNow Solution for Incident Management System is reported, processed and managed within an IT company. In this repository, I share an End-to-End BI & DW project done during my studies at IE University: