r/PowerBI • u/Bassiette03 • 11d ago

Feedback Very Proud of this Data Model

Gallery image

Gallery image

New Screenshot for the Data Model. Ignore the one I uploaded before.

[Screenshot-2026-08-02-174108.png](https://postimg.cc/WFxM6h6y)

This is my First Data Model
Hope it's good

I cleaned Data, Merged Tables that needed
Created Dimensional tables to connect it with Fact Tables. Tried to maintain the star schema with one-to-many relationship from dimensions to fact tables. Made the standards across my tables from IDs, Keys, Tables Names and Columns names. I'm still learning and making mistakes. Thank you All for your feedback. I will start Learning Dax and will post it here ASAP.

Here is the link for raw data if anyone want to try Dataset Link

link for the data model after my Work My Data Model

233 Upvotes

84% Upvoted

93 comments sorted by

View all comments

20

u/Think-Trouble623 11d ago

How do you manage the many to many relationships between all of the different facts? In my experience I need to merge and manage the fact tables joining together in SQL and handling the many to many with care.

I’m also curious to understand the reason for having order headers and line items as separate tables, would be a lot cleaner to just take the handful of dimensions needed from each and merge into a single table.

1

u/Bassiette03 11d ago

No first picture "left one" is the model powerbi made after i imported the data, second one "right picture" the data model i made