Home | My Site 2

Steve McDonnell

An educator using data to understand and improve learning, brining my analytical mindset to data analysis.

About

Steve's Data Portfolio is a showcase of recent data analysis projects, highlighting the diverse techniques and approaches used to derive valuable insights. The portfolio offers a captivating journey into the world of data, connecting viewers to the essence of each analysis.

With a focus on analytical methodologies and visualization techniques, each project in Steve's Data Portfolio aims to evoke a deeper understanding and appreciation for the power of data.

Portfolio

View Projects

London Bike-Share Analysis with Python and Tableau

This project uses Python to conduct initial exploratory analysis and transform the data to prepare for visualisation in Tableau. The Tableau dashboard provides three key metrics and further data by hovering over dates or weather patterns to get a clear understanding of results at a given moment.

SQL COVID-19 Project

This project was conducted in SQL using a public database on Google's Big Query. This project is to demonstrate proficiency in SQL tasks such as aggregation using GROUP BY, SUM, MIN, MAX. I also use JOIN and CTEs to filter and sort through data.

Exam Results Dashboard

This Exam Results Dashboard can be used to compare exam results across a number of years, as well as against different grades to provide an overview of student progress.

Bellabeat Capstone Project

An exploratory analysis of fitness tracker use using R and Excel to find insights that can be used by Bellabeat to target their marketing towards fitness device customers. After R to understand the data better, Excel was used with Power Query to clean and process the data and provide some insightful visualisations.

Seoul Air Pollution

This dashboard uses data from Soul Public Data Plaza to plot changes in air pollution from 2008-2024. This gives a clear overview of the changes that have occurred and can be used to predict further changes and influence policy decisions.

.pro-gallery-wix-wrapper {display: block !important;} .pro-gallery-wix-wrapper .gallery-item-container {opacity: 1 !important; display: block !important;}