Hey, I'm Matt, a motivated and detail-oriented professional with a background in biomedical science, now transitioning into the exciting field of data analysis. My journey is driven by a passion for uncovering meaningful insights from data to drive strategic decision-making and business success.
Explore my portfolio to see how I uncover insights from data.
Projects
This project dives into the Northwind database, offering a platform akin to real-world scenarios for analysing sales data for Northwind Traders, a hypothetical international gourmet food distributor. It aims to evaluate employee performance, understand product sales and category performance, analyse sales growth, and evaluate customer purchase behaviour.
Skills Demonstrated:
- Window Functions
- CTEs (Common Table Expressions)
- Data-informed Decisions
In this project, I delved into the Chinook sample database, which simulates a digital media store environment. Using SQL queries and analysis, I explored sales trends, assessed employee performance, and examined customer purchasing behaviour to extract actionable insights for refining and optimising business strategies.
Skills Demonstrated:
- Querying and joins
- Data aggregation and analysis
- Business insights and recommendations
In this project, I worked with data from the CIA World Factbook, a compendium of statistics about all of the countries on Earth.
Skills Demonstrated:
- Summary statistics
- Subqueries
Here I've developed an interactive Excel dashboard for coffee sales that enables users to analyse sales data based on date ranges, roast type, package size, and loyalty membership status.
Skills Demonstrated:
- XLOOKUP, INDEX MATCH, IF
- Pivot tables
- Line and bar charts for sales trends and comparisons
- Timeline and slicers for dynamic filtering and enhanced dashboard usability
In this analysis, I aimed to determine a few indicators of heavy traffic on I-94. Understanding what indicators contribute to the severity of traffic could aid in making informed and data-driven decisions on how to prepare and potentially reduce the impact of these.
Skills Demonstrated:
- Line graphs and time series
- Scatter plots and correlations
- Bar plots, histograms, and distributions
- Pandas visualisations and grid charts
This Jupyter Notebook project contains an analysis of Android and iOS mobile apps using datasets found on Kaggle. It attempts to understand what type of apps are likely to attract more users, to assist a hypothetical company in deciding on which apps to develop within these markets.
Skills Demonstrated:
- The basics of programming in Python (arithmetical operations, variables, common data types, etc.)
- List and for loops
- Conditional statements
- Dictionaries and frequency tables
- Functions
This project aims to clean and analyse a dataset of used cars from eBay Kleinanzeigen, a classifieds section of the German eBay website.
Skills Demonstrated:
- Exploring data with Pandas
- Data cleaning
This project aims to explore submissions on the Hacker News website to compare the average number of comments and points received by 'Ask HN' and 'Show HN' posts. Additionally, it seeks to analyse whether posts created at specific times receive more comments or points on average.
Skills Demonstrated:
- Working with strings
- Object-oriented programming
- Dates and times