This analysis served as my capstone project for my Google Data Analytics Certification.  I was asked to review 12 months of bikeshare user data and identify differences in user trends between casual (one-time) riders and annual members.  The goal of this project was to use my findings to develop a plan for converting casual riders into members.

Through my analysis, I gained great insight into how these different groups used bikeshare services.  

(There were even a few surprises!)

I was able to use this data to provide 3 data-driven recommendations for digital marketing initiatives to turn casual riders into members.

Please check out my final report below in the format of your choice (slideshow or R Markdown).  I would love to discuss this with you further as it was my first deep dive into big data. 

This interactive dashboard was created to help Disney Dreamlight Valley players make gardening decisions in-game based on potential profits.  Players unlock different locations/zones by progressing in the game, giving them access to different crops that can be grown in their gardens.  

Each crop has a unique seed cost, growth time, yield per seed/harvest, and sell price.  Players must decide which crops they can access and afford.  Of those, players can choose which crops will give them the highest profits.  

I compiled all of the relevant data for each crop into an Excel Spreadsheet and added formulas to determine profit, profit margin, and more.  

In the dashboard below, users can filter by location in order to look at only the crops they have access to, or they can look at all crops in order to decide which zones to unlock next. 

Using this dashboard, you can see right away that pumpkins offer the highest profit, but also take the longest to grow.  Tomatoes, on the other hand, are a great alternative for newer players who have fewer zones unlocked and have limited funds for seeds.  They offer the highest profit margin and only take 25 minutes to grow.  

It is the purpose of this dashboard to allow players to make the best gardening decisions for them based on their own game progression and available funds.