Coffee Sales Dashboard

Back to Resume

Overview of the Dashboard Creation Process

  1. Data Collection:

    The data used in the Coffee Sales Dashboard was collected from various sources, including sales records, inventory levels, and customer feedback.

  2. Data Cleaning:

    The raw data was cleaned to remove any inconsistencies, errors, and duplicates. This step is crucial to ensure the accuracy of the dashboard.

  3. Data Analysis:

    Various Excel functions and pivot tables were used to analyze the data, identifying key trends, sales patterns, and areas for improvement.

  4. Dashboard Creation:

    The dashboard was created using Excel’s built-in charting tools, providing a visual representation of the analyzed data. The dashboard includes charts, graphs, and tables that offer insights into sales performance, product popularity, and revenue trends.

  5. Download the Dashboard:

    You can download the Coffee Sales Dashboard Excel file from the following link:

    Download Coffee Sales Dashboard