Create a data ware house using data lake.

Create three layers.

Bronze, Silver and Gold

You will dump data from at least two sources in the Bronze area. You will do the transformation including deduping, cleaning data and removing unwanted data using any relevant tools $($Python Notebook, SQL$,$ Data Factory or other ETL tools and and move it to the Silver area.

From Silver area, you will create facts and dimensions to design your data warehouse. You can use data lake or SQL warehouse for the final Data Warehouse structure. You will create denormalized tables for dimensions and create a minimum of two fact tables with different conformed dimensions.

Finally, you will build the data visualization using your choice of tools.

explain step by step with the dataset and its link and the tools used$((($dont use azure$)))$