Toy Kingdom - KPI Tracking & Analysis
PowerBI | KPI Cards | Star Schema | Date Hierarchy
Datasets available in the public domain
Context
Toy Kingdom is a leading retailer in the children's toy market, known for its wide range of products from educational games to the latest trending toys. With stores across the country, Toy Kingdom aims to bring joy and creativity to every child's life through high-quality, engaging toys.
The Dashboard
The KPI Dashboard is designed to provide a comprehensive overview of their key performance indicators, offering insights into their monthly sales, revenue, and profit margins. The dashboard allows filtering of data by store location, enabling a more focused analysis of their performance across different regions. Through the visual representation of orders by product category and revenue trends, the dashboard facilitates quick decision-making and strategic planning to drive business growth.
Implementing a Star Schema
The star schema is crucial for optimizing data relationships in this dashboard. This approach to data modeling leads to a more efficient database structure, improving the speed and performance of data retrieval. The key learning takeaway is the importance of a well-structured star schema in handling large datasets, ensuring that the dashboard remains responsive and user-friendly.
Building a Date Hierarchy
The date hierarchy organizes and displays the data by month and week effectively. The learning from this experience is understanding how date hierarchies can improve the structure and navigation of time-series data, making trends more accessible and intuitive for users.
DAX for Measured Columns
Working on calculated columns for Total Orders, Total Profit, and Total Revenue using DAX expressions, is a valuable learning experience in applying DAX to generate dynamic, real-time calculations, enhancing the analytical capabilities of the dashboard. The process deepened my understanding of DAX's flexibility and power in creating complex measures that drive meaningful insights.
Conclusion and Takeaway
This project was a comprehensive learning experience, solidifying my foundation in key areas of dashboard design. I am excited to dive deeper into these aspects in future projects and continue refining my skills. I invite you to connect if you have any comments or feedback on this work—I am always eager to learn and grow from constructive discussions.
PowerBI File
I invite you to view the dashboard in PowerBI by downloading the file on your machine. You should have PowerBI installed to view the dashboard.