Automation for Routine Interactive Dashboards and
Ethics Surveys

Competitor analysis

Tools

Overview

From multiple stakeholders: We need to monitor data trends
as soon as they are published.

By providing accurate, timely, and actionable data, Institutional Research and Planning (sometimes by Strategic planning and competitive intelligence) supports evidence-based decision-making across multiple domains, from strategic planning to operational efficiency.


As an office with multiple subscriptions to secondary data, we frequently receive requests from stakeholders eager to review the latest data as soon as it becomes available. To fulfill this commitment, automation is primarily used to support:

(1) Various routine interactive dashboards

(2) Ethics survey reports

Downloaded and cleaned secondary survey data to meet specific metric requirements

Roles

As a Research Associate, I had the opportunity to work closely with the highest levels of leadership, including the Office of the President. In this role, I also collaborated with numerous departments and colleges, helping them develop strategic plans and providing actionable insights. Managing multiple high-stakes projects simultaneously was essential.

  • I maintained strong relationships with stakeholders, developing research plans tailored to their needs and ensuring their questions were answered with precision and insight.

  • I harnessed the power of R, SPSS, and Tableau to create and maintain automated, multi-year interactive visualization dashboards, which required only the simple task of loading new data when available. These dashboards were published on the official Ohio State University website, showcasing the impact and quality of my work.

  • I leveraged Excel VBA to automate report generation for over 30 stakeholders, ensuring timely and accurate delivery.

Responsibilities

Independently collaborated with internal stakeholders to develop tailored research plans and deliver actionable insights

  • Excel (regular formula and VBA)

  • R software

  • SPSS

  • Tableau

Data Analysis

Impacts

Leveraged a range of quantitative data analysis tools to develop and maintain automated dashboards and generate reports with precision and efficiency.

Tailored interactive dashboards or formal reports and presented data results to the internal stakeholders

Dashboard Example

  • Automated college reports by using Excel VBA, resulting in 400% time-saving.

  • Automated interactive dashboards by using Tableau and Excel, resulting in 300% time-saving.

  • Identified numerous opportunities to enhance institutional operations, boost performance, and elevate rankings.

Outputs

  • 60+ automatically generated PDF reports for 30+ stakeholders

  • Multiple interactive dashboards published on the official OSU website

Survey (secondary research)

Multiple secondary data sources