Skip to content

Latest commit

 

History

History
73 lines (52 loc) · 6.15 KB

Analytic and dashboard report.md

File metadata and controls

73 lines (52 loc) · 6.15 KB

1. Overall

image

  • There are about 66,42k brazilians having experience shopping on E-commerce website and other shopping platforms .
    • With about 66,420 orders has been done by brazilians, there are 112,650 purchased products and 444M Brazilian real is total revenue in 3 years of operation.
    • Service of E-commerce has rated at 4.07 points.
  • Top 10 best selling products show us which is the our key product and which product we should have special preferential policy.
    • Overall, We can give a comment is that family stuffs are favorable items of Bazilians. With the development of economics, Brazilians also want to improve their life experience with useful home furniture and beauty items.
  • About Geographical Location
    • Sao Paulo (SP) vs Rio de Janeiro (RJ) are the best active state with the highest of purchasing product. With the supporting of favorable geographical area and the highest population density in Brazil, 28k and 9k numbers of products has been purchasing by these citizens.
    • By contrast, Rondônia (RO), Amazonas (AM), Acre (AC) has the disadvantages of transportation limit, geographical area undevelopement of business, they contribute badly to total orders of Brazil.

Image

  • Revenue shows signs of steady growth. Especially in quarter 4, is peak season in Brazil, with visitors from all around the world visiting to experience warm weather and Brazilian Christmas. It gets busy with the famous New Year's Eve celebrations, Christmas markets, and party scene.

2. Sale and Product

image

  • Bed_bath_table, healthy_beauty, Sport_leisure, Furniture_decor, Computer_accessories has the best contribute to total revenue of E-commerce company. In general, these are products to improve the quality of life and work

  • With the developed states and densely populated and largest of purchasing area as Sao Paulo, Rio de Janeiro and Minas Gerais , we can also understand that they are also on top of revenue contribute

  • With Products, the family and sporty items are always on top picking of citizens. Beside that, There are other items becomming popular in different months:

    • watches_gifts becomes hot items in quarter 2 (Apirl, May, June) where some occasions has been happened as Mother day, Fathers’ Day, Valentine Day of Brazil.
    • In quarter 4, Toys items are hot items. Because two famous occasions orcur in Brazil, Children's day and Christmast day
    • Computer Accessories items are purchased much on Jan, Feb, March. These months are time of the biggest sale off technology items.

3. Orders

image

  • E-commerce company has done a great job in delievery to customer with 97,01% order deliveried on time
  • With the developed states and densely populated area as Sao Paulo, Rio de Janeiro and Minas Gerais , we can also understand that they are also on top of the largest of purchasing area
  • we can observe the percentage growth of orders or decline month by month
    • The amount of orders tends to increase at the beginning of each season and decrease in the middle of the season of the year
  • 11, 13, 14, 15, 16. These are the hours that customers usually spend most in the day to place orders.

4. Transaction

image

  • With development of economic and technology, credit card is the first choice in selection of payment with about 76k orders used credit card
    • The time-saving of credit card is the reason make it become the most popular one.
    • Secondly, Credit card is also linked with the installment of banks and finance services. The procedure to start an installment is easy and fast.
  • Based on factors such as geographical location, traffic conditions, topography, each province has a different average delivery time.
    • We should shorten the delivery time as much as possible, so that we can deliver the goods to the customer as quickly as possible.

5. Review

image

  • We got 42k order have comment (41,76%) and quite good average score (4.07 / 5.0), 57,43% is 5 score and 3,23% is 1 score
  • We got top 5 States and Product category have highest average score, and also top 5 bottom of it
    • The things that cause customers to underestimate some products or services are because the quality of the product is not good, the product has been damaged during transportation, the shipping time is too long.....

6. Recommendation

  • 🚩 So, I believe that this E-commerce should:
    • Run creative seasonal marketing campaigns (vouchers, discounts...) with different products. Besides the best-selling items, we need to have marketing campaigns for the items that are not selling well.
    • Most of the reasons suburban areas have low product sales, small orders and slow delivery is because the geographical conditions of both customers and shippers are not guaranteed. Therefore, we need to invest in building freight stations in the suburbs so that customers in that area can easily order.
    • Marketing campaigns should be most active in the hours of 11am, 1pm, 2pm, 3pm, and 4pm, because that time is very crowded with free customers.
    • Continue to accompany domestic enterprises such as banking and financial services to upgrade customer service experience. Especially, the paid service
    • Should have automatic feedback tasks to thank customers when they have a positive review
    • Listen and record negative customer feedback about products and services... To find out the unreasonable points (price, quality, delivery, errors) and fix them