top of page

Data Visualization Using Power BI & Tableau | Sample Paper




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.




Commenti


bottom of page