Skip to content

Key: Usage of external APIs, database design, Python to SQL Server connection, and a Tableau report

Notifications You must be signed in to change notification settings

zhangkelly014/E-commerce-Challenge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 

Repository files navigation

E-commerce-Challenge

Goal: provide a dashboard to the Finance department about the sales results for Q1.

A JSON array that contains orders, following this structure:

  • Order ID
  • Customer
    • ID
    • Name
    • Email
  • Total Order price
  • Creation date
  • Line items. For each one:
    • ID
    • Product ID
    • Product SKU
    • Product Name
    • Price

To keep it simple, we removed taxes, discounts. Note also that all prices are in USD (US Dollars).

About

Key: Usage of external APIs, database design, Python to SQL Server connection, and a Tableau report

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published