Dataset Link:
Requirement Details:
-- Upload the datasets provided to the Data Visualization Tool.
-- Please read below 2 points before proceeding with the questions
1. For a user to be a candidate his "user_type" in "users" table should be = 0.
2. A candidate is said to have "100% profile" if his "basic_profile_completion" = 34 AND
"education_profile_completion" = 33 AND "work_profile_completion" = 33
-- Questions:
1.
i. In a table display Number of candidates as per nationality.
Relationship : "country_id" of "countries" table = "nationality" of "users" table
ii. In a table display Number of candidates as per the country residing in.
Relationship :
"country_id" of "countries" table = "country_living_in_id" of "users" table
2. In a single stacked bar graph display
i. Number of candidate who signed up each day
ii. Number of candidate who completed "100% profile" on the same day.
(i.e display 100% profile of those candidate who signed up today and finished his profile today itself)
3. In a single stacked bar graph display
i. cummulative trend of number of candidates
ii. cummulative trend of number of candidate with "100% profile".
4. Candidates based on profession.
Relationship :
"role_id" of "job_role" table = "job_id" of "user_work_experience" table
"user_id" of "user_work_experience" table = "user_id" of "users" table
5. Put all the charts created abpve into a dashboard named as "Candidate Dashboard" and share a public link to the dashboard.