About Me
Hello, my name is Malachi Simmons. I'm a Data Analyst accomplished in compiling, transforming, and analyzing complex information through software. Experienced in machine learning and large dataset management. Demonstrated success in identifying relationships and building solutions to business problems.
Project Case Studies
GameCo Project: Performed descriptive analysis of video game sales by region.
Influenza Project: Assisted staff agency with staffing in the US for upcoming flu season.
Rockbuster Stealth Project: Designed business analysis for fictional movie rental
company looking to launch an online video rental service.
​
My Skillset
-
Advanced Data Mining
-
Relational Database Management System (RDBMS)
-
Research Project Design
-
Spreadsheet Development
-
Analyzing, filtering, merging, and creation of Data Dictionary in SQL.
-
Tableau
-
Geospatial mapping
-
Tableau Dashboard/Storyboard result in video presentation to stakeholders
-
Analyzing Data, importing servers, cleaning and filtering, grouping/aggregating, creating visualizations in Python.
-
Jupytor Notebook
-
Pandas
-
Forecasting
-
Predictive modeling
-
Advanced Excel Spreadsheet Functions
-
Team Leadership
-
Data Cleaning
-
Quantitative Data Analysis
-
Descriptive Data Analysis
-
Data Integration
-
Data Sourcing
-
Data transformation and profiling.
-
Hypothesis testing
-
Statistical and Visual Analysis
Instacart Project
Objective
Instacart is an online grocery store that operates through an app. They already have good sales, but they want to uncover more information about their sales patterns.
Final Analysis
Number of orders (in millions) grouped by customer profile for sales in the top 5 departments.
Number of orders (in millions) grouped by customer profile and showing total sales for different age categories
Instacart Tools and skills
-
Python
-
Jupytor Notebook
-
RDBMS
-
Analyzing Data in Python
-
Importing Servers (Pandas)
-
Cleaning and filtering Data in Python
-
Data grouping and aggregating
-
Creating visualizations in Python
-
New Variable Derivation
This pie chart shows how much the customer profile makes up the total sales
Number of orders (in millions) grouped by customer profile and showing total sales for the different regions.
Recommendations
​
-
Saturday is the busiest day and Wednesday is the least busy.
-
12:00 P.M. is the busiest hour of the day.
-
The max order amount for an object is $99. The cheapest object is $1. I would advise trying to get this price down since most customers do not spend $100 on a single item.
-
The top 5 departments are produce, dairy eggs, snacks, beverages, and frozen. Produce is the top-selling product, and it is the most frequently used department for parents.
-
A little over %9 of the orders are made up of parents of at least one kid, 25 years or older and making less than $400,000 a year. About %4 is made up of single adults following this same criteria.
-
Parents following the customer profile spend the most on produce. Also, most of our customers are in the South.
-
We get more orders from parents than non-parents. Parents also spend more on average than non-parents. More parents are loyal customers than non-parents. 35-44 years of age and 65 to 74 years of age make up the most orders than any other age group.