Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

1) 2) The white wine data size is more compared to red wine white wine --> 4899 rows red wine    -->  1600 rows 3) No null values Both wines data is checked note: a NULL means that there is no value, we're looking at a blank/empty cell, and 0 means the value itself is 0. So 0 is not considered…

1) The data is medical insurance charges, with each row representing a single patient and various features about that patient. The features included in this dataset are: *Age (in years) *Sex (male or female) *Body Mass Index (BMI) *Number of children *Smoking status (yes or no) *Region (northeast, northwest, southeast,…

Aim: The aim of this project is to collect and analyse the data in detail of the Pickup point of the Airport and City Request id in Uber Request Data.  Introduction: Uber provides the 2016 data. By using this data find out the demand and supply Analysis gap of the cab. The main objective of this project is to analyse…

    Aim: The aim of this project is to analyse the data in detail on vaccinated people and fully vaccinated people by country in 2021-2022 Introduction: Since the start of the COVID-19 outbreak, WHO has worked with countries and areas in Different regions on public health measures to slow or stop the spread of…

1

https://public.tableau.com/views/project1_16802645678590/Dashboard2?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link Mens are getting more opportunities when compared to womens because of the peoples mindset. The safety of the womens also plays a mojor role in not getting the opportunities

VBA Code to check Spelling Mistakes Public Sub SpellingCheck()Dim Cell As RangeFor Each Cell In ActiveSheet.UsedRangeIf Not Application.CheckSpelling(Word:=Cell.Text) ThenCell.StyleEnd IfNext Cell End Sub     VBA Code to Convert selected data into pdf Public Sub SavetoPDF()Dim A As RangeDim B As StringDim C As…

1)