ETL Solutions

Red Dragon Consulting provides data extract/transform/load ("ETL") services including analyzing and architecting the appropriate ETL process for your data, customized coding for executing the ETL process and validation/audits of the resulting data extracts.

​

For example, one company had multiple KPIs established for the website team to achieve general website usage targets (sessions, impressions, clicks) as well as specific digital campaign open rates and click through rates. By automating the monthly data  extraction and cleansing process from Google Analytics as well as Salesforce and Pardot, dashboards could be created to visualize these KPIs and identify problem areas in different world regions based on paid vs. unpaid ('organic') ad campaigns. 

​

You can see use the visualization of this data in a dashboard of general website usage here, digital campaign open rates here, and click through rates here.

​

Utilizing optimally aggregated and cleansed data is a critical first step in performing insightful data analysis.