Cyclistic Bike Share Case Study
The Cyclistic Bike Share Case Study is from the Coursera Google Analytics Capstone course. The goal of this project was to determine factors that differentiate annual members and casual bike riders. These factors are then used to develop recommendations for a marketing campaign that aims to increase the membership conversion rate.
Tags: Capstone, Data Analysis, Data Processing, Data Viz, Google Analytics, Tableau
USDA Farmers Market Registrations Project
This data cleaning and analysis project used data collected by the USDA and Michigan State University. The goal was to examine yearly USDA farmers market registrations in the online USDA Local Food Directories from 2020-2022. Recommendations were then developed to improve the breadth of the directory.
Tags: Data Analysis, Data Processing, Data Viz, Project, Tableau
CA Safe Cosmetics Program (CSCP) Project
The data used for this project was collected by the CA Department of Public Health. The goal of this project was to convert the CSCP spreadsheet into a relational database for downstream analysis. This project was a two part article series: Part I discusses the creation of business rules and an entity relationship diagram for the CSCP dataset. Part II focuses on building the relational database.
Tags: Business Rules, Data Analysis, Data Processing, Data Viz, Metadata, Relational Database, Tableau
Reverie Books CT, LLC Inventory Database
Reverie Books CT, LLC is a small business that sells secondhand books via ecommerce and community tabling events. The client wanted a free, simple solution for managing their inventory, costs, and sales on Google Sheets. The project outcomes are discussed in report format.
Tags: Data Processing, Metadata, Relational Database, Spreadsheet