Hi! I'm Serena Monroe

I provide data analysis for companies who understand that insights drive innovation.  

Los Angeles, CA 


Skills


Data

  • Python
  • SQL
  • Power BI
  • Excel
  • Tableau 


Programming

  • JavaScript
  • Python
  • HTML
  • CSS 
  • SQL and I've used IDEs like . 

  • Eclipse
  • Visual Studio Code
  • Pycharm
  • MySQL Workbench 
  • SQL Server Management Studio 

Featured Projects

Tableau Dashboard for MyPath2ASU

My Role

  • Data Analyst

What

Starting with a data set containing 882 entries in .xlsx file format, the objective was to visualize MyPath2ASU sign-up trends over the course of a month.

Deliverables

  • Interactive Dashboard


Why

The goal of this project was to gain an understanding of when sign-ups occur and what institutions and ASU colleges they're associated with. Stakeholders will be able to leverage campaign efforts based on opportunity areas. 

Competencies

  • Tableau 
  • Data cleaning

How

I organized the data by categories such as state, community college, ASU college, online interest as well as agreement type. The user of this dashboard can toggle through various data points and easily see trends based on their selection. 


Tableau Dashboard for British Airways

My Role

  • Business Intelligence (BI) Analyst

What

Starting with data for British Airways in .csv file format, I wanted to build a visualization that could help stakeholders interpret the data in a meaningful way.  


Average Monthly Revenue for Northwind Traders

My Role

  • ETL Developer
  • Data Analyst

What

The goal was to visualize and understand the revenue performance of a distributor company by analyzing 2,156 transactions and identifying key customers (Austria, Germany, and the U.S.). The analysis aimed to reveal trends in product sales and seasonal fluctuations.


Contact Me

smmonro2@asu.edu

My Sites