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 ([login to view URL]), any resemblance to real individuals is coincidental
Python Task Goal:
Write a small python script that would check the [login to view URL] 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.
Hi,
I am a part time freelance Data Analyst with over 5 years of experience creating effective and illustrative visualizations for companies of all sizes.
As a in-house Data Analyst in start up in Ed-Tech analytics field, I have well rounded skill set including Data cleaning, Data Preprocessing and Data modelling.
I believe in creating engaging solutions and visualizations that resonate with your audience and are functional based on your unique needs. My background in security lends me
an edge in Data security that will help your brand to stand out in the crowd. Also I can work with data driven languages such as SQL and Python.
I have good command on Advanced Microsoft Excel and Google Sheets. I have the potential of delivering the project on time and will do it as per your terms and conditions.
I am also a tutor of excel. You can check my tutor profile on [login to view URL] by the name of "Vishal Bajaj" ([login to view URL]).
Skills:
Advanced Microsoft Excel (Highly Professional)
Data Cleaning and preprocessing
Comparative Analysis
Descriptive Analysis
Exploratory Analysis
Feature engineering
SQL
Linear Progression/Regression
Data Modelling
Complex and Interactive Tableau Dashboards
Thanks & Regards
Vishal Bajaj
₹1,500 INR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
3 pekerja bebas membida secara purata ₹3,850 INR untuk pekerjaan ini
Have read all the required tasks, and I can complete the same in Tableau, SQL and Python. I have 5 years of experience as a data analyst and this is my forte. Let's connect and discuss this further.