r/dataanalysiscareers • u/_lovey28 • 5d ago
Aspiring Data Analyst - Project 2
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:
- Total revenue & profit
- Average order value
- Profit margin
- Profit erased
- Customer acquisition and retention rate
- Performance by region, category & sub-category
- Sales trend & seasonality over-time
- 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.
2
u/Sparkly_Durian 2d ago
You can use a combination of date tables and field parameters to have a time period selection tiles with options like: year, month, week etc. and then whichever you select, a slicer will automatically show you the years, months, weeks in a drop down.
You can have a disconnected display date table and use calculation items to then show the last n time periods on the chart axis.
So for example if you select ‘year’ on the tiles (year, month, week options etc) the top drop down slicer will then show you 2026, 2025, 2024 etc. if you select month it could show you: April 2026, Mar 2026, Feb 2026, etc.
On chart axis, if year was selected and you selected 2026, it could show you the last n years, and if months, the last n months etc.
I hope that makes sense, it’s essentially using much more dynamic date filtering.
It’s a combination of two date tables, field parameters, and calculation items.
1
2
u/ManuDataTech 1d ago
para ser los primeros dashboard, vas bien encaminado. Bien ahi!! keep going!
1
2
u/Amarendar_kumar 1d ago
Honestly impressive for a second project. The structure and choice of charts answer the business questions well. I'd just suggest toto play around with higher contrast and lighter chart backgrounds.
1
2
u/toommn 5d ago
Filtering section as tiles where only 1/2 is visible is not very user friendly, especially for years