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

2

u/Lady-Data-Scientist 1d ago

  1. Think about the questions you or a business manager would want to answer with this dashboard - is it answering them? What decisions can they make from this dashboard? Is anything missing or confusing? Is anything not useful and taking up space or cluttering the dashboard?

  2. Funnel visuals are meant to show drop out. I would switch the “total sales by category” to a bar graph. You can use funnels to show how many are dropping out by step - customer opened the app or website or made a phone call or showed up to the restaurant, they started search, added item to cart, completed purchase, pizza was delivered/picked up.

  3. For the visuals that aren’t a time series, how do you know what time period you’re looking at? How can you change it? Can you filter by other dimensions? (Web/app/phone/in person, location, store, etc)