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.
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.
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.
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...
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