The project has been executed for an Italian retailer, leader in the cosmetics sector, specialized in natural products without superfluous chemicals in them.
We worked with the brand to complete their corporate Business Intelligence; project objectives can be summarized as follows:
The project was divided into several phases, starting with the creation of a Business Requirements Document, in order to assess the situation as-is and any to-be necessities.
Then, we structured and conducted in-depth surveys with the main corporate stakeholders, which proved essential to identify any critical issues, needs and new requests to add to the BI.
This also helped us to map the main KPIs, crucial to build and identify the different Datasets and the related Data Model.
Adopting a universal Naming Convention for the project was also necessary to combine and sort all the information available.
Through a vendor selection, we identify the best technology tool for the brand for data extraction, transformation and loading, which we then loaded in the corporate Data warehouse.
The last BI construction phase was building a Data Visualization in Qlik Sense suitable to consult data and corporate requests.
After 6 months of project, we created a Data Quality to validate the Business Intelligence achieved.
The results obtained for the Brand were important for data analysis purposes, and led to: