BI Data Warehouse Rules

• Must have time dimension
• Must have empty entries for each field intended to be filtered against to allow for 0 sales to display correctly
• One entry per month can suffice unless daily reporting is required
• Must have a full log to show every time the sync job is run, and the totals of all data at the end to ensure no issues with data transport and synchronization across schedules