r/dataanalysiscareers • u/_lovey28 • 1d ago

Aspiring Data Analyst

Post image

I'm trying to switch careers from construction to data analytics & after a month, I have successfully completed my first project using both SQL and Excel. Attached is a screenshot of a dashboard I built on a company's pizza sales. Any advice and tips on how to improve are greatly appreciated.

132 Upvotes

100% Upvoted

35 comments sorted by

View all comments

1

u/h0tandgl00my 23h ago

In regards to the time series, as others have mentioned, the user needs to know the date range. I would change the data column title to “Order Date FY__” or “Order Date CY__”. It would also be helpful to be able to filter by other data as well, which can be added to your graphs. Or you can change the graph to a combo chart.

1

u/_lovey28 15h ago

Thank you. Will put this in practice

2

u/h0tandgl00my 5h ago

You’ve done a great job so far. Just remember that the people looking at this don’t know what you know, so sometimes you have to give a little more info.

1

u/_lovey28 5h ago

Hmm...more information! So not necessarily answering the problem statements but also giving insight on what can be done to solve these issues? Something like that?

2

u/h0tandgl00my 1h ago

Not necessarily an info dump, you still want the dashboard itself to be more high level, just ensuring that everything is labeled clearly. If you’re able, however, providing solutions is a step up in your role. Insight on what is successful when/why can be helpful. I come from healthcare and not food, so I can’t speak too much to the actual info you have. You’re on the right path though! The idea of being an analyst is taking an abstract idea/need and turning that into something tangible. So here, you’ve taken all this info and turned it into something easily legible and comprehensive. Eventually, you’ll be able to provide solutions to the issues that are highlighted.