Today we were given our second task of the week, which was outlined as such:
The industry I chose was the luxury watch industry, and more specifically a luxury watch retailer called The Watchdog.
Firstly, I wrote down the fields I wanted which were:
- Order Date
- Watch Brand
- Watch Model
- City
- Cost Price (Price at which retailer bought the watch)
- Sale Price
- Insurance premium (1.4-1.6% of Sale Price)
- Order ID
- Loyalty Level (Bronze, Silver, Gold, Platinum)
- Customer Name
Once I had gathered the fields I wanted I went to Mockaroo and began mocking my data.
Mockaroo
In Mockaroo, I was able to get a majority of the fields I wanted. However, I am not the most skilled in the ruby syntax that Mockaroo uses so I had some troubles which I had to solve in Alteryx.
For example, I wrote down Watch Models with their brand name in it, but I wanted to make Watch Brand field by using an if statement that would roughly say "if the field Watch Model contains Omega then Watch Brand = Omega" and so on. However, I couldn't find a contains function for Mockaroo.
Alteryx
In Alteryx I made some fields that I felt like I didn't have time to figure out in Mockaroo. I made the Watch Model field as I previously stated. I also edited my cost & sale price fields with a multi-row formula to change the prices depending on the watch brand since some brands are more expensive than others. I also calculated the profit and added longitudes and latitudes for each city. I then also removed 25% of the insurance premiums since I know that not everyone opts into watch insurance.
In the end I made a dashboard that closely resembles the colour scheme of the t-shirt I was wearing today, here it is!
