Andrew Brock
Data Analyst | Martinsburg, WV
SUMMARY
PROJECTS
Data Analyst with a background in
Mathematics, proficient in thinking
analytically to determine useful
insights, and utilizing those
findings to guide decision-making
through comprehensive reporting
and dynamic data visualizations.
OCT 2021 – CURRENT
TECHNICAL SKILLS
Data Analytics Projects | CareerFoundry | Google | Personal
Brazilian E-Commerce by Olist | Gain insights on how to grow the business
-
Wrangle, clean, merge data with Jupyter Notebooks.
Exploratory analysis, descriptive statistics, create new variables, drop
unnecessary columns, identify trends.
Identify key metrics to emphasize popular products.
Create dashboards and story for final report in Tableau.
Use previous sales data to determine where to grow the business.
Rockbuster Stealth Movie Rentals | Transition to online streaming service
Excel
..Tableau
…. R
SQL
Python
Jupyter
EDUCATION
FEB 2024
Data Analytics Program
CareerFoundry
FEB 2022
Data Analytics Professional
Certificate
Google
DEC 2014
B.S. Mathematics
B.A. Secondary Education
Fairmont State University
-
Utilize DBVisualizer to display ERD for good data understanding.
Create a data dictionary for easy interpretations and analysis.
Write complex queries including JOINs, CTEs, dynamic subqueries,
and more to gain answers to business questions.
Create custom dynamic visualizations with Tableau that display the
most popular movies to launch the online streaming service with.
Prepare final report with PowerPoint, Excel, and Tableau Dashboards.
Additional Projects Available at: abrock304.github.io
EXPERIENCE
AUG 2014 – CURRENT
Math Teacher | Musselman High School | Berkeley County Schools, WV
Record and analyze testing data over multiple platforms. Identify trends and
insights to motivate teaching strategies.
Compare data to county, state, and nation to recognize low categories.
Create lessons with complicated ideas and break them down into
manageable steps so that learning becomes easier.
Volunteer additional time outside of school to help with various school
activities including sporting events, Prom, Graduation, and many others.
PHONE |-
EMAIL |-
AUG 2014 - CURRENT
Musselman High School Assistant Track & Field Coach
WEBSITE | ABROCK304.GITHUB.IO
Manage and teach groups of high school students’ work ethic and teamwork.
LOCATION | ON SITE / REMOTE
Motivate and encourage athletes through different techniques and strategies.
Build positive relationships with athletes and coaches.