An End-to-End Data Analytics Project (E-Commerce Business)

An ecommerce business is any business that buys and sells goods or services over the internet. Ecommerce business's will digitally transfer money and data to execute these online transactions. The ecommerce business industry is exploding. Brick and mortar stores that temporarily closed may never open again.

Shopping online used to be a convenience and a luxury, now – it’s a necessity. Ecommerce has been growing for a while, and the numbers below don’t account for the recent events leading to an increase in ecommerce sales.

Step-by-Step Ecommerce Guide to own an ecommerce business

• Step 1: Research Ecommerce Business Models
• Step 2: Start Ecommerce Niche Research
• Step 3: Validate Target Market and Product Ideas
• Step 4: Register Your Ecommerce Business & Brand Name
• Step 5: Finalize Your Ecommerce Business Plan
• Step 6: Create Your Online Store
• Step 7: Attracting Customers to Your Ecommerce Store

Justification for the project

Online retail is a booming business. But we’ve seen too many ecommerce businesses struggle to get traction. As your business grows it’s very likely you’ll want to grow your product range and your target audience, as well as develop your business for customer requirements and consumer demand.

With the data provided, we can help Micheal Store get a deeper understanding of what needs to be done and how to scale their revenue.

Below is a link to the Data Model and the data source.

Data Model available Here

The raw file can be downloaded here:

Dataset available Here

You can read more about it Here

ER Diagram for Micheal Store

How to use this reposiroty:

Option 1

• Download and unzip the repo in your local machine
• Run this Micheal Database Development Project
• Upload the files using the File Upload Wizard in your RDBMS. Right click on the table you wish to populate and select the data import wizard. A screen like this will 👇 will be shown

Populate the table in this order:

• First: Sales Channel Table
• Second: Customer Table
• Third: Products Table
• Fourth: Regions Table
• Fifth: States Table
• Sixth: Sales Team Table
• Seventh: Warehouse Table
• Eight: County Table
• Nineth: Time Zone Table
• Tenth: City Type Table
• Eleventh: Store Location Table
• Finally: Orders Table

Option 2

• create a database micheal_store
• Download the micheal-store folder from here or download the single files below and execute in the following the order:
  • First: Sales Channel Query
  • Second: Customer Query
  • Third: Products Query
  • Fourth: Regions Query
  • Fifth: States Query
  • Sixth: Sales Team Query
  • Seventh: Warehouse Query
  • Eight: County Query
  • Nineth: Time Zone Query
  • Tenth: City Type Query
  • Eleventh: Store Location Query
  • Finally: Orders Query

N:B The currency of the values is USD.

Happy Data Sleuthing!

Follow me on LinkedIn:

Feel free to fork and use for yourself.