My Portfolio

Search This Blog

Linkedin Profile Link

on December 24, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

My Linkedin Profile :- Linkedin Profile

LinkedIn Profile

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Customer Risk analysis Dashboard

Power BI Project-FIFA World Cup data

FIFA world cup has been downloaded from https://github.com/ Page 1 shows total qualified teams in card, and used slicer of world cup year and world cup statistics using stacked column chart, count of world cups is shown using donut chart. Page 2 is showing stadium count (distinct) using card, used years of world cup as slicer, count of matches played per year is showed using stacked column chart, Runner-ups count shown using pie chart. Page 3 shows count of goals scored by home team year wise using clustered bar chat, used card to represent the number of world cups played till date, No of goals scored year-wise using stacked column chart, and third place count in world cup till date using pie chart. Page 4 shows number of times qualified for world cup using stacked column chart, attendance by country is shown using filled maps, fourth place in world cup count shown in tree map, no of goals against away team is shown in clustered bar chart. Page 5 shows the FIFA world cup an...

SQL Project

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

Linkedin Profile Link

My Linkedin Profile :- Linkedin Profile

Comments

Post a Comment