FACT: Sales, Inventory
Measurements: Sum(product), Sum(branchInventory)

Who?
    Customer(custID, jwID, cust_name)

What?
    Product(procID, jwID, name, description)

Where?
    Branch(branchID, jwID, Street, City, State)

When?
    Date(dateID, day, month, year)

Dim_Product
Dim_Date
Dim_Branch
Dim_Customer

Fact_Inventory
Fact_Sales

Dim_Customer
    Generate Rows
    Table Output
    Table Input
    Combination Lookup/Update
    


Dim_Date
    Table Input (Orders)
    Calculator Step (Separate into day, month, year)
    Table Output

Fact_Inventory
    Table Input (SQL Query)
    Lookup Steps (Dimension Tables)
    Load Fact Table Step

Fact_Sales
    Similar process as Fact_Inventory

Establish MySQL Connection
Visualize data with appropriate joins

Branch Location Map
Product Sales Bar Chart
Inventory Level by Month
Total Sales by Month