Automating Data Preparation and Visualization in Tableau
About The Client:The client is a customer-focused, full-service, contract research organization (CRO) that delivers fast and flexible solutions across global clinical trials. The company accelerates clinical trials to successful completion.
Business Need:The client needs an automated solution to streamline and standardize the data preparation and visualization processes in Tableau, which currently involves multiple dashboards, templates, and data sources to improve response times.
- Implemented a new automated process leveraging Snowflake data warehouses, eliminating manual intervention and the need to handle .csv and .xls files.
- Ensure a smooth data pipeline from extraction to intermediate storage to populating Tableau Project Server and refreshing Dashboards and Reports.