2023
Developed a central datawarehouse solution for a global retailer, replicating transactional data into a consolidated AWS RDS SQL Server instance to enable enterprise-wide group reporting.
Developed a central datawarehouse solution for a global retailer, replicating transactional data into a consolidated AWS RDS SQL Server instance to enable enterprise-wide group reporting
What we did
- Ingested data from more than 20 source systems, including Oracle, SQL Server, and legacy operational databases.
- Semantic model developed in Tableau along with sales and operational dashboards for enterprise-wide reporting.
Tech
AWS RedShift AWS RDS Microsoft SQL Server PostgreSQL Oracle Tableau