Overview E-Commerce is the activity of buying or selling products

Overview

E-Commerce is the activity of buying or selling products through online services or over the Internet. The e-commerce market has changed the way business is transacted, whether in retail or business-to-business, locally or globally.

The dataset of this project is from an online store, which includes product information and customer transaction records from 2016 to 2018. The ultimate goal of the company is to improve the sales. In this project, you’re supposed to find out the online shopping behaviors of the customers and make marketing suggestions for the store in order to increase the customers’ life-time value to the company.

Dataset

The dataset has 7 tables, which include customer transaction information for each order and the product information:

onlineshop_customers.sql

onlineshop_orders_items.sql: one order can contain more than one item.

onlineshop_orders.sql: ‘fulfilled’ indicates the order was completed.

onlineshop_products_sku.sql: ‘sku’ represent stock keeping unit, which is used to track inventory in the store.

onlineshop_product.sql

onlineshop_traffic.sql: page_views: each time a user visits a web page, it is called a page view; sessions: a session is a group of user interactions with your website that take place within a given time frame; avg_session_in_s: average seconds in one session.

onlineshop_transactions.sql: status success indicates the transaction was completed.

Assignment

The objective of this E-Commerce project is to test your SQL skills as well as data analytics skills. Firstly, because the dataset is in .sql format, you will need to load the dataset into MySQL Workbench. Make sure to create a schema first, the sql files are for individual tables. Feel free to utilize visualizations and research material to support your responses to some of the tasks and questions. Also, remember to show your calculations.

  1. Describe the relationship between each table.
  2. Find the Product type, Product style and SKU number for each product. (You may join different tables together to get your proper result)
  3. What’s the total number of orders for each product type? What’s the most popular product type?
  4. What are the monthly total sales and monthly total orders? How about the total orders for each product over time?
  5. How about traffic over time e.g. page views, and sessions? Do you see any relationship between traffic and orders over time?
  6. Select and calculate important business metrics, e.g. churn rate, retention rate, conversion rate. Justify your selection and explain and interpret the result.
  7. The goal for almost all companies is to boost sales. With that in mind, based on the metrics that you calculated, what business suggestions are you able to provide in order to achieve the goal.

Requirement:

  • 4 pages minimum. The cover page and reference page/s are not included in the above-stated page requirement.
  • Papers need to be formatted in proper APA 7th Edition style.
  • A minimum of at least three outside peer-reviewed sources for your references.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Foundation Society and Culture

Essay Structure 1200 word essay, with a minimum of 1,000 words. It is important to ensure your work is within range. Words exceeding the word count will not receive credit. For example, if the introduction and methodology are very long and the method and data collection is not reached by

You will assume the role of “management consultant” (one who

  You will assume the role of “management consultant” (one who is hired from outside the organization—to remain objective—to analyze, strategize, investigate, and make suggestions on how to improve return on investment [ROI], production, efficiency, or make a team more effective [that is the one you will undertake]). You will

Week 2 Discussion Eye Conditions AM is a 22-year-old man

Week 2 Discussion Eye Conditions AM is a 22-year-old man presenting to the local emergency department (ED) with acute onset  of right eye pain. The pain started 6 hours prior and has not improved with artificial tears or oral  acetaminophen. He reports the possibility of accidentally “scratching his right eye” when trying  to

For this assignment, you will review the latest evidence based

  For this assignment, you will review the latest evidence based guidelines as they pertain to the case below. Discussion of the case is based on the course objectives and weekly content, which emphasize the core learning objectives for an evidence-based primary care curriculum. Throughout your nurse practitioner program, case

Instructions You’ve already chosen your topic for the Research Study.

Instructions You’ve already chosen your topic for the Research Study. You selected an exceptionality to study–click here to remind yourself of what you selected. For this third article summary, you will have have to search the internet using Google to search for support services or agencies that serve the exceptionality

Select one of the group therapy video demonstrations from this

  Select one of the group therapy video demonstrations from this week’s required media Learning Resources.   What group therapy techniques were demonstrated? How well do you believe these techniques were demonstrated? What evidence from the literature supports the techniques demonstrated?  What did you notice that the therapist did well?

Immunoglobulin-Related Disease (IgG4-RD) is an immune-mediated condition that can cause

Immunoglobulin-Related Disease (IgG4-RD) is an immune-mediated condition that can cause fibro-inflammatory lesions in nearly any organ (Wallace et al., 2019). It is a chronic, fibrotic inflammation characterized by the involvement of multiple organs. The most common manifestations of the disease include swelling of salivary and lacrimal glands, lymphadenopathy, and type

1. peer-reviewed journal articles on the topic of Disaster Recovery

 1.  peer-reviewed journal articles on the topic of Disaster Recovery Planning   2.  peer-reviewed journal articles on the topic of Cyberlaw (do not use Google or Wikipedia). Choose an article that includes all parts listed in the Article Critique Rubric below.  3. peer-reviewed journal articles on the topic of Cybersecurity

answer the question and reply on two post Question: Is

answer the question and reply on two post  Question: Is a telecommuting policy a benefit that is essential to attracting top employees to a company?  Why or why not? student 1  A telecommuting policy includes defining online work hours, hourly reporting, security protocol and communication guidelines. No, I don’t believe

People are using their mobile phone browsers more and more

People are using their mobile phone browsers more and more every day to find information about businesses, make product decisions and purchases, and even determine the quality of a business based on what they can find online. Providing an optimal mobile user interface (UI) and specialized mobile content for enterprise

Task: Read the case file: Honda in Europe which is

  Task: Read the case file: Honda in Europe which is attached  Follow the attached outline and guidelines for the case write-up shown in the syllabus (Pg. 10/11) and write a case analysis. Please develop your paper based on those guidelines. Please use different section headings based on the guidelines

Create a patient-centered concept map and write a 3-5 page

Create a patient-centered concept map and write a 3-5 page narrative in which you explain the process and considerations that went into creating your concept map. Introduction Evidence-based practice is a key skill in the tool kit of the master’s-prepared nurse. Its goal is to ensure that health care practitioners

Method Section Part II This week you will be continuing

  Method Section Part II This week you will be continuing with the Method section of your Program Evaluation Report. Please refer to page 222 and complete the following subsections of the Method section:  Setting, Participants, and Outcomes and Measures.  Be sure to include sources that provide data related to

Strategic planning means planning based on a company’s strategy or

Strategic planning means planning based on a company’s strategy or direction for a significant period. IT innovation means doing something never done before. Respond to the following in a minimum of 175 words: Discuss what role IT innovation should play in a company’s strategic plan, and why. Should a company plan

The MS Word template attached to this week’s assignment includes

 The MS Word template attached to this week’s assignment includes 10 questions from the content material you have covered in Chapters 3 and 5 (weeks 3 and 4).  Research each of these questions in your textbook and online as instructed in each question.  Also, give examples as you are prompted in

Pediatric Health & Medical Worksheet Nursing Assignment Help

Provider: i. Questions for HPI When did these symptoms begin? Is the child experience exercise intolerance? Any shortness of breath/signs of respiratory distress? History of genetic conditions? ii. Questions for ROS Poor feeding? Any newborn cardiac concerns? Previous cardiac history? Any pain, weakness, coldness to the extremities? Fluid retention? Cough

Select a major organization that was located near the area

Select a major organization that was located near the area affected by Hurricane Katrina in 2005. Research their experiences and prepare a report detailing the unexpected challenges the organization encountered in returning operations to normal. Give suggestions for what might be added to the organization’s contingency plan to mitigate those

Read- While not all nurses will conduct research studies, every

Read-  While not all nurses will conduct research studies, every nurse will be required to implement evidence-based practice (EBP). Evidence-based practice is an integral approach designed to provide nursing care; it incorporates the best evidence from the literature and the expertise of the clinician coupled with the preferences and values