DESCRIPTION

Nestle is the largest food company in the world marketing over 8,500 brands and 30,000 products. It operates nearly 500 factories across 5 continents and employs over 20,000 employees worldwide. At the World Food Company, Nestle is the provider of the best food for whatever time of day and for whatever time of your life.

Nestle R&D Australia plays an important role in the development of products for Nestle Nutrition, with the focus on creating products with micro-nutrient fortification to address deficiencies.

BUSINESS PROBLEM

The company wants to expand its business by adding new product lines. However, the Head of Growth and Strategy suggested that it was important to know the performance of the current products.

TASK

I have been employed as a Data Analyst in the Growth and Strategy department of Nestle and asked t develop a product comparison dashboard to help the company take a decision on its expansion plans.

BUSINESS QUESTIONS

1. What is the trend of total sales per product in the last 3 years?
2. What is the monthly sales trend?
3. Compare the different products based on the maximum and minimum revenue generated
4. Which location had the highest and lowest sales?
5. Generate insights from the sales medium to help the Head of Growth and Strategy take a decision

Interact with my dashboard for further insights