Develop Excel Dashboards for data visualization
- or -
Post a project like this1559
$50
- Posted:
- Proposals: 8
- Remote
- #2662866
- Completed
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
Data analyst (IBM SPSS/ R/ RStudio/ Power BI) |Excel Expert (Dashboard/ Macro/ VBA/ Power pivot)
Brisbane
removal and changer pictures back ground Power point presentation with 3D models of pictures data entry and translating the documents
Gujranwala
19467141649658211818722109903282430348424535181523534702
Description
Experience Level: Entry
Hi all,
happy new year! I am seeking support to build a dashboard to visualize student results (4 student groups) using charts and graphs etc. I am attaching the report here. Each month, the report will be in the same format so we need a template for the dashboards.
Here are the charts that we need in detail:
1. Top Performers per Group: 4 bar charts (1 for each group number) displaying the top scoring students (top 25%) in each group with their score (use Column O)
2. Lowest Performers per Group: same as above but showing the lowest scoring students (lowest 25%) in each group
3. Median Performers per Group: This should be a bar or line chart (vertical) with the 50% of the students within the median range of scores. There should be a line cutting across showing the median performance score (median of Column O) against the students who rank in the middle
4. Ranked Competencies Per Group: 4 bar charts or other, showing the average scores of each competency (5) per group so we can see which are the top and lowest average scoring competencies in each group : Communication(Column E), Participation (Column G), Teamwork (Column I), Strategic Thinking (Column K), Results-Oriented (Column M)
5. Top Improvers per Group: This will show the top 5 students with biggest improvement from last month (Column Q)
happy new year! I am seeking support to build a dashboard to visualize student results (4 student groups) using charts and graphs etc. I am attaching the report here. Each month, the report will be in the same format so we need a template for the dashboards.
Here are the charts that we need in detail:
1. Top Performers per Group: 4 bar charts (1 for each group number) displaying the top scoring students (top 25%) in each group with their score (use Column O)
2. Lowest Performers per Group: same as above but showing the lowest scoring students (lowest 25%) in each group
3. Median Performers per Group: This should be a bar or line chart (vertical) with the 50% of the students within the median range of scores. There should be a line cutting across showing the median performance score (median of Column O) against the students who rank in the middle
4. Ranked Competencies Per Group: 4 bar charts or other, showing the average scores of each competency (5) per group so we can see which are the top and lowest average scoring competencies in each group : Communication(Column E), Participation (Column G), Teamwork (Column I), Strategic Thinking (Column K), Results-Oriented (Column M)
5. Top Improvers per Group: This will show the top 5 students with biggest improvement from last month (Column Q)
Faisal C.
100% (46)Projects Completed
42
Freelancers worked with
34
Projects awarded
32%
Last project
5 Feb 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
please share data
879560
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies