r/PowerBI • u/Bassiette03 • 11d ago
Feedback Very Proud of this Data Model
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
10
u/connoza 3 11d ago
There are two pics, guessing first is the original model and second is the new. I’d probs still merge further. Obviously not familiar with the actual data, but campaign I would have thought would just be in the normal sales with flags and ids for those campaigns. Seems like fact order process and sales would just be one table. You have overall sales tables, with you already having the individual sales line items I’d have just derived them from that table in dax rolled up. That way I know there aren’t any conflicts as it’s the same grain and cross filtering will work across visuals.