DataWarehouse

The Challenge

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

The Solution

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

Technology Stack

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.

Privacy Settings
We use cookies to enhance your experience while using our website. If you are using our Services via a browser you can restrict, block or remove cookies through your web browser settings. We also use content and scripts from third parties that may use tracking technologies. You can selectively provide your consent below to allow such third party embeds. For complete information about the cookies we use, data we collect and how we process them, please check our Privacy Policy
Youtube
Consent to display content from Youtube
Vimeo
Consent to display content from Vimeo
Google Maps
Consent to display content from Google
Spotify
Consent to display content from Spotify
Sound Cloud
Consent to display content from Sound