Tableau / MicroStrategy

During my time at Road Scholar, we went from pulling reports out of Business Objects into Excel to building a data warehouse with MicroStrategy as our interface. I was the first on my team to dive in and set up my reporting and analysis in MicroStrategy, and I then helped mentor my colleagues as they onboarded.

More recently at Mass General Brigham, we switched from using Google products to Tableau. This entailed spinning up data from both Google Analytics and Piwik Pro, integrating and cleaning the data in Tableau Prep, and creating helpful and insightful dashboards using Tableau Desktop.

Python and R

I am a relative newcomer to both R and Python, but they are fast becoming my mainstays. I use them to automate Excel (in one particular instance, I accomplished with six lines of R code what Excel took 10 columns of formulas to achieve), to scrape web data (from websites to social media followers), for data analysis (such as Google Analytics trends), and to pull and process data for my Etsy shop (a process which used to involve a manual website pull and extensive Excel formulas).

More recently, I have delved into machine learning and predictive modelling using Python. I was instrumental in developing a web content scorecard at Mass General Brigham to compare content algorithmically rather than subjectively. This project began (and flourished) in Python before moving to Tableau Prep.

Google Data Studio / Google Analytics / Google Tag Manager

When I hired on at Massachusetts General Hospital, they looked to me to build a suite of dashboards that would both inform about baseline trends as well as help derive insight. They had already implemented Google Analytics, so Data Studio was a logical (and cost effective) next step. I soon became an expert in the use of Data Studio, learning how to automate the underlying reports (through the use of Supermetrics), automate data processing (with formulas, case statements, and data blending in Data Studio), and how to present the dashboards in a visually appealing yet insightful way. A large part of the success of these dashboards has been the iterative process I’ve put them through - every time we discuss them as a team, there are new questions or insights that arise that help me to refine them for the better.

At Mass General Brigham, I quickly became the go-to person for Google Analytics questions vis-a-vis the website. Besides building Google Data Studio dashboards for 10+ hospital entity sites, we also used Google Tag Manager to standardize tags from different entity sites and create new event tracking to enable better decision making.

Excel

I am an Excel/Google Sheets power user, with extensive experience building pivot tables, data visualizations, and a wide array of formulas. I view Excel is a core skill as it helped me learn many of the concepts that make me successful with other analysis tools. That said, Excel does have limitations. I have expanded my skillset to include other tools like R, and Data Studio, MicroStrategy in order to become more efficient in the instances where Excel is not the best tool in the toolbox.