Hi 👋
This Project is about building a Data Warehouse using SQL Server , includes ETL processing , Data Modelling and Analytics basically we built a 3 layerd schema project of data warehouse which includes Bronze, Silver and gold bronze where all the tabels are loded , silver where all the data integration , data transformation and data standerdization and data enrichment is done using Truncate and then insert method
TOOLS USED
- MS SQL SERVER
- Draw.io
3 LAYERED ARCHITECTURE
Bronze layer: All the tables from the database is loaded into new schema called a broze we use DROP AND INSERT menthods Nothing much just dato importing creating a structured architecture and a layerd format
silver layer: we created a new schema called a silver and perfored operation like data enrichment, logical data issues , data standerdization, data integration comparing all different tables and checking of invalid data making it usefull according to suggestions
gold Layer: in this final layer we made this schema a data visulizaion and analytics ready to gather insights and build dashboards we created 2 categories of dimension and facts views and gathered all diferent tables into 3 main tables