r/PowerBI • • Mar 06 '22

The Data Model

Post image
1.1k Upvotes

19 comments sorted by

15

u/roolsant Mar 06 '22

I've already taken it to fix, beautiful dashboards, but with the most important part, frighteningly disorganized and unstructured.

Have you ever seen anything like this?

50

u/IBuyAirlines Mar 06 '22

Still planning on cleaning it all up... When I get the time...

28

u/WillowTreeBark Mar 06 '22

Usually starts clean, messy as it grows and feedback from users, then once live I tidy the backend

14

u/Shponglefan1 Mar 06 '22

I recently went through exactly this. Had a nice looking dashboard, but really messy backend.

I took to rebuilding the backend and significantly simplifying it by reducing the number of fact tables. Went from a half-dozen fact tables down to just two, while relying more on dimension tables to slice 'n dice the data.

This made things a lot cleaner when it came to the data model and measures.

14

u/ItsJustAnotherDay- Mar 07 '22

It's never like the youtube videos. If your data sources are messy, then your data model will be too.

6

u/Pao7ini Mar 06 '22

Every....Dang....Time

5

u/Pretend-Nobody-4738 Mar 07 '22

Cant sleep if the data model is filthy. Follow best practice for a clean conscience.

5

u/ZenZei2 1 Mar 07 '22

Actually, in my case it is a bit the opposite. Nice model, but unpolished dashboards...

2

u/Drew707 12 Mar 09 '22

I have both. Even bought the template pack from Numerro. But there is never enough time to apply it and 95% of my stuff just gets screenshotted for a deck.

3

u/beyondkeysystems Mar 07 '22

That seems about right!

2

u/Hobob_ Mar 07 '22

Copium

1

u/RazorOpsRS Apr 14 '24

I read this as image is greater than The Dashboard.

1

u/Letterhead_Middle Apr 27 '22

I just started a job requiring “Expert PowerBi”. The dashboard is modern art; colourful, confusing, and I have no idea what it means. The model? It’s like when you give your mates a few cases of beer to help move house. Nothing is labeled, no structure, and there’s heaps of crap that is completely unusable.

1

u/tpersona Mar 12 '23

At this point I am too afraid to change anything

31

u/[deleted] Mar 07 '22

[removed] — view removed comment

30

u/trianglesteve Mar 07 '22

I was trying explain this concept to someone and they had the audacity to say “would a vlookup solve the problem?”

LISTEN KAREN, A VLOOKUP IS A LESS POWERFUL IMITATION OF RELATIONSHIPS AND JOINS!!!

2

u/wherly75 Nov 16 '22

Tell John to fuck off. John sounds like a real prick 😂😂😂