This is Data Warehouse project for a US based Online payment catering firm. The project provide a single view of reports which highlight product value and YOY total revenue.
The solution was created using Microsoft SQL Server, SSIS, Tableau, Cozyroc, Salesforce, NetSuite, SSAS.
The created report provides the customer with different dashboards with multiple filters using which the customer can filter out data on the dashboard as per their requirements. The dashboard also provides the count for the unique records in the system and the records that have been deduped.
- Client was able to know about the transaction being performed using application
- Client was able to gain insights into the revenue being generated YOY which allowed them to improve customer engagement using actual data reports and forecasts.