With the use of all week information and knowledge I have created this 2 projects. With the implementation of Python module I have gained more knowledge in coding , programing and data handling.  

Performed the company intends to offer some discount in premium for certain customers. Checked null values, missing values, outliers, mean , median and cleaning the data

This project consist of various query that we learnt during the SQL module..   Business model Customer to Customer (C2C) allows customers to do business with each other. This model is growing fast with e-commerce platforms where sellers may be required to pay some amount and buyer can buy it without paying anything.…

I have attached all the necessary python, excel, and SQL files for this Project.   Once a student is passed out from a Institute or College, he/she is known as Alumni of the Institute. Alumni’s career growth plays important role in Institute’s ranking and other networking activities. In this project, career…

All Question in the Project 1 are answered and attached in below file.   a. Do proper formatting of the data with using borders, font size and appropriate alignment of the content. b. Make summary of Products Sales by providing Total Sum of Sales Average of Sales Standard Deviation of Sales Variance of Sales Maximum…

Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies   Google Drive Link : Drive Link   You are working as Business Analyst in IJS Bank Limited. Currently your organization is working on Loan Applicant Clients…

Project 1 - Analyzing the Education trends in Tamilnadu     This dashboard empowers mission driven organizations to harness the power of data visualization for social change. Women are tracked away from science and mathematics throughout their education, limiting their training and options to go into these fields…

Project 2 - Gender Bias in Science and Technical field   This dashboard empowers mission driven organizations to harness the power of data visualization for social change. The data set talks about the literacy rates in Tamilnadu. It is distributed according to the cities and their ranks. It contains the population,…

All the questions are answered and all required files are attached at the end, here is just the brief and short answer for the question.     1. Explain the data. Check It is supervised or Unsupervised. Demonstrate? Ans. The data consists of insurance charges for various individuals and their demographic and lifestyle…

All the questions are answered and all required files are attached at the end, here is just the brief and short answer for the question.     1.Display the data of white wine and red wine 2.Get the size of both white wine and red wine. Ans. ------------- WHITE WINE -------------Number of rows : 4898Number of columns:…

Project 1 - COVID-19 Vaccinations Trend Analysis By Mohit Bhupendra Jambhale     Aim: The aim of this project is to analyse the trend of COVID-19 vaccinations and to determine the effectiveness of the vaccines based…

Project 2 - Supply and Demand Gap Analysis ( Uber Dataset ) By Mohit Bhupendra Jambhale   Aim: To identify the root cause(s) of the problem of cancellation of requests for taxis at Airport and City trips, and to recommend ways to improve the situation in order to improve the availability and reliability of the client's…