Robert Smith
This is my online portfolio to showcase data analytics projects. Let's connect on LinkedIn: https://www.linkedin.com/in/rs4l/
Data Analytics | Data Science | Data Visualization
Technical Skills: Excel, Python, SQL, Pandas, NumPy, Tableau, PowerBI
Education
-
B.B.A. in Business Analytics University of North Texas - Honors: President’s List, Dean’s List, 3.8 GPA
Projects
Waze Exploratory Data Analysis (EDA) and Data Cleaning - GADA Project 2
Project Link - Waze Exploratory Data Analysis and Data Cleaning
This Python project is the second project in Google’s Advanced Data Analytics Course. It focused on performing the EDA process and clean data on a dataset provided by Waze to predict user churn. The scope of this project stage is:
- Data Exploration
- Data Cleaning
- Handle Outliers
- Building Visualizations
- Evaluating and sharing results
Technical Skills: Python, Pandas, Matplotlib, Seaborn, Data visualization, Data Cleaning
College Project Repository
Project Link - Dating Application DataWarehousing
This is a repository featuring several different projects created during different courses at UNT. These include:
- Pathways to a Greener Future: CO₂ Emissions - This project examines global CO₂ emissions trends from 1960 to 2022 to identify key contributors, and propose data-driven solutions to support a 15% reduction target by 2030. The analysis was conducted using Excel, Tableau, and Power BI, leveraging the Six Sigma DMAIC methodology to ensure a structured and effective approach.
- Waiting Line Analysis - Froth Coffee Bar - This project analyzes utilizes descriptive statistics, probability distributions, and Monte Carlo simulations to identify bottlenecks, evaluate service capacity, and recommend data-driven solutions using Excel.
- Amazon’s Strategic Innovation - This project analyzes Amazon’s innovative strategies to mitigate supply chain disruptions by leveraging vertical integration and data-driven logistics optimization
Technical Skills: PowerPoint, Excel, Tableau, Power BI, Data visualization, Data Organizing, Slide Creation
Dating Application Data Warehousing
Project Link - Dating Application DataWarehousing
Data Warehousing Capstone Project – Dating Application Analysis As part of my Data Warehousing course at UNT, I developed a comprehensive data warehouse and solutions to analyze and visualize key performance indicators (KPIs) for a dating application. The project included:
- Designing conceptual and logical data models tailored to the application’s framework.
- Implementing an SQL-based data warehouse to organize and store application data.
- Creating an interactive Power BI dashboard to present insights offering a clear view of user trends and engagement metrics.
Technical skills: Data Modeling, SQL, SSMS, Data Warehousing, PowerBI, Dashboard Development, Data Visualization
TikTok Data Exploration - GADA Project 1
Project Link - TikTok Data Exploration Project
This Python project is the first project in Google’s Advanced Data Analytics Course. It focused on analyzing a dataset from TikTok containing video statistics which include metrics such as views, likes, shares, downloads, and comments. The goal of this project is:
- Build a dataframe for the claims classification data
- Develop exploratory statistics (mean, median, min, max) and develop initial observations of the dataset
- Organize the data for further data analysis in future projects.