Calculate total sales amount across all stores per month

Assignment Help Python Programming

Reference no: EM133305737

Data:

You'll be using this data to perform the data analysis. The given data has transaction information from 10 different stores over a period of 3 months.

Warmup:

1. Firstly, explore the data by looking at the provided columns.
a. What do you understand about each column from a quick scan of column names and types?
b. Columns of interest - What is the relationship between columns "BILL_AMT", "QTY", "VALUE" and "PRICE" in the given data?

Technical Analysis:

1. Sales by store - Calculate the total sales amount made by each store over the entire three months and visualize with a plot of your choice.
2. Sales by category - For each store, find the category of products that's sold the most (qty) and visualize with a plot of your choice.
3. Sales by day - For each store, find the day across all three months where the total sales amount is the highest. In other words, find the best day for each store in terms of sales amount and visualize with a plot of your choice.

Bonus:

1. Sales by month - Calculate total sales amount across all stores per month to find the best month across the given three months and visualize with a plot of your choice.

Reference no: EM133305737

Questions Cloud

Financial presentation to board of regents : You are an intercollegiate athletic director and have been asked to give a financial presentation to the Board of Regents.

How established companies can create successful innovation : How established companies can create successful innovation ecosystems. How would YOU create an organizational culture that fosters innovation?

What are the cultural implications of training : What are the cultural implications of training? How can culture be nurtured to impact the organizational environment in a healthy way?

Examples of alternative energy : Environmentalists discuss many examples of alternative energy - such as solar, wind and other renewable energies - as opposed to fossil fuels.

Calculate total sales amount across all stores per month : Calculate total sales amount across all stores per month to find the best month across the given three months and visualize with a plot of your choice

Analyzing a dataset for the national institute of justice : You are analyzing a dataset for the National Institute of Justice. Currently, you are assessing the data provided by participants about their ages.

What is intelligent systems and what are retail examples : What is Intelligent Systems? What are retail examples of Intelligent System?

Write a reflective journal entry on practicum activities : Write a reflective journal entry responding the following:Practicum Activities Reflection: Provide observations and thoughts on the activities in your practicum

How can tax cost ratio impact investor return : How can tax cost ratio impact an investor return? Would it be more tax efficient for a client to withdraw funds from a 401k or taxable brokerage account?

User Account

All Pages