This Power BI dashboard is designed to assist 24Seven, a rapidly expanding convenience store chain, in identifying the optimal locations for new stores across Canada. By integrating diverse datasets including sales, customer demographics, traffic patterns, and regional climate data, the dashboard calculates an "Expansion Score" to guide strategic expansion decisions. For further details, refer to
For Dashboard Snippets refer to the
- Expansion Score Calculation: A unique metric that evaluates potential store locations based on sales, market saturation, and demographics.
- Sales Trends & Forecasts: Visualizes historical sales data and predicts future trends to identify growth opportunities.
- Demographic Insights: Analyzes customer demographics for targeted marketing and product placement.
- Traffic and Climate Analysis: Considers traffic flow data and regional climate impact on store performance.
- Interactive Visualizations: Offers dynamic, user-friendly visualizations for in-depth data exploration.
- Historical Sales Data: Transactions, revenue, and product performance metrics.
- Customer Demographics: Age, gender, income level, and purchasing habits.
- Product Categories: Inventory assortments and category performance.
- Store Locations: Current stores and geographical market analysis.
- Regional Climate Data: Impact of weather conditions on sales.
- Traffic Flow Information: Pedestrian and vehicle traffic patterns.
- Census Demographic Data: Broader demographic trends and economic indicators.
- Economic Indicators: GDP, unemployment rates, and retail sector performance.
To use this dashboard, ensure you have access to Power BI Desktop or Power BI Service. Import the .pbix file into your Power BI environment to start exploring the data.
- Navigate through different tabs to explore various analytics and insights.
- Use filters to drill down into specific data points, such as geographical regions or product categories.
- The dashboard is designed for interactive use; hover over visualizations to get detailed information.
We welcome contributions from 24Seven team members and external collaborators. If you have suggestions for improvements or new features, please open an issue or pull request.
This project is licensed under the MIT License - see the LICENSE file for details.
This project was a part of a master's program at McGill. Special thanks to the organizers and contributors who provided the data, tools, and resources necessary to make this challenge a stimulating and enriching experience..