Food & Beverages Sales Analysis

        # Created Interactive dashboard in Power BI And Case Study using SQL query

Problem Overview

Welcome to the Food and Beverages Power BI Dashboard project! This repository contains a Power BI dashboard and SQL case study that provides insights into food and beverage data. It has 3 years of sales data across various store mediums, including online, distributor, and retail channels. This project aims to offer visualizations and analytics to help F&B management understand trends, make informed decisions, and improve operational efficiency.

Steps followed

• Step 1 : Load data into Power BI Desktop, dataset is a csv file.
• Step 2 : Open power query editor & in view tab under Data preview section, check "column distribution", "column quality" & "column profile" options.
• Step 3 : Also since by default, profile will be opened only for 1000 rows so you need to select "column profiling based on entire dataset".
• Step 4 : Perform data cleaning and profiling tasks.
• Step 5 : Checking for any null or blank data.
• Step 6 : Creating measure for total revenue, Average ticket price, and for orders using DAX function.
• Step 7 : Now Data visualizations, created various charts Bar charts, column charts, table, Matrix, Slicers and others.

Insights

    # Overall Revenue is $17.91 millions from 52.6K orders

    # Revenue By channels Retail with #8.7 millions comes first followed by
       Distributor $6.1 millions

    # Maximum Revenue received in month of September 

    # Product Preferences: Customers prefer wheat flour, followed by oils and yeast

    # Focused on online channel to increase revenue

    # Recommendation: Focus on the online channel to increase revenue.

    # Seasonal Insight: Revenue during the First quarter months is lower compared to 
      other times of the year.

Snapshot of dashboard