Star schema - car accidents

[naciass]

To be honest I am completely new to Data Warehouse practices and as an assignment, I need to design a data warehouse using star-schema for car accidents in a country. At first, I have designed the FactTable as Accident with measures QtyCars and QtyCasulties with dimensions: "Driver", "Car", "Casualties", "Location", "WhatherConditions".. but then I have realized that they are many to many relationships for example: Accident 1: there is only one vehicle with two casualties. Acc 2: there are two vehicles, the first with one casualty the second with two. Acc 3: there were three vehicles. The first with three casualties, the second with two but, the third vehicle has no casualties. What should I change in the schema below?

[v-yuta-msft · Accepted solution]

Hi naciass,

Many to many relationship is now supported by power bi. You can use composite model in power bi, for details, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships.

Regards,

Jimmy Tao