Coles is a leading supermarket, retail, and customer service brand in Australia. It boasts over 800 outlets nationwide and has a 27% market share. The Coles dataset obtained from Kaggle provides a representative sample of data that can be analysed and used to make informed business decisions.
This dashboard was produced using Excel pivotable, leveraging the capabilities of Excel pivot chart, functions, and calculated fields to gain deep insights and conduct a comprehensive analysis of the Coles dataset, paving the way for informed decision-making.
Fields Names and Meanings
- Coles_StoreID – is a unique ID that uniquely identifies each store.
- Store_Location – provides information on the store’s location in different states.
- Customer_Count – is the average customer count accounted for in the store.
- Staff_Count – is the number of employees who work at the stores.
- Store_Area – is the store’s size, expressed in square meters.
- Expec_Revenue – is the Expected Revenue in $M a store is supposed to generate.
- Gross_Sale – is the Gross Sale in $M a store has generated.
- Sales_Cost – is the cost incurred in $M after the Sale has occurred.
- Targeted_Quarter – indicates the quarter within a fiscal year to which the sales data corresponds.
- Coles_Forecast – provides details about whether the store’s sales align with the expected revenue, specifically whether the net sales (computed as Gross_Sale – Sales_Cost) meet the expected goal. The forecasted values are determined based on predefined conditions. If the net sales equal or exceed the Expected Revenue, they are categorized as “On Target.” If they fall short of the Expected Revenue, they are categorized as “Below Target”.
This dataset offers valuable insights for Coles and its analysts to evaluate the financial health, valuation, and performance of each store. These metrics enable the analysis and comparison of various stores, supporting informed investment decisions based on performance.
Basic Insight
- A substantial number of Coles stores are performing below there expected target.
- There are slight drop in expected revenue, total sales, cost incurred, and profits from Q1 to Q2.
- All Coles stores are profitable however the margins for ACT, NT, and TAS are marginal, further analysis may be required to understand why.