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

UBER Supply and Demand Gap Analysis Aim The aim of this is project is to identify and analyze the gap in supply and demand of uber cabs having two pickup points namely airport and city from the dataset downloaded from kaggle. Introduction Supply and demand gap analysis is done by every company to know the reasons for the…

Covid – 19 Vaccination Trend Analysis   Aim This project aims to find out the trend of the vaccinations around the world for the prevention of the Covid 19 pandemic and how much has been achieved so far. Introduction The COVID 19 pandemic caused due to the Corona virus devastated the world by causing several…

https://drive.google.com/drive/folders/1irzWUpl4zGE18aY33VOqcS_MC7pLL1Cf?usp=share_link DATA SUMMARY FOR FEMALE LOAN APPLICANTS FOR INCOME AND LOAN AMOUNTS     AMOUNT_INCOME_TOTAL 31,58,84,28,942.41 AMOUNT_CREDIT_TOTAL 1,20,00,44,36,385.00 CASH_LOANS_TOTAL 1,13,90,95,01,385.00 REVOLVING_LOANS_TOTAL 6,09,49,35,000.00…

1) Dictionary Application import json print('Welcome to the Dictionary App')print('Please select your choice')print('1. Add a word')print('2. Find the meaning')print('3. Update the word')print('4. Exit') f = open('words.txt','w')dict_words = {}json.dump(dict_words,f)f.close() while True: n = int(input('Enter the Choice:'))…

#1) Create new schema as alumniCREATE DATABASE alumni; #2) Import all .csv files into MySQL-- Imported # 3) Run SQL command to see the structure of six tables USE 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; # 4) Display first 1000 rows of tables #…

a) Table formatted    b) c) d) ABC ribbon created in the home tab containing formatting commands e)   f) g) Dates cleaned, formated and changed h) i) Two new columns added j) Highlighted

Tableau Public Link - https://public.tableau.com/app/profile/harsha.g.s/viz/Project2-AnalyzingtheEducationtrendinTamilnadu/Dashboard1#1    

* Women are deprived of the opportunities that men get mainly because of the mindset of the people that the particular roles are more suited to men than women. * Women have to take the responsibilites of the household chores inspite of going to a job where as men are free from that and are encouraged to focus on their…

# 1) Create new schema as ecommerce# Ans) schema can be created using navigator as shown in attachment or# by using the below query CREATE DATABASE ecommerce; # 2) Import .csv file users_data into MySQL# (right click on ecommerce schema -> Table Data import Wizard -># Give path of the file -> Next -> choose…

import numpy as npimport pandas as pd customer_details = pd.read_csv('customer_details.csv')customer_policy_details = pd.read_csv('customer_policy_details.csv') # 1. Adding Column names to both data sets """i. Column Name for customer details table:customer_id, Gender, age, driving licence present, region code, previously…