Objective is : Develop a modern data warehouse using SQL Server to combine Sales Data, Enabling Data Analytical reporting and informed decision making

Specs:

• Data Sources : Import Data from 2 sources ( CRM & ERP ) provided as CSV file
• Data Quality : Cleanse and resolve data quality issue prior to analysis
• Integration : Combine both sources of data into one coherent, user-friendly data model designed for analytical queries
• Scope : Focus on latest dataset only, Historization is not a requirement
• Documentation : Provide clear documentation of data model to support both business stakeholders and analytics teams