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

Please check the file

Please check the file

How does similarity is calculated if data is categorical in nature If the data is categorical in nature, similarity is often calculated using a measure known as the Jaccard similarity coefficient. This coefficient measures the similarity between two sets of categorical data by dividing the number of elements that are common…

1.What is a Neural Network? -- A neural network is a type of artificial intelligence model that is inspired by the structure and function of the human brain. It is a computational system that is composed of interconnected nodes or neurons that work together to process and analyze complex data. The neurons are organized…

What are the pros and cons of knn -- KNN, or k-nearest neighbors, is a machine learning algorithm that can be used for both classification and regression tasks. Here are some pros and cons of using KNN: Pros: Easy to implement: KNN is a simple algorithm that is easy to understand and implement. It is a good choice for…

1. Pros and cons of SVM -- Support Vector Machines (SVM) is a popular machine learning algorithm used for classification and regression tasks. The main advantages and disadvantages of SVM are: Pros: Effective in high-dimensional spaces: SVM performs well in high-dimensional spaces where the number of features is larger…

1)Calculate all 4 business moments using pen and paper for the below data set?  --        2)What is the significance of expected value when simple mean (Sum of all observations/number of observations) is already in place -- Expected value is a concept in probability theory that represents the average outcome of a random…

1.Perform Gradient Descent in Python with any loss function  -- attach a file below.   2.Difference between L1 & L2 Gradient descent method -- L1 and L2 are regularization techniques used in machine learning to prevent overfitting. They work by adding a penalty term to the loss function during training. L1 regularization…

1. Why there is a difference in the formula of variance for population and sample -- The formula for variance differs for population and sample data because the calculation of sample variance involves an additional step to account for the fact that the sample is only a subset of the population, and thus may not fully represent…

Uber Supply-Demand Gap Analysis - EDA   Aim: - This project aims to analyze data in detail on uber supply and demand gap analysis.   Introduction: We have a data about uber cab service. In it we have request time and drop time of cab. Customer pickup point, driver id, and status about cancel cab, no car available and trip…

Project 1 - COVID-19 Vaccinations Trend Analysis   Aim: - This project aims to analyze data in detail on vaccinated people and fully vaccinated by year and country.     Introduction: We have a data about vaccinations of people all around the world. In it we have country name, date of vaccination, type of vaccine use, data…

https://drive.google.com/drive/folders/1KRNI_X_2HMkp5zccZrrD2ugPtsLBYpaB?usp=sharing

B and h answer will be seen below the table.

Wonderfull dashboard project.

This project help me to make dshboard as article.

this project data has problem. In college_a_se and college_a_sj roll no field has text value not integer due to that while importing data I face lots of problem.   from question 6 to 11 I remove null values by using lenght(columnname) > 0 function because my one on one session mentor told me to use it.  

A very useful project analysis.

In this project I learn lot about real life industrial data how to clean and organize them and bring out useful insight from it.

Completed my project  Please check it carefully.