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.