CASE STUDY
Industry
Manufacturing
The client is a leading chemical manufacturer that supplies chemicals to many of its customers belonging to different industries, such as agrochemicals, personal care, textiles, etc. The client wanted to see their product growth and customer acquisitions on dashboards.
They also wanted to see two important aspects of business.
The analytics design team collaborated with the client to understand requirements and the business analyst team worked on consolidating and formulating requirements.
We created an end-to-end process to get business data from different sources, i.e., SAP Hana and Pipedrive, in different formats and transform them into the required schema of Snowflake, which acts as a data source for visualization and analytics.
Data pipelines were automated using Apache Airflow and deployed on the AWS cloud for security, availability, reliability, and scalability.
In Airflow DAGs, SQL and Python were used to fetch data from upstream.
Optimization was taken care of for streams by marking existing rows, updated rows, unchanged rows, and new rows. We optimized the code in such a way that it only fetches changed data.
To establish secure practices, AWS Secret Manager was used for all credentials.
To be cost-effective, we have written an AWS lambda function to start and stop EC2 at a specific time.
Tableau and Embedded Analytics were used for displaying analytics and intelligence solutions, with authentication in place for each user and department.
We created different visuals in Tableau and Embedded Analytics for important business metrics that help businesses understand their current growth and make decisions effectively.
Some of the business metrics are:
The client established a better vision and allocated funds to products more effectively, resulting in a 19.65% increase in fund utilization and a 6.54% increase in profitability.
2258 Norbury Dr, Smyrna,
GA 30067
5927 Almeda Road, Houston,
TX 77004
4585 Evelena CT Fremont,
CA 94536
50 Bruyeres Mews, M5V0H8,
Toronto, Ontario
Prince Turky Al Awal street,
Riyadh city, Saudi Arabia
1105, Shivalik Abaise, Prahlad Nagar,
Ahmedabad, Gujarat - 380015
288, 21st cross, 13th Main, Sector-7, H.S.R. Layout,
Bangalore - 560102
Quick Links
Subscribe to our newsletters
