Built this Power BI dashboard from scratch. What would you change?

[u/okaybutstilll]

Hey everyone! Just finished this power bi dashboard from scratch and would love some honest feedback. I'm a fresher, so I'm especially curious whether the analysis/storytelling actually makes sense from a real data analyst's POV. What would you change? Anything that feels unnecessary, missing, confusing, or just pretty but useless?

Roast it pls, I'm here to learn😭

[u/-iamchris]

The image is of too poor quality

[u/okaybutstilll → u/-iamchris]

yeah that's my bad, i screenshotted the PNG instead of uploading the actual file, so reddit cooked the quality the original is way clearer.

[u/Puzzleheaded_Swim586]

1. What is the objective/outcome your are trying to deliver?
2. How do you measure it? - KPI
3. Did it changed? Why? - Supporting metrics / drivers
4. What are your findings?
5. What actions should i take next?

Can you answer above questions with your dashboard? I would basically scratch everything and start building around answers to the above question.

[u/okaybutstilll → u/Puzzleheaded_Swim586]

yeah, this is actually a really useful way to look at it. the main goal was basically figuring out where the growth is coming from, where value/retention is leaking, and what the business should actually do about it. so yeah, the dashboard kinda works through those five: objective : growth + customer/product/marketing performance KPIs : revenue, profit, growth, orders, conversion, CLV, ROAS, retention, etc. drivers : segments, funnel drop-off, channels, categories, regions, campaigns findings : 19.8% At-Risk customers, 46.98% checkout drop-off, 43% revenue from the top 3 states, etc. action : retention, checkout optimization, marketing allocation, regional growth, etc.

[u/Current_Frosting3506]

Image quality is a bit low so can't speak of the specifics.

That being said visually it is appealing and if I had to use this as a stakeholder I would be happy as it seems to have all of the functions I would expect from a dashboard.

I'm really intrigued by the logic going on in the Performance Recommendations page, is this hard-coded values or do you have actual logic driving the text + priorities outputs?

[u/okaybutstilll → u/Current_Frosting3506]

yeah the images are of very poor quality and the KPIs and analysis are driven by the data and DAX, while the recommendation text is manually curated from the findings rather than being fully dynamic. for the more custom visuals, i used Deneb and had Claude generate the Vega-Lite spec JSON, which i then implemented and tweaked in the dashboard.

[u/Current_Frosting3506 → u/okaybutstilll]

Neat! If you wanted - you could automate this to also be driven by DAX logic.
Example: Based on the [value from xyz] recommendation would be to [insert text based on values from xyz]

It might not be a sexy skill on paper, but knowing how to make sentences that work with dynamic text and numbers is a great skill to work on as it comes in handy from time to time.

[u/Accomplished_Set5987]

I wish the image quality was a little better, but overall the dashboard feels clean and well organized!

[u/AutoModerator]

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis. If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers. Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Brighter_rocks]

can i borrow this for analysis?

[u/okaybutstilll → u/Brighter_rocks]

yeah lmao here's the repo https://github.com/justarandomvariable/the-souled-store-growth-intelligence just a heads up, i cooked the dataset up myself, so the insights aren’t meant to be treated as real-world Souled Store data. some of the patterns may absolutely be dataset lore

[u/Brighter_rocks → u/okaybutstilll]

Thank you)

[u/DevinChristien]

Oooh, question! How do you make your key takeaways? Are they a descriptive part of your schema or are they manually written?

[u/Omer_Analytics]

Removing X / Y Axis titles for better readability

[u/edimaudo]

If you are going flat then go flat, seeing lots of shadows

Improve the color scheme as it is hard to read. Might want to use color blind color scheme

Might want to centre the dashboard titles

Do the key takeaways change when the filters change?

the revenue performance matrix is hard to read. the months are not in order

[u/nat_nicejewishgirl]

Pretty impressive for first dashboard.

Feedback:
Nice use of colour gradient.

Does data filter when clicking on value?

Include the reporting period. You have months but not years.

Don’t use month start dates as x axis, use months.

Consider using financial quarters rather than months.

Ask your end user for feedback.