Serena Monroe
Business Intelligence Analyst
Skills
Data
- Tableau
- Power BI
- Alteryx
- Looker
- Python
- AWS
- SQL
- Excel
- DBeaver
- Redshift
- Salesforce
- Peoplesoft
Programming
- JavaScript
- Python
- HTML
- CSS
- SQL
- Eclipse
- Visual Studio Code
- Pycharm
- MySQL Workbench
- SQL Server Management Studio
Featured Projects
Fall Out Boy Dashboard
The purpose of this project was to practice building a dataset and explore how interactivity can enhance storytelling and engagement in data visualization. One of the biggest parts of this project was building the dataset from scratch. Streamlined by Excel and Power Query, I compiled and structured information across songs and albums, including word frequency, lyrical diversity metrics, chart performance, YouTube engagement, and production information.
A feature I'm especially proud of is the interactivity within the dashboard. I experimented with Tableau URL actions to embed external media, allowing users to hear specific lyrics based on selection.
Scooby-Doo Dashboard
The goal of this project was to combine nostalgic pop culture with modern data visualization to create an engaging, storytelling-focused dashboard. It showcases my ability to work with categorical data, build interactive visual elements, and design a user-friendly Tableau experience.
In this project, I experimented with custom shapes to achieve the character shape integration on the bar chart. This was also achieved by using the dual axis feature.
Night of the Living Trends Dashboard
To get into the spooky season, I created this dashboard to explore popular Halloween costumes, worst fears, best & worst candy preferences, horror movies by release date and highest-rated Creepypastas. I experimented with dual axes and custom shapes for the candy bar chart which was a fun feature of the dashboard.
MyPath2ASU Dashboard
This dashboard analyzes MyPath2ASU sign-up data* to better understand prospective transfer student interest. MyPath2ASU helps students at two-year institutions explore clear graduation pathways as they transition to Arizona State University. The visualization highlights where prospective transfer students are expressing interest in ASU, providing admissions leaders with actionable insights to refine recruitment strategies, prioritize outreach efforts, and strengthen partnerships with community colleges.
*The dataset preserves the structure and relationships of the original data but does not represent actual student records.
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.
