Creating facts and dimensions from raw data

TENDER

A fact represents an event that is placed in context by its dimensions. Events may contain measures which are values that describe the magnitude of the event.

Take Traffic Count as an example. The event is a consumer entering a store. The context of that event is the time it happened and the store where it occurred. In an atomic fact table there would be a row for every such event. Traffic Count is an aggregation of multiple events, in this case a summary, of the total number of times for a particular day. Count is the measure and date and store are the dimensions.

So I'm thinking Item , online , purchase order entry will be my fact tables. So how can I connect these three and how can I add Traffic count to my fact table.Can you just tell me what fields go into my fact tables for my better understanding?
Thanks

Here is a high level break down of your Dims and Fact. You have to familiarize yourself with dimensional modeling techniques to understand this… you need alot of reading on DM :-)

-- Here is a list of your Dims:
Store
Supplier
Customer
Date
Tender
Combine Item, Department, and category to create a 1 Dim.

-- Create a Transaction Fact table.

Fact table will have Ids from above Dims.

Combine PurchaseOrder, Purchase Order Entry, Transaction, Transaction Entry
Tender Entry , Online data into this Fact table.

Once you have that fact table then you can do this:
Select store_id, date, count(*) AS Traffic_count
From Fact
Group by store_id, date

Thanks

Another name for “Item” is product. You have to store cost and quantity in Item dim because they are attributes of it. For example 1 stick of gum costs 99 cents, but 1 pack of gum costs $ 5.00.

You also need price and quantity in the Fact table to represent how much of it was bought by a customer. For example 1 stick of gum is on sale and it costs 99 cents but selling for 50 cents . Now a customer bought 2 gums (quantity) for a price of $ 1.00.

Down the road you have to deal how to represent data for item on sale or on discount price, so please keep reading Kimball book to find answers.