I am pleased to announce that I have completed my second dashboard challenge, this time for the FP20 Analytics Challenge. During this Challenge, we had to prepare a two-page report based on a dataset for the Mediterranean Camera Company, in which we included the following information:
Page 1: Executive overview of the Company Sales performance YTD report.
Page 2: Products Data Analysis and Time Intelligence report.
This project has been worked through Power Bi and Power Bi Query. While working on the dashboard, I tried to keep it as simple and easy to understand as possible, that is why most of the graphs in this project are dynamic ones. This is a good trick when having to present different information for the same category in a report. The selected Axis will change according to slicer associated making it easier for the user to navigate through the information.
🔍 Key insights:
By Product type:
Overall, units sold increased 51% by the end of the year, while net margins increased 37%.
⚡ Feel free to like and share this post if you find the dashboard interesting. And if you have any questions or feedback, please don't hesitate to reach out to me.