I am a results-oriented Budget Data Analyst with a strong foundation in data analysis, financial modeling, and strategic planning. Currently pursuing an MS in Analytics at Georgia Tech, I am enhancing my data science expertise to drive more effective decision-making in complex financial environments.

In my current role in state government, I specialize in building advanced Excel tools for budgeting, leveraging SQL for data querying, and administering online budget management and reporting systems. I am passionate about turning complex datasets into actionable insights and developing tools that streamline processes and enhance transparency.

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 is 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