The client wanted to setup a light weight datawarehouse solution and doest want to invest heavy into tools. They wanted to setup a robust and scalable datawarehouse with a minimal TCO to ensure that the cost of operations are controlled as they scale the business
Dew Solutions’ team developed the Data warehousing solution for an E-commerce client over a lightweight stack of Talend and Mysql and facilitated reporting over Tableau. The solution involved consuming feeds through talend jobs that run over various frequencies throught the day and perform ETL transformations with the aggregated business data moved to Mart for business reporting
The solution was built over a light weight stack of Talend & Mysql with reporting facilitated over Tableau. The stack was hosted over optimised Cloud infra with complete monitoring ovr Nagios.