Client Overview
The client is one of the giant retailers in the US that offers a variety of food supplies, and services. They have a strong reputation for providing high-quality products and outstanding customer service.
Client Requirements
- Create a looker dashboard to automate the Cost Per Unit calculation process for each variable between the current and previous fiscal year to eliminate the manual ETL and CPU calculation process in excel from Snowflake data tables.
- Build a looker dashboard to track the actual vs projected values for each variable for the current fiscal year and showcase the actual values for each variable for the previous fiscal year.