Retail Analytics
Contribution of the two companies to the Merger
Revenue Analysis
Sales Analysis
Identifying Customer Base and their geographic location
Customer Analytics
Discover Customer Buying Patterns
Project information
Designed a robust data warehouse environment for the merger of two companies and their Sales business process. This schema holds the data for the online and the retail parts of the business. Automated the schema re-generation using SQL scripts and performed ETL and stagging using SSIS to navigate data into the warehouse. Finally manufactured an easy-to-read, user-friendly, and self-service dashboard.