CODEWITHSUNDEEP
database-designpowerbischemadata-modeling
JoshB
JoshB

Reputation: 11

A schema with 10 Fact Tables and 1 Dimension Table

Is it normal / best practice to have multiple fact tables but only minimal dimension table(s).

I am new to data modelling and trying to create the best / most efficient data model and it always seems as if I have way to many fact tables.

For context right now I am trying to measures multiple areas of my supply base and have these individual extracts to support this;

Invoices (total paid to supplier) Demand (Supplier future needs) Delivery Performance (Supplier on time deliveries) Ethics (Supplier Ethical incidents) Cyber (Supplier cyber attacks) ..........

and about 5 others.

The only fact table I have is of my supplier base.. thus becoming my only Dimension table...

is this normal? should I be looking to extract this data differently?

Building the above all joining to the dimension table..

Upvotes: -1

Views: 83

Answers (1)

NickW
NickW

Reputation: 9798

how your data is structured in your source system(s) is irrelevant to how you design your dimensional model

  1. Define your measures
  2. Define the grain for each measure
  3. Where measures have the same grain they can, but don’t have to, go in the same fact table
  4. For each measure, define how you want to be able to filter and aggregate them. This gives you your dimensions

Upvotes: 0

Related Questions