Case Study

Domain -Retail Focus Visualize the sales data Business challenge/requirement BigMart is one of the biggest retailers in Europe and has operations across multiple countries. You are a data analystin the IT team of BigMart. Invoice and SKU wise sales data for the Year 2011 is shared with you. You need to preparemeaningful charts to showcase the various sales trends for 2011 to top management.

Key issues

Data should be displayed pictorially to capture the attention of top management.Considerations

NONE

Data volume

Approx. 500K records -file BigMartSalesData.csv

Additional information

NA

Business benefits

This exercise is an annual exercise and BigMart makes an important investment decision based on trends.

Approach to Solve

You must use the fundamentals of Matplotlib covered in module 5 and plot the following four charts /graph:

1.Plot total sales per month for the Year 2011. How have

the total sales increased over the months in the Year 2011?Which month has the lowest sales?

2.Plot total sales per month for the Year 2011 as Bar Chart. Is Bar Chart better to visualize than Simple Plot?

3.Plot a Pie Chart for the Year 2011 Country Wise. Which Country contributes highest towards sales?

4.Plot Scatter Plot for the invoice amounts and see the concentration of amount. In which range have most of the invoice amounts concentrated ?

Enhancements for code

You can try the following enhancements in code:

1.Change the Bar Chart to show the value of a bar

2.In Pie Chart,shadow=true, startangle=90 and see how different the chart looks

3.In the Scatter Plot,change the color of Scatter Points