Issue

• Our data was largely siloed. We had no central data repository and we needed to see different data sets combined to evaluate campaigns.
• Reporting was mostly ad hoc Excel spreadsheets. We had some processes for regular reports, but they were few and mostly manual.
• Data from our EMR (electronic medical record) system was one of the most important metrics but required extensive cleaning and was very time-intensive.

Solution

• I worked with our team to identify relevant data sources and KPIs. I led the research into business intelligence software, deciding on Domo.
• I developed a process for querying data relative to the service lines that we track. I also developed workflows using ETL and relational databases within Domo to automate data cleanup and processing.
• Using custom VBA script and Python script, I developed methods for cleaning data extracted from our EMR.
• I designed multiple dashboards to visualize data from social media, earned media, digital marketing, email, SEO, and patient volume.