08-Building-Power-BI-Report-for-Waggle

Building a Power BI Report for Waggle

Project 2 of Udacity's Data Analysis and Visualization with Microsoft Power BI Nanodegree Program in Creating Visualizations with Power BI course.

Project Description:

Waggle is a startup that makes smart devices for pets. Recently, they has been thrilled by the success of their new Lapdog device, a fitness collar that lets owners track their dog’s steps, alerts them when it’s time for a walk, and even repels fleas! Reviews have been fantastic, sales are growing, and—best of all—the product really works!

The product team distributed 1,000 Lapcat prototypes for field testing. Now, after months of data collection, we have been tasked with delivering a boardroom-ready Power BI report that tells the story of how the Lapcat data compares to findings from the dog collar Lapdog devices to either help convince the CEO that Lapcat is the next big thing or a costly mistake to be avoided.

Below is a quick demonestration about the project components.

Data Model:

A snapshot of the data model is provided below and can be found on Waggle-data-model.png on this repo.

Report Requirements:

• The CEO is curious about the following questions:
  • Did the average daily steps increase for cats wearing the device as they did for dogs?
  • Were owners of Lapcat devices as satisfied with the product as Lapdog owners?
• The Chief Marketing Officer would like the 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 us to incorporate other visuals and insights as we see fit but is most interested in comparisons between the dogs and cats using Waggle devices as well as any information about the families who own the pets. They would also like slicers to help them filter and explore on their own.
• The report should include:
  • at least five slicers on each page with at least one example of a drop-down slicer, at least one example of a slider slicer, at least one example of a hierarchy slicer, at least one example of a slicer with “Select All” enabled, and one example of a slicer with the search box enabled.
  • at least two bookmark features. One must allow users to dynamically swap one visual out with a different one and another must reset all applied filters on the page.
  • buttons that help users navigate the report tabs. they must respond when users hover over them by changing color or size

The report is to include 3 tabs

• The first page should highlight the CEO’s business questions, specifically calling out the differences in average step count and average user rating between Lapdog and Lapcat devices.
• The second page should focus on insights related to pets using the device.
• The third page should focus on insights related to the families that own the pets.

Full PDF report can be found on Waggle-Report.pdf file provided on this repo.

Report Tab 1:

To address the CEO’s questions

• 2 visualizations were ploted to highlight the difference between average daily steps over time recorded on Lapdog devices vs. Lapcat devices displaying the trend over time by year and month.
• 2 visualizations highlighted the difference between the customer ratings for Lapdog devices vs. Lapcat devices in adition to the number of rates.

---

Report Tab 2:

To drive insights from the pets dataset, the second tab included:

• A visualization that shows the breed distribution of cats and dogs.
• 2 visualization that highlighted both genderandagedistributions along the dataset withpet type` as hue.

---

Report Tab 3:

To drive insights from the family dataset, the third tab included:

• A table that shows important family data.
• A card that shows the count of total pets on the dataset, and has 2 bookmark buttons to show only cat or dog counts.
• A visualization that shows the relation between house hold income and number of owned pets along the dataset with pet type as hue.

---