Orders Dimensional Model Mapping
Budget: ₹1,500 – ₹12,500 INR
I’ll give you an Orders table (roughly X columns) and some 11 columns are nested with the list of order dimensions and facts I already use. Your task is to inspect every column, decide whether it belongs in one of those dimensions or is truly a fact that from the dims and facts i gave, and then document that decision clearly.
Once the column-by-column mapping is finished, I also need a concise dimensional model diagram—think classic star schema—showing each of my dimensions linked to the central fact table. A simple PDF or image generated from Visio, Lucidchart, draw.io, or a similar tool is fine as long as the relationships are unambiguous.
Deliverables
• A mapping table (spreadsheet or CSV) that lists every column, its assigned dimension or fact that i gave like 2 facts and 7 dims, and a brief reasoning note where the choice might not be obvious.
• A clean dimensional model diagram that someone in reporting or engineering can pick up and implement immediately.
DIM_TRANSACTION_CHANNEL
DIM_PROMOTIONS
DIM_MARKET_CHANNEL
DIM_SKU_MASTER
DIM_CUSTOMER
DIM_DATE
DIM_PRODUCTS
FACT_SALES_ORDERS
FACT_DEMAND_ORDERS
The whole point is to crystallize the structure so I can extend reporting and analytics without second-guessing column purposes. If this sounds straightforward to you, I’m ready to share the schema and my predefined dimension/fact list right away.
Once the column-by-column mapping is finished, I also need a concise dimensional model diagram—think classic star schema—showing each of my dimensions linked to the central fact table. A simple PDF or image generated from Visio, Lucidchart, draw.io, or a similar tool is fine as long as the relationships are unambiguous.
Deliverables
• A mapping table (spreadsheet or CSV) that lists every column, its assigned dimension or fact that i gave like 2 facts and 7 dims, and a brief reasoning note where the choice might not be obvious.
• A clean dimensional model diagram that someone in reporting or engineering can pick up and implement immediately.
DIM_TRANSACTION_CHANNEL
DIM_PROMOTIONS
DIM_MARKET_CHANNEL
DIM_SKU_MASTER
DIM_CUSTOMER
DIM_DATE
DIM_PRODUCTS
FACT_SALES_ORDERS
FACT_DEMAND_ORDERS
The whole point is to crystallize the structure so I can extend reporting and analytics without second-guessing column purposes. If this sounds straightforward to you, I’m ready to share the schema and my predefined dimension/fact list right away.