Using Pivot table, here are the results,

Products sold per Province:

Top 3 customers and the product they buy:

Trend:

Please write Descriptive and diagnostic Analytics related to this.

Please answer, i'll be sure to leave a like!

Canada is a country made up of individuals from many parts of the world. Barack and his family are one such example who arrived in Canada twenty years ago from a Central Asian country. In order to improve the quality of his family's life in Canada and also achieve some financial independence for his family, he enlisted the help of his friend who is knowledgeable in business operations, to help purchase a business where he can utilize his baking skills. Barack's friend has found a small Canadian bakery for sale. He has procured some data pertaining to the bakery's operations, which he provided to Barack. Barack is seeking your assistance in determining any patterns or insights that you can provide from this data. Required: Based on the information given, provide a data analysis looking at the four types of analytics: Descriptive Analytics - "What happened?" Diagnostic Analytics - "Why it happened?" Drag fields between aneas belaw: Drag fields betwean areas below: Drag felds between areas below: Canada is a country made up of individuals from many parts of the world. Barack and his family are one such example who arrived in Canada twenty years ago from a Central Asian country. In order to improve the quality of his family's life in Canada and also achieve some financial independence for his family, he enlisted the help of his friend who is knowledgeable in business operations, to help purchase a business where he can utilize his baking skills. Barack's friend has found a small Canadian bakery for sale. He has procured some data pertaining to the bakery's operations, which he provided to Barack. Barack is seeking your assistance in determining any patterns or insights that you can provide from this data. Required: Based on the information given, provide a data analysis looking at the four types of analytics: Descriptive Analytics - "What happened?" Diagnostic Analytics - "Why it happened?" Drag fields between aneas belaw: Drag fields betwean areas below: Drag felds between areas below