BlogFor BusinessTalk to a counsellor
CoursesIIT ProgramsPlacementsLog in
BlogFor Business
Talk to a counsellor
Challenge

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

VVenkatesh Shukla4 May 2023

https://drive.google.com/file/d/1ZuR_ysnzZfQqFH7PoqX747cBVIF3mFu3/view?usp=share_link

Gender Ratio of Applicants
Gender Count
F 202448
M 105059
XNA 4
GCD 1
Ratio 50612:105059:4
Car Owner/ Non-Owner Ratio
Non-Owner 202924
Car-Owner 104587
GCD 1
Ratio 202924:104587
Client’s Housing Type
Name Housing Type Numbers of Housing Type
Co-op apartment 1122
House / apartment 272868
Municipal apartment 11183
Office apartment 2617
Rented apartment 4881
With parents 14840
Total 307511
Client’s Level of Education
Name Education Numbers of Education Type
Academic degree 164
Higher education 74863
Incomplete higher 10277
Lower secondary 3816
Secondary / secondary special 218391
Grand Total

307511
Client’s Family Status
Name Family Status Numbers of Family Status
Civil marriage 29775
Married 196432
Separated 19770
Single / not married 45444
Unknown 2
Widow 16088
Grand Total 307511
Client Income Type
Name Income Type Numbers Of Incomes Types
Businessman 10
Commercial associate 71617
Maternity leave 5
Pensioner 55362
State servant 21703
Student 18
Unemployed 22
Working 158774
Grand Total

307511
Client’s Family Status
Name Family Status Numbers of Family Status
Civil marriage 29775
Married 196432
Separated 19770
Single / not married 45444
Unknown 2
Widow 16088
Grand Total 307511
Client’s Level of Education
Name Education Numbers of Education Type
Academic degree 164
Higher education 74863
Incomplete higher 10277
Lower secondary 3816
Secondary / secondary special 218391
Grand Total 307511
Client’s Housing Type
Name Housing Type Numbers of Housing Type
Co-op apartment 1122
House / apartment 272868
Municipal apartment 11183
Office apartment 2617
Rented apartment 4881
With parents 14840
Grand Total 307511
House Owner/ Non-Owner Ratio
Non-Owner 94199
House Owner 213312
GCD 1
Ratio 94199:213312

\

Client’s Occupation Type
Occupation Type Numbers of Occupation Type
Accountants 9813
Cleaning staff 4653
Cooking staff 5946
Core staff 27570
Drivers 18603
High skill tech staff 11380
HR staff 563
IT staff 526
Laborers 55186
Low-skill Laborers 2093
Managers 21371
Medicine staff 8537
Private service staff 2652
Realty agents 751
Sales staff 32102
Secretaries 1305
Security staff 6721
Waiters/barmen staff 1348
No Information 96391
Grand Total 307511
Income of female Credit amount
INR 31,588,428,942.41 INR 120,004,436,385.00
CODE_GENDER
F
Income of Male Credit amount
₹ 20,318,041,018.53 ₹ 64,201,050,310.50
CODE_GENDER
M
FLAG_DOCUMENT_2 FLAG_DOCUMENT_3 FLAG_DOCUMENT_4 FLAG_DOCUMENT_5 FLAG_DOCUMENT_6 FLAG_DOCUMENT_7 FLAG_DOCUMENT_8 FLAG_DOCUMENT_9 FLAG_DOCUMENT_10 FLAG_DOCUMENT_11 FLAG_DOCUMENT_12 FLAG_DOCUMENT_13 FLAG_DOCUMENT_14 FLAG_DOCUMENT_15 FLAG_DOCUMENT_16 FLAG_DOCUMENT_17 FLAG_DOCUMENT_18 FLAG_DOCUMENT_19 FLAG_DOCUMENT_20 FLAG_DOCUMENT_21
105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059 105059
CODE_GENDER
M
FLAG_DOCUMENT_2 FLAG_DOCUMENT_3 FLAG_DOCUMENT_4 FLAG_DOCUMENT_5 FLAG_DOCUMENT_6 FLAG_DOCUMENT_7 FLAG_DOCUMENT_8 FLAG_DOCUMENT_9 FLAG_DOCUMENT_10 FLAG_DOCUMENT_11 FLAG_DOCUMENT_12 FLAG_DOCUMENT_13 FLAG_DOCUMENT_14 FLAG_DOCUMENT_15 FLAG_DOCUMENT_16 FLAG_DOCUMENT_17 FLAG_DOCUMENT_18 FLAG_DOCUMENT_19 FLAG_DOCUMENT_20 FLAG_DOCUMENT_21
202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448 202448
CODE_GENDER
F

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.