XYZ Camera Warehouse is a distribution company that manages the shipping and inventory of camera
others
Description
BANA00091
XYZ Camera
Warehouse is a distribution company that manages the shipping and inventory of
camera
equipment.
Their head of marketing has asked you to develop an interactive dashboard and
presentation to
help answer
and provide recommendations to the following questions:
● How have the trends in each customer base by
camera brand changed over time?
○ You will need to analyze these trends in two
different ways:
i. Outbound
and inbound shipping events
ii. Cameras
that are physically “in the field” with customers
● Hint: this may
require creating a table that allows a user to determine whether a
specific
camera is “in the field” with a customer on any given day
● Which camera brands do customers prefer the
most as a percentage of the total over time?
● Which camera brands are most popular per
capita by state from 2016 to 2018?
Included in
this challenge are two data sets: “shipping_events.csv” and
“customer_locations.csv”
● shipping_events :
Each record represents either a “Shipped” or “Returned” event for a given
customer and
camera. There are no restrictions on how long a customer may keep a camera.
● customer_location :
Each record represents a customer, the camera they ordered, and the
geographic
state where they are located.
As part of
the interactive dashboard design, the product management team is primarily
interested in seeing
the data by
camera brand and would like to be able to dynamically:
● Adjust the date aggregation at the day,
week, month, quarter, and year level
● Toggle between showing raw counts and
percent share
Since the
state population data will need to be updated periodically, please use a
publicly available API to
retrieve
these data.
