Consolidated table to data source to fact table mapping

Consolidated Table

Data Source in Tableau

Fact Table

sales_fact_consolidated

Sales

bi_factinvoiceitem

collections_fact_consolidated

Collections

bi_factcollections

campaigndiscount_fact_consolidated

Campaign_discount

bi_factcampaigndiscount

campaign_fact_consolidated

Campaigns

bi_factcampaignsummary

cashregiser_fact_consolidated

Cash Register

bi_factcashregister

appointment_fact_consolidated

Appointments

bi_factappointment

deleted_appointments_fact_consolidated

Deleted Appointments

bi_factdeletedappointment

package_user_fact_consolidated

Packages

bi_factpackageuserredemptions

employee_tips_ssg_consolidated

Employee Tips SSG

bi_factemployeetipsandssgdetails

empcommission_fact_consolidated

Employee Commission

bi_factemployeecommission

MultipleEmpComissions_Consolidated

MultipleEmpComissions_Consolidated

bi_factmultipleemployeecommission

emphourlypay_fact_consolidated

Employee Hourly Pay

bi_factemployeepay

empsalary_fact_consolidated

Employee Salary

bi_factemployeesalary

issues_fact_consolidated

Issues

bi_factIssues

loyaltypoints_fact_consolidated

Loyaltypoints

bi_factloyaltypoints, bi_factguesttierchanges

giftcards_fact_consolidated

GiftCards

bi_factgiftcards

opportunities_fact_consolidated

Opportunities

bi_factissues

pettycash_fact_consolidated

PettyCash

bi_factpettycashdetails

schedule_fact_consolidated

Employee Schedules

bi_factemployeeschedule

turnaway_fact_consolidated

Turnaways

bi_factturnaways

membership_fact_consolidated

Memberships

bi_dimusermembership

membership_fact_consolidated_date

Memberships Datewise

bi_dimusermembership

Membership_User_Fact_Consolidated

Membership Redemptions

Bi_FactMembershipUserRedemptions

inventory_fact_consolidated

Inventory

bi_factinventory

ER Diagrams

ER diagrams show how each fact table is associated to dimension tables.

ER Diagram: BI_FACTAPPOINTMENT

ER Diagram: BI_FACTCOLLECTIONS

ER Diagram: BI_FACTEMPLOYEESCHEDULE

ER Diagram: BI_FACTGIFTCARDS

ER Diagram: BI_FACTINVOICEITEM

ER Diagram: BI_FACTLOYALTYPOINTS and BI_FACTGUESTTIERCHANGES

ER Diagram: BI_FACTMEMBERSHIPUSERREDEMPTIONS

ER Diagram: BI_FACTMULTIPLEEMPLOYEECOMMISSION

ER Diagram: BI_FACTPACKAGEUSERREDEMPTIONS

ER Diagram: BI_FACTEMPLOYEETIPSANDSSGDETAILS

ER Diagram: BI_FACTAPPOINTMENTREDO

ER Diagram: BI_DIMUSERMEMBERSHIP

ER Diagram: BI_FACTCAMPAIGNSUMMARY

ER Diagram: BI_FACTCAMPAIGNDISCOUNT

ER Diagram: BI_FACTCASHREGISTER

ER Diagram: BI_FACTREGISTRATION

ER Diagram: BI_FACTTURNAWAYS

ER Diagram: BI_FACTDELETEDAPPOINTMENT

ER Diagram: BI_FACTINVENTORY

ER Diagram: BI_FACTISSUES

ER Diagram: BI_FACTPETTYCASHDETAILS

SQLs

SQL codes show how each consolidated table is generated from the fact and dimension tables.

Download the SQLs ZIP file

Did this answer your question?