This repository contains modeling of the Sakila ERD to a star schema using the Kimball approach and performs ETL (Extract, Transform, Load) from the source ERD to the destination star schema to optimize BI queries.
- Convert Sakila ERD (OLTP) to Star Schema (OLAP): Use the Kimball approach to make it easier and quicker to handle read-only queries, perform analysis, and gain insights.
- Extraction: Extract data from the Sakila database in SQL Server and perform data quality checks.
- Transformation: Transform the data from SQL to fit the star schema and calculate measures.
- Loading: Load the transformed data into the new destination star schema in SQL Server.
- Answer Business Questions: Use the new star schema to answer business questions and derive insights.
- Sql Server Management Studio(SSMS)
- SQL Server Integration Services(SSIS)
- Power BI
- https://github.com/ivanceras/sakila/tree/master (Creation and insertion of the database)