u/_lovey28

Hi everyone. Thanks a lot for the feedback on my previous post. Taking a few points into consideration, I was able to complete my second practice project, using Excel<SQL<PowerBI

Questions I tried to answer:

1. Total revenue & profit
2. Average order value
3. Profit margin
4. Profit erased
5. Customer acquisition and retention rate
6. Performance by region, category & sub-category
7. Sales trend & seasonality over-time
8. Revenue by customer segment.

I am self-teaching, and I've been studying for about 6 weeks now. Any advice and insights on how to better my work will be greatly appreciated.

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.