My Portfolio

Search This Blog

Sales Dashboard for Year 2021-2022

on October 26, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Advanced Excel Course

Successfully completed an course on Advanced Excel with Amity University.

Linkedin Profile Link

My Linkedin Profile : - Linkedin Profile

SQL Project : Downloaded Pizza sales dataset from www.kaggle.com 1. Total revenue from pizzas sold SQL query used :- Select SUM(total_price) AS Total_revenue from Pizza_sales; 1. Total quantity of pizzas sold SQL Query used is:- Select SUM(quantity) AS Total_pizza_sold from Pizza_sales; 1. How many unique customer orders were made. SQL Query used is:- Select count(distinct order_id) As Unique_customers from Pizza_sales; 1. Find out the average order value SQL Query used is:- Select sum(total_price)/count(distinct order_id) as average_order_value from Pizza_sales ; 5. Find the daily trends of Sales of pizza SQL Query used is:- Select DATENAME(DW, order_date) as order_day, COUNT(DISTINCT order_id) as Total_oders from Pizza_sales; GROUP BY DATENAME(DW,order_date); 5. ...

Powered by Blogger

Theme images by Petrovich9

Sales Dashboard for Year 2021-2022

Comments

Post a Comment