** ALL THE ANSWERS ARE PROVIDED IN THE EXCEL WORKBOOK**

https://drive.google.com/file/d/1mXfJ-esmyvk1w1Vp77E_1yJApnJd9eqh/view?usp=share_link  

Aim: This project aims to analyse data in detail on COVID-19 Vaccinations based on countries, Date, Count, Vaccine names and source. Introduction: The main objective of this project is to analyse the data on, COVID-19 Vaccinations. Through the Analysis of data, we can find out some important insights. We can find out how…

                             CAB SERVICE - SUPPLY AND DEMAND GAP ANALYSIS  Table of Contents Aim Introduction Problem statement Methodology Analysis (Data sheets pertaining to it) Insights Recommendations Conclusion Aim: This project aims to…

-- 1create database ecommerce; -- 2use ecommerce;select count(*) from users_data; -- 3describe users_data; -- 4select * from users_data limit 100; -- 5select count(distinct country ) country_count, count( distinct language) language_count from users_data; Country = 200 Language = 5 -- 6select sum(socialNbFollowers) from…

-- 1create database alumni;-- 3use alumni;desc college_a_hs;desc college_a_se;desc college_a_sj;desc college_b_hs;desc college_b_se;desc college_b_sj;-- 6create or replace view college_a_hs_v as select * from college_a_hs where RollNo is not null and LastUpdate is not null and Name is not null and FatherName is not null…

https://public.tableau.com/views/WomeninSTEMfields_16750849192790/Dashboard12?:language=en-US&:display_count=n&:origin=viz_share_link                                                  

https://public.tableau.com/views/TableauProject2_16756152064820/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link

Objective: A company has customer data that contains 8 columns of customer details and another table having name customer_policy data contains the policy details of the customer.  The company intends to offer some discount in premium for certain customers. To do that they ask their Data scientist team to get some…