Context :

This project serves as a practical application following the completion of a data analysis course, allowing for the demonstration and refinement of essential skills in the field.

The project encompasses key aspects of the data analysis process, including data preparation, data cleaning, analysis, and visualisation.

Project overview and objectives :

This project focuses on analysing detailed sales data from a store over a period of three years. The primary goal is to extract meaningful insights and generate informative summaries from the large database.

By leveraging data analysis techniques, the project aims to uncover patterns, trends, and potential opportunities for the store to improve its performance.

Ultimately, the project seeks to provide valuable insights and recommendations to support informed decision-making by the store’s management team.

Software used:

Excel

Data sources :

Link to source

Tasks performed :

  • Clarifying questions :
    1. Which Key Performance Indicators (KPIs) would provide the most valuable insights for the analysis?
    2. Can the data be easily segmented into different categories or locations for more targeted analysis?
    3. What factors should be taken into consideration when selecting data to include in the analysis, and what factors should be excluded to ensure the accuracy and relevance of the findings?

By answering these clarifying questions, the project can be more effectively focused and the analysis can be tailored to provide the most valuable and relevant insights for the store’s management team.

  • Cleaning data :

Detecting and removing any duplicate entries, resolving miscategorizations, and addressing any blank or null data points.

  • Building several pivot tables in different sheets
  • Building the dashboard.

The visualisation stage of the project will prioritise readability and clarity, avoiding overwhelming the audience with too much information at once.

To achieve this, the project will employ effective organisation techniques to present the data in a clear and digestible format, allowing for easy interpretation and analysis.

Additionally, the visualisations will incorporate the ability to filter and drill down into the data, providing a deeper understanding of the underlying trends and patterns.

Conclusion :

To effectively summarise and visualise the store’s sales data, a dashboard has been created in Excel. This dashboard provides a comprehensive and user-friendly view of the key metrics and insights derived from the analysis.

Through the use of graphs, charts, and other visual elements, the dashboard allows for easy interpretation and analysis of the store’s sales performance.

The dashboard serves as a valuable tool for the store’s management team, providing actionable insights to support data-driven decision-making.

Link to the project file