1) Review the provided Scenario/background 2) Download/Create Tableau: https://www.tableau.com/academic (only required to create one of these) 3) Create a Tableau visual using the “Big Deals Country Sales” and “Big Deals Project Sales” provided. NOTE: all data provided may not be used but majority of it will be. 4) Create in Tableau an analytical visualization such as a worksheet or dashboards to analyze the data and present it to Big deals based on the questions provided below: 1. Reduce inventory of slow-moving and obsolete products: a.How do the sales of each product compare with forecasts? b. How do the sales of each product compare with prior year sales? c.How are the sales of each product compared with the competition? d.How are the sales of each product compared with other product sales? e.If there is a particular product not selling well, is this specific to any particular region? 2. Enhance the marketing strategy by product type: a.Are there any poorly performing products in high-performing countries? b.If there is a poorly performing product in a high-performing country, how is this product performing compared with the sales in other countries and the competition? 5) Provide completed visual in a tableau format
should not. For example, some countries will prohibit milk that are not natural or some criteria needs to be fulfilled. This will discourage business and affect their profitability. However, to increase the profitability of business, China-Australia Free Trade Agreement (ChAFTA) was introduced in December 2015, aim to support economic growth, job creation and higher living standards. So this creates an opportunity for the company to grow and prosper (Austrade.gov.au, 2019).
Economic factor are determinants of a certain economy’s performance. This factor will have impact on how profitable the company is due to its purchasing power on consumers and demand/supply in the economy as well as how company price their product and services (B2U – Business-to-you.com, 2019).
The Australia milk industry economic can be affect by some of the following factors such as growth rate, purchasing power of consumers and demand for milk. There are research that shows the demand for A2 Milk is gaining traction among consumers due to the health benefits (A2 Milk Market: Global Industry Trends, 2019). In addition, since consumers are adjusting their lifestyle, company such as Fonterra Co-operative Group Limited formed partnership with A2 Milk to further provide growth opportunities to benefit both players. The demand for milk gives the industry an opportunity to be more profitable (Ibisworld.com, 2019). Another factor is purchasing power of consumer. Increase in purchasing power means consumers have more income to purchase more milk to adjust to their healthy lifestyle. This will create an opportunity for A2 to earn more. However, Australia economy is experiencing a slow growth, this will cause the profitability to decrease. In addition, some parents prefers to breastfeed their child therefore, this creates a threat to the demand of infant milk.