I'm a dynamic Research Consultant driven by results, armed with a BS in Mathematics, an MA in Teaching, and an ongoing pursuit of an MS in Analytics at Georgia Tech. My teaching background exemplifies my fervor for mathematics, showcasing my adaptability in any environment. Now, I'm poised to channel these talents into the realm of data analytics, continuously augmenting my technical expertise.

My solid grounding in mathematics is complemented by adept problem-solving and communication abilities, enabling me to distill intricate concepts for stakeholders. Explore this platform for a glimpse into my professional journey and a curated collection of my projects outside of my work responsibilities.

Bike Sales Dashboard - Excel

This project was completed in Excel to find patterns in bike purchase trends to improve marketing strategies. This analysis could also be used as a basis for further exploration into how to best utilize public transportation systems and pedestrian/cyclist facilities.

The Excel file which includes both the data and dashboard are available in this repository.

Summary

Data was sourced from “Alex the Analyst” on YouTube.

Skills Used in Excel

Data Cleaning
Data Validation
Data Visualization
Pivot Tables
Formulas (SUMIFS, COUNT, CORREL, custom calculations)

Michael McCarthy

Bike Sales Dashboard - Excel

Summary

Skills Used in Excel

Dashboard Sample