For this project, I am creating PISA data visualization using Tableau that tells a story in a data set. This work is a reflection of the theory and practice of data visualization, such as visual encodings, design principles, and effective communication.
| Table of Contents |
|---|
| Summary 🔍📜 |
| Design 📐 |
| Feedback 🎙 |
| Link 🚞 |
| Resources 🍱 |
| License 🔖 |
PISA is a worldwide study developed by the Organization for Economic Co-operation and Development (OECD) which examines the skills of 15-year-old school students around the world.
The study assesses students’ mathematics, science, and reading skills and contains a wealth of information on students’ background, their school and the organisation of education systems.
The current work selectively focuses on the impact of some key factors on scholastic performance, including countries, gender, apparatus number, programming skill, to illustrate the wide range of possible analysis and visualisation tools that can be used with PISA and value will be placed on participants that are able to creatively use the strengths of the PISA dataset to submit creative analyses within one of the two areas identified.
According to the visualization, high scholastic performance was seen in East Asia, North America, Europe and South Pacific. Moreover, apparatus seems to play a positive role in scholastic performance, whereas programming skills are trivial in terms of scholastic median score. Both apparatus and programming suggest positive relationships correlated with wealth.
(Image is adapted from a copyright-free website: https://www.pexels.com/royalty-free-images/.)
- Firstly, with the help of geographic function in Tableau, scholastic performance was able to be presented in the world map;
- Secondly, table with numbers and lines were introduced to examine and highlighted the specific parameters, such as apparatus number, programming skill, for their effects on scholastic performance;
- Finally, bar charts were applied to further examine the relationship between either apparatus or programming skills with wealth;
- The user could interact with the map, numbers and lines from the chart.
1. For the relationship between programming skill and scholastic performance, line chart gives concise and better visualization than bar chart.
2. Secondly, more investigation should be performed, such that the relationship either apparatus or programming skills with wealth.
3. Add a story title at the top. On your first slide, the way the map cuts the Americas in half feels awkward. If you drag the map to the side to put the split in the middle of the Atlantic or Pacific, I think it visually feels a lot better. Also, the red and green you're using won't be distinguishable to a RG color blind person, so consider another color scheme. On slide two, edit the labels to say "Cellular Phone" or "Computers" instead of "cellular_phone_number" or "computers_number". It will look cleaner that way. On the programming skills slide, I only see a blue line, and if I change which skill level I'm looking at in the drop down menu, it only shows one color at a time. Can you get all the colored lines on the graphs at once to highlight the point that there's no difference between the levels and score? Also, consider rotating your graph to put the independent variable (country) on the X-axis and the dependent variable (score) on the Y-axis. On the last two slides, I'm not sure what the unit on wealth is. What does zero represent? What does a -2 wealth score mean?
https://onlinehelp.tableau.com/current/pro/desktop/en-us/publish_workbooks_tableaupublic.html
https://stackoverflow.com/questions/38426806/tableau-is-reading-my-dates-wrong
http://mi2.mini.pw.edu.pl:8080/SmarterPoland/PISAcontest/
http://sebastianraschka.com/Articles/2014_ipython_internal_links.html
https://stackoverflow.com/questions/21892570/ipython-notebook-align-table-to-the-left-of-cell
https://stackoverflow.com/questions/48655801/tables-in-markdown-in-jupyter
https://stackoverflow.com/questions/10628262/inserting-image-into-ipython-notebook-markdown
https://community.tableau.com/thread/195793
http://journals.sagepub.com/doi/full/10.2466/03.CP.4.1
https://www.iea.nl/sites/default/files/irc/IRC2010_Carstens_Hastedt.pdf
https://stackoverflow.com/questions/30996289/utf8-codec-cant-decode-byte-0xf3
