1.Using the dataset provided and at least 3 charts, 3 pivot tables, one filter and 4 slicers, create a one page DASHBOARDthat summarises the sale of products year on year for Angelo. This submission (dashboard 1 page summary) makesup 17 of your 20 marks for Assessment 1.2.You will need to convert the dataset to an Excel table and then do some work on it for the analysis:a.Format all the rows in your table to a height of 13.2.b.Add a column that contains the year extracted from the Date.c.Add a column that contains the month number extracted from Date.d.Add a column that contains the month formatted in words e.g. Jan, Feb etc.3.Angelo has provided the following list of data which he is interested in viewing:a.Information on the countries and regions which are most profitable and have the most sales activity;b.An insight into SuperStores most popular products and those products which generate the most profit;c.Identification of any products which may be poor performing or at risk of becoming obsolete;d.Who SuperStores best and worst customers are and an indication of which products they enjoy, includingmargins (this will help Angelo to decide what products to discount);e.A monthly analysis of sales to help Angelo with stock and distribution staff levels. Angelo would reallyappreciate it if this can also show him which products are more popular at different times of the year;4.In addition to the above request, your discussions with Angelo highlighted that he would like to extend SuperStorestechnology product offering. You decide to include an additional analysis regarding the technology category ofproducts to help Angelo understand what customers and stores would be ideal for the new offerings.5.Angelo would like to see the data represented in a variety of charts and pivot tables. He would also like to be able tovary the data that is on these charts using filters and or slicers to make it as interactive as possible. In particular, hewould like to be able to slice the data by some of the following categories, as appropriate for the pivot tables youhave selected:a.Yearb.Monthc.Countryd.Statee.Product Categoryf.Sub Category6.Please make sure that your charts and other dashboard elements are appropriately labelled, i.e. with titles andchart labels.7.You need to submit the file containing your worksheet and dashboard to Blackboard for the head of sales (Angelo)to look at. Please use the Excel Files Assessment Task 1 folder on Blackboard and please make sure that yourfilename contains your last name and student number.8.You should also send Angelo a ONE PAGE summary of your work (maximum 1000 words /- 10%). This shouldexplain how to use your dashboard, why you have included the tables, charts, filters and slicers you have chosen,and highlight any specific choices you have made when categorising the above. Submit this to the folder supplied inBlackboard as well.9.You are required to also prepare a 500 word reflection on this task. You will find some resources for writing these inthe Assessments folder. Please consider your position at the outset, during and at completion of the task, makereference to the course materials and other resources used along the way, and reflect on how this assessment taskmight impact your approach to data visualisation in the future. Submit this to the Reflections: Assessment 1folder on Blackboard. This part of the assessment counts 3/20.
The post 1.Using the dataset provided and at least 3 charts, 3 pivot tables, one filter appeared first on .