About this project
The ask was to provIde insights for key performance for a fictitious company named Northwind Traders.
I used calculated columns to aggregate data as it was too granular for a high level analysis. It also required data wrangling to separate the unit of measure and I wanted to know which Materials were used for the containers as these should be monitored for price and I believe every company should measure ESG metrics, reduce its footprint and become more sustainable.
For a real world feeling, I changed the names of the fictitious carriers to UPS, FedEx and FedEx Priority One (overnight) and used real world wording like the Regions LATAM, NA & EMEA and to make a point that there is no presence in the APAC market.
I purposely left out the Customers as the small size customers may be the big ones a year from now and viceversa.
On a personal note, I wanted to incorporate recent learnings from the course Semantic Notation by the IBCS thru OpenSAP & the Financial Modeling course by Maven Analytics, for this reason I chose the Zebra BI Visuals.
I enjoyed working on this project although there is always a clash between fake datasets and real life events, then I hear Federico Pastor who always says: analyze with what you have.
