basic project( tableau , sql , python )
Budget: ₹600 – ₹1,500 INR
Description -
Tableau Task Goal:
The client has requested a dashboard to provide an executive-level view of training data over a series of courses they offer to determine which courses are and are not working well with their students. Your job will be to build this dashboard in Tableau using client-provided data files, and provide a packaged workbook to deliver to the client.
To achieve this goal, you will need to successfully:
● Connect to the files and create the appropriate connections between them
● Create the appropriate sheets to answer the questions in the analysis section below
● Build a comprehensive client dashboard
Analysis:
Your dashboard will need to inform the client on which courses students are doing well in and which courses students are doing poorly in. What this dashboard (or, dashboards) looks like is up to you as long as it’s professional looking. In the schema above grades are stored as doubles and gradeMaxVal is the maximum grade the student could have received for the course. Column “pct” is the computed percent calculated as grade / gradeMaxVal. The user should be able to easily determine the following information, where “well” is defined as scores >= 80% and “poorly” is < 80%. Create a professional looking dashboard that makes it easy to see:
● How students are performing in the different subject areas
○ Percentage of students performing well vs percentage of students performing poorly per subject area
● How students are performing in the individual courses available
○ Percentage of students performing well vs percentage of students performing poorly per course
● A breakdown of grade results by subject by course (i.e. a drillable chart with results by subject as the first level and results by course as the second)
● A breakdown of grade results by year, by subject, by course (i.e. for each year we should be able to see performance information per subject and per course)
SQL Task Goal:
Imagine you have access to the above schema on a MySQL database. Provide the SQL for the following:
1. A query that determines the percentage of courses where students are doing well
2. A query that determines the percentage of subjects where students are doing poorly
3. A query that shows the average grade for each course
4. A query that shows the average grade for each subject
5. A query that determines if there are any courses that are not being completed (i.e. not represented in history)
*note - all data was generated by mockaroo (https://www.mockaroo.com/), any resemblance to real individuals is coincidental
Python Task Goal:
Write a small python script that would check the UserOnlineHistory.csv for the following data quality issues and output the results of each to separate csv files (typically using pandas dataframes):
● Records with no value in either of UserUid or OnlineCouseUid
● Records with either grade > gradeMaxVal or pct > 1
● Records with completed in the future (based on entered date/time) Note that these records do not exist in the data provided.
Tableau Task Goal:
The client has requested a dashboard to provide an executive-level view of training data over a series of courses they offer to determine which courses are and are not working well with their students. Your job will be to build this dashboard in Tableau using client-provided data files, and provide a packaged workbook to deliver to the client.
To achieve this goal, you will need to successfully:
● Connect to the files and create the appropriate connections between them
● Create the appropriate sheets to answer the questions in the analysis section below
● Build a comprehensive client dashboard
Analysis:
Your dashboard will need to inform the client on which courses students are doing well in and which courses students are doing poorly in. What this dashboard (or, dashboards) looks like is up to you as long as it’s professional looking. In the schema above grades are stored as doubles and gradeMaxVal is the maximum grade the student could have received for the course. Column “pct” is the computed percent calculated as grade / gradeMaxVal. The user should be able to easily determine the following information, where “well” is defined as scores >= 80% and “poorly” is < 80%. Create a professional looking dashboard that makes it easy to see:
● How students are performing in the different subject areas
○ Percentage of students performing well vs percentage of students performing poorly per subject area
● How students are performing in the individual courses available
○ Percentage of students performing well vs percentage of students performing poorly per course
● A breakdown of grade results by subject by course (i.e. a drillable chart with results by subject as the first level and results by course as the second)
● A breakdown of grade results by year, by subject, by course (i.e. for each year we should be able to see performance information per subject and per course)
SQL Task Goal:
Imagine you have access to the above schema on a MySQL database. Provide the SQL for the following:
1. A query that determines the percentage of courses where students are doing well
2. A query that determines the percentage of subjects where students are doing poorly
3. A query that shows the average grade for each course
4. A query that shows the average grade for each subject
5. A query that determines if there are any courses that are not being completed (i.e. not represented in history)
*note - all data was generated by mockaroo (https://www.mockaroo.com/), any resemblance to real individuals is coincidental
Python Task Goal:
Write a small python script that would check the UserOnlineHistory.csv for the following data quality issues and output the results of each to separate csv files (typically using pandas dataframes):
● Records with no value in either of UserUid or OnlineCouseUid
● Records with either grade > gradeMaxVal or pct > 1
● Records with completed in the future (based on entered date/time) Note that these records do not exist in the data provided.