Skip to content

Latest commit

 

History

History
84 lines (59 loc) · 4.94 KB

README.md

File metadata and controls

84 lines (59 loc) · 4.94 KB

Data Science Portfolio

Welcome to my portfolio repository! Discover projects showcasing my expertise in analytics, visualization, and machine learning techniques like predictive modeling, clustering, and classification. Using tools like Python, SQL, Power BI, and Tableau, I transform data into insights and recommendations to solve real-world problems.

Predictive Modeling Projects

Forecasting and predictions using statistical models and machine learning.

Predicting Residential Electricity Consumption Variability Using Temperature & Total Customers

  • Description: Analyzed the impact of temperature and customer count on residential electricity consumption using statistical models. Cleaned and prepared the dataset, performed exploratory data analysis, and developed predictive models to forecast consumption variability.
  • Technologies: R (readxl, dplyr, ggplot2, caret, forecast, lubridate, mgcv)

Data Querying & Management Projects

SQL and data management projects focusing on database design and querying.

Hospital COVID-19 Relational Database

  • Description: Designed and implemented a relational database using MySQL to manage COVID-19 data for hospitals, including a user interface for staff.
  • Technologies: MySQL

Data Analytics Projects

Excel-based analytics and performance tracking projects.

Amazon FC - Employee Performance System

  • Description: Implemented an Excel system containing charts and dashboards to highlight area performance. Achieved a 10% improvement in sorting efficiency, processing over 262,000 items per shift.
  • Technologies: Excel

Programming Projects

Software development and scripting with Python and APIs.

Weather Lookup

  • Description: Developed a Python program for weather lookup by zip code or city, utilizing the OpenWeatherMap API.
  • Technologies: Python, REST API

Data Visualization & Reporting Projects

Data analysis and visualization using tools like Power Bi, Tableau and Excel.

Concession Baseball Sales Dashboard

  • Description: Built a Power BI dashboard to track sales and performance of concessions at baseball games, optimizing inventory and pricing strategies.
  • Technologies: Power BI
  • PBIX File Download

Store Sales Dashboard

  • Description: Designed a Power BI sales dashboard to monitor KPIs, sales trends, and regional performance for effective decision-making.
  • Technologies: Power BI
  • PBIX File Download

US Mass Shootings Analysis

  • Description: Utilized Excel and Tableau to uncover a 13% increase in US mass shootings during COVID-19.
  • Technologies: Excel, Tableau

Covid Case Tracker

  • Description: Developed a Tableau dashboard visualizing COVID-19 cases, deaths, and testing data from sources like WHO and CDC.
  • Technologies: Tableau

Timely & Effective Care Across the US

  • Description: Created a Tableau dashboard for CMS data to help patients choose the best hospital based on quality of care metrics.
  • Technologies: Tableau, Data Visualization

Home Values in TN

  • Description: Analyzed Zillow data on home values in Tennessee from 2000 to 2022, creating an interactive Tableau dashboard to display value changes by zip code.
  • Technologies: Excel, Tableau

Open University Student GPA & Demographics Analysis

  • Description: Analyzed data from Open University, identifying correlations between GPA and demographics using Tableau.
  • Technologies: Excel, Tableau