Data Warehouse and analytics project

Welcome to the Data Warehouse and analytics project respiratory Building a modern data warehouse with SQL server, invluding ETL processes, data modeling and analytics. ##Project requirements

Building the data warehouse

Objective

• Date sources: import data from source systems (ERP and CRM) provided as CSV files.

• Data quality: Clean and resolve data quality prior to analysis

• intergreation: combine both sources into a single, user-friendly data model designed for analytical queries.

• Scope: Focus on the latest dataset only; historization of data is not required

• Documentation: Prove clear documentation of the data model to support both business stakeholders and analytical teams

  BI: Analytics and Reporting (Data analytics)

  Objectives

  Develop SQL-based analytics to deliver detailed insight into: -Customer behavior -Product performance -Sales trends