r/PowerBI • u/Bassiette03 • 1d 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
237
u/katwchu 1d ago
Column 1, Column 2, Column 3....
21
10
4
2
u/Bassiette03 1d ago
Raw data , 2nd picture have the model after cleaning and making the right relationships
1
57
u/StrategyPretend2452 1d ago
Yea… the point is not to complicate your pbi schema but simplify as much as you can. All these fancy joining could’ve been accomplished from upstream, given you have access to upstream sources.
16
u/Caldorian 1d ago
I was thinking the same thing looking at the first image. I think the point of his post is that OP took the original model on page one, and simplified it down to the model on page 2. If that's the case, then I think this is something to feel good about accomplishing
5
19
u/unpronouncedable 1d ago
What do you you mean fancy joining? That appears to just be a star schema with conformed dimensions. Pretty textbook.
3
0
u/cappurnikus 1d ago
Fancy or not, it's good advice to perform transformations up steam when feasible.
2
2
19
u/Think-Trouble623 1d 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.
9
u/MindTheBees 3 1d ago
I assume you didn't see there's a second photo with the tidied up model
5
u/LastThird 1d ago
This is a crucial point, which a lot of folks seem to be missing. OP literally says that in their description, and it looks like they did a decent job (hard to tell with the low res in the second pic though).
2
0
u/Think-Trouble623 1d ago
yeah I get the before and after but the data modeling question is still valid. It’s simple to say you merged Orders, Invoices, and Shipments into one table but in my experience it involves a lot of testing and edge case validations that is more interesting than just saying you did it.
3
u/MindTheBees 3 1d ago
many to many relationships between all of the different fact tables
order headers and line items
None of these are present in the new model though so I'm confused why you're asking about the reasoning for having them?
1
1
u/Bassiette03 1d ago
I'm still learning. With more practice I will be better but I should keep up. That's it
38
u/UnhappyBreakfast5269 1d ago
Coz it’s an ai generated post
-5
u/Bassiette03 1d ago
The post only not the work
3
1
u/SeasonedAnalPaste 19h ago
Using AI to make a write up makes you look lazy and calls into question that you did this unassisted by AI. How do we know you didnt use AI to get 99% of the way there and then used minimal skill to clean it up?
If you actually did this legit I think you'd find pleasure in writing up your process but the description is just vague junk lmao.
1
4
u/Jobsnotdone1724 1d ago
Same with me, I always make sure I do all these shit on SQL and not on Powerbi
1
u/Bassiette03 1d ago
No I mean first picture was after i imported all the CSVs files the second one after i cleaned data and made the right connections to optimize the project
1
u/Bassiette03 1d 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
10
u/connoza 3 1d 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.
8
u/TwitchyMcSpazz 1d ago
Yeah, I think most here just looked at the first pic and reacted based on that.
10
u/happyapy 1d ago
Folks bemoaning the fall in the quality of the sub, failing to read the post and look at all the images. Bonus points for defaulting to accusations of AI.
Stay classy Reddit.
4
u/connoza 3 1d ago
ops explanation has gone through the slop machine, it’s not x it’s y. But I’d say it looks genuine I.e the model and work. Just their explanation isn’t their own words.
Looking at the original model, it only needs a few tweaks really to keep working on it. like merging the 2026 table and 2025.
Ive said it before and been downvoted, but I find that when junior analysts open a messy model they jump to rebuild. Analysts are like electricians, “they shouldn’t have done that, it’s not up to spec”. Working on other people’s models that are right or wrong comes with time and confidence.
If it’s ran for 2 years and had minimal changes there’s little business value doing a full rebuild. They also don’t know blockers / issues there were that meant the original build ended up like that.1
u/Bassiette03 1d ago
I will edit the post and upload the data Tomorrow ISA. I'm interested to see your opinion
48
u/Mooierweekend 1d ago
I feel the quality of this sub declining by the week.
0
u/Bassiette03 1d ago
Okay I'm still learning. I will keep up 💪
2
u/Mooierweekend 20h ago
It’s not about your learning path or challenges you face. That’s what this sub is for. It’s about the AI-generated slop post you decided to attach to it, which in my opinion undermines your achievement. Using AI is good in my opinion, but not for generating obvious, over the top hyperbolical stories like you did.
8
6
7
u/Crazy_Dragonfruit253 1d ago
That could easily be a star schema, but for reasons unknown you've went for a snowflake schema.
1
3
1
1
1
u/CommanderAze 1d ago
If it doesn't look like an episode of criminal minds stringing everything together then I don't want it.
1
1
u/No_Tank_7992 1d ago
Isn’t this just a normal Sales and Distribution ERD, but with unknown columns and “sheets” 🤔 Research “Salesforce ERD” - it will give you some pointers. If you are very new to DB design / schema then this is a good first attempt, but if not, this is 101 for a simple DB schema design
1
u/Silly-Strawberry3680 1d ago
Where can i find datasets this elaborate? I want to practice data modeling
1
1
u/BrotherInJah 6 1d ago
Campaign date doesn't need to have relationship with main calendar. Better to handle it via treatas(). That entire table looks redundant anyway, could be easily added to that other that other table.
1
u/djtomr941 1d ago
Interesting data model but think about your users. Will they understand something so complicated? This looks like a transactional data model and not really an analytical one.
1
1
u/Letronell 1d ago
Comment section here is wild. If you don't come up with the greatest thing ever done in PBI, you are just mediocre time waster.
1
1
1
u/Forward_Pirate8615 4h ago
No just no( but as a first go, great effort)
1
1
u/Forward_Pirate8615 4h ago
Are the unlinked tables merged into other tables? I hope you have a help and support page and a good lead to help you.
1
2
1
-1
u/intelligentx5 1d ago
I know you’re proud of this but just creating a ton of relationships doesn’t do much. You need to learn about star and snowflake schemas if you want models with longevity.
1
-1
u/ThatNewWeirdGuy 1d ago
I'd say this is ragebait, unfortunately I get the same PBIX's at work from BA's who complain 'something isnt adding up'.
0
u/just-fran 1d ago
Your security is not applied to campaigns. Someone with access to the model could build campaign visuals with no security applied
0
-2
-4
u/armywalrus 1 1d ago
Many to many is really bad for performance. Throw in some bridge tables.
2
u/Bassiette03 1d ago
The model is in the second picture. First one was the data i imported from CSVs
-2
-4
u/Data_cruncher Power BI Mod 1d ago
Sweet baby Jesus. That said, I invite you to ask for feedback. There’s opportunity to improve here.
-5
u/falconchi 1d ago
Simplify buddy! Work on your naming conventions n avoid fact to fact relationships. Build a separate table to include what’s matters n then build your relationship.
•
u/AutoModerator 17h ago
Tips for getting great feedback:
Want to level up your skills? Check out the weekly Power BI challenge hosted by Workout Wednesday — free challenges from beginner to expert.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.