Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

1)Calculate all 4 business moments using pen and paper for the below data set? ans:     2. What is the significance of expected value when simple mean (Sum of all observations/number of observations) is already in place ans: The expected value is a more general concept than the simple mean and applies to…

1. Why there is a difference in the formula of variance for population and sample ans:  The formula for population variance is given as: σ^2 = Σ(x-μ)^2/N where σ^2 is the population variance, x is each data point in the population, μ is the population mean, and N is the total number of data…

Solutions for all the questions releted to project are attached with jupyter notebook file. 

Solutions for all the problems of insurance dataset are attached with jupyter notebook.

Supply and Demand Gap Analysis Submitted by – Shubham Sharma   TABLE OF CONTENT   AIM INTRODUCTION PROBLEM STATEMENT METHODOLOGY ANALYSIS (PREPARING SHEETS) INSIGHT RECOMMENDATION CONCLUSION               AIM The main aim of this project is to collect the data and analyze…

COVID-19 Vaccination Trend Analysis Submitted by – Shubham Sharma   TABLE OF CONTENT   AIM INTRODUCTION PROBLEM STATEMENT METHODOLOGY ANALYSIS (PREPARING SHEETS) INSIGHT RECOMMENDATION CONCLUSION     AIM Aim of this project is to analyse the trend of vaccinations for Covid-19 in the world. Main…

link is given below https://docs.google.com/spreadsheets/d/1-ykK9WakKfDsXxdUqJMiw3jfZORx63z4/edit?usp=share_link&ouid=103060763708639431583&rtpof=true&sd=true   Features of Dashboard Gender Ratio of Applicants Car Owner/ Non-Owner Ratio House Owner/ Non-Owner Ratio Client Income Type Client’s Level…

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 Sales Minimum Sales c. Make worksheet from the given Data for categorical representation…

Project-1 for machine learning algorithm is completed. In this project i worked on all algorithm of supervised learning and solve the problem which is given in dataset in machine learning. Here i attach my jupyter notebook report. 

Here are the screenshots for answers  5. Import first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel   13. Import the created views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V)…

Project-1 based on Business model Customer to Customer (C2C), this allows customers to do business with each other. In this project we learn about how to analyse users data and explore it according to business perspective. Here i submitted the file.

Completed my Project-2 which is based on EDA on Vehicle Insurance Customer Data. In this project we used python libraries like pandas, numpy for data analysis. Here i attach my Project report in jupyter notebook.

I completed my 1-module core and advance python programming. It was wonderful experiance for me to explore new things in this course. I completed both parts of project-1 and submitted here. 1A_English Dictionary App_project1.ipynb 1B_Library book Management Application_project1.ipynb dictionary1(converted into txt format)