Skip to content

Data Analysis Portfolio Project #2---Waggle

Tables Of Contents

  1. Project Overview
  2. Business Requests
  3. Data Description and Cleaning
  4. Findings
  5. Conclusion

Project Overview

I completed this case study as a part of my Udacity Nanodegree in Power BI. The project focused on creating visualizations for the fictional pet device company, Waggle.

Executive Summary

As a business intelligence analyst at Waggle, I find myself immersed in a fascinating project surrounding our innovative Lapcat device. Waggle, the startup known for creating smart devices for pets, has witnessed remarkable success with the Lapdog, a fitness collar designed to track a dog's steps, signal walk times, and even repel fleas. With glowing reviews and growing sales, the Lapdog has proven to be a game-changer.

Encouraged by this success, Waggle's CEO is eager to explore the possibilities of a feline counterpart, Lapcat. However, concerns about its viability prompted the distribution of 1,000 Lapcat prototypes for extensive field testing in 2020. Now, after months of diligent data collection, I have the exciting task of crafting a boardroom-ready Power BI report. This report will tell the narrative of how the Lapcat data aligns with and diverges from the insights gleaned from our Lapdog devices. The stakes are high, as this presentation will play a pivotal role in influencing the CEO's decision on whether Lapcat is the next big breakthrough or a potential costly misstep to be avoided.

Business Requests

The CEO is curious about the following:

  1. Highlight the difference (if any) between average daily steps over time recorded on Lapdog devices vs. Lapcat devices.
  2. Were owners of Lapcat devices as satisfied with the product as Lapdog owners?
  3. Provide insights on the dog breeds that use the device most frequently
  4. Provide insights on income, number of pets, and annual pet expenses by City/State

  • The Chief Marketing Officer would like your report to be “on-brand” by including only colors from the Waggle color palette, the Waggle logo, and other approved company logos and icons.

  • The product team trusts you to incorporate other visuals and insights as you see fit. Still, it is most interested in demographic comparisons between the dogs and cats using Waggle devices and any information about the families who own the pets. They would also like slicers to help them filter and explore independently.

  • The product team would also like to see a single dog breed highlighted as a use case to see the difference between male and female dogs of the same breed and the differences in activity levels(i.e., activity minutes, daily steps).

Data Description

  • Date Table: Created by me Using Power Query Editor
  • Family Data: Data About US Pet Owners that Own Lapdog or Lapcat, Including Address, Income, and Number of Pets Owned
  • Pet Data: Data for Pets Using LapDog or LapCat, including age, gender, weight, name, and an ID number
  • Rating Data: Data Showing the Ratings by Each Customer for LapDog and LapCat
  • Tracker Data: Data Showing the Daily Steps and activity minutes for each pet using LapDog and LapCat Years of Data: 2018-2020

Finding #1

The data clearly illustrates the success of the LapDog device with a steady increase in daily steps for dogs from 2018-2020, reaching an impressive average of 15K steps per day as of December 2020. The LapDog's high device score of 4.69 out of 5 across 48K devices further emphasizes its popularity and reliability. However, the LapCat device has struggled with a low device score of 1.64 and minimal daily step activity, showing no improvement and a decrease from 2.8K to 2.7K steps. The findings suggest that the LapCat device may not be a viable product.

Finding #2

The interactive metric dashboard focusing on the LapDog's distribution across different dog breeds reveals that the top three breeds – Golden Retriever, Labrador, and Bulldog – collectively represent 8% of dogs wearing the LapDog device. Gender-wise, male and female dogs have a relatively equal distribution, with both showing similar daily activity levels. The insight that the top three dog breeds exhibit the highest daily steps at 12.2K steps suggests a positive correlation between breed popularity and device usage.

Finding #3

The bubble map and table dashboard showcasing geographic, income, and pet ownership data highlights Montpelier, Vermont, Mansfield, Ohio, and Cumming, Georgia, as the top three cities with high average income, total pets, and annual pet expenses. These insights offer a valuable opportunity for targeted marketing efforts, as pet owners in these areas already demonstrate a higher propensity to spend on pet care.

‌
‌
‌