the assignment; part one to be done now, others later

The data for this project is from Kaggle (Brazil E-Commerce Data).
I encourage you to visit Kaggle to see some of the analyses others have
done with this data and consider how to incorporate some of them into
your work. You can also see a description of the data elements and the
files on there and some descriptive statistics. You can use this as an
inspiration for your dashboard. See the screenshot below for an example
of some of the descriptive statistics automatically available for this
dataset.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

To get started for this week, consider doing the following:

  • Prepare
    a final data set, adding the full state names in Brazil, the payment
    types used for the transactions, Category name in English, demographic
    characteristics of State, geographic coordinates (longitude and
    latitude) of sales.
  • Produce descriptive statistics of the data, which at a minimum will include:
    • Top products
    • Top 5 grossing states
    • Summary statistics of the key data elements. Summary statistics will include:
    • Show outlying data

i.By gross sales

ii.By product counts

iii.By number of customers

iv.Review (count top 4/5 ratings)

v.Delivered

vi.Cancelled

vii.Season

viii.Month

i.Min, max, mean, standard deviation, mode

Show results on a dashboard; see how to get started here.

Remember,
this is the minimum you can do. If you only do what is described in 2
a, b, c, d, you will not get the full grade. Put yourself in the shoes
of a manager and outline some of the metrics you would like to see based
on these data. Check with me regularly to update me on progress.