$30 off During Our Annual Pro Sale. View details »

Data Visualization: Then and Now

Data Visualization: Then and Now

The deck first presented at SAP Inside Track Netherlands 2012
Updated for SAP Online Track 2020-05-30

Vitaliy Rudnytskiy

May 30, 2020
Tweet

More Decks by Vitaliy Rudnytskiy

Other Decks in Programming

Transcript

  1. INTERNAL Vitaliy Rudnytskiy, SAP 2020-05 Data Visualization: Then and Now

  2. 2 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Let me introduce myself - Віталій Рудницький aka Vitaliy Rudnytskiy, aka Witalij Rudnicki aka @Sygyzmundovych - SAP’s Developer Relations team - 12 years as a BI Technology Consultant - SAP Mentor 2010-2014 - Self-proclaimed King of Data Geeks J - Organizer of Wrocław’s SAP Community meetups and SIT - https://people.sap.com/vitaliy.rudnytskiy
  3. 4 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Ad break: SAP Inside Track Wrocław in September #sitWRO You are welcome!!
  4. Visualization: A bit of theory

  5. 6 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Picture Superiority Effect – Understanding a meaning „…is a simple shape in Euclidean geometry, which is the set of all points in a plane that are at a given distance from a given point; equivalently it is the curve traced out by a point that moves so that its distance from a given point is constant.” Source: Wikipedia @Sygyzmundovych
  6. 7 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Picture Superiority Effect – Understanding numbers I II III IV x y x y x y x y 10.0 8.04 10.0 9.14 10.0 7.46 8.0 6.58 8.0 6.95 8.0 8.14 8.0 6.77 8.0 5.76 13.0 7.58 13.0 8.74 13.0 12.74 8.0 7.71 9.0 8.81 9.0 8.77 9.0 7.11 8.0 8.84 11.0 8.33 11.0 9.26 11.0 7.81 8.0 8.47 14.0 9.96 14.0 8.10 14.0 8.84 8.0 7.04 6.0 7.24 6.0 6.13 6.0 6.08 8.0 5.25 4.0 4.26 4.0 3.10 4.0 5.39 19.0 12.50 12.0 10.84 12.0 9.13 12.0 8.15 8.0 5.56 7.0 4.82 7.0 7.26 7.0 6.42 8.0 7.91 5.0 5.68 5.0 4.74 5.0 5.73 8.0 6.89 Property Value Mean of x in each case 9 (exact) Sample variance of x in each case 11 (exact) Mean of y in each case 7.50 (to 2 decimal places) Sample variance of y in each case 4.122 or 4.127 (to 3 decimal places) Correlation between x and y in each case 0.816 (to 3 decimal places) Linear regression line in each case y = 3.00 + 0.500x (to 2 and 3 decimal places, respectively) http://en.wikipedia.org/wiki/Anscombe%27s_quartet @Sygyzmundovych
  7. 8 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Picture Superiority Effect – Understanding numbers @Sygyzmundovych
  8. 10 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Picture Superiority Effect - Remembering „Cool Infographics: Effective Communication with Data Visualization and Design” by Randy Krum, John Wiley & Sons © 2014 after: „Brain Rules: 12 Principles for Surviving and Thriving at Work, Home, and School” by John Medina, Pear Press © 2008 @Sygyzmundovych
  9. 12 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Picture Superiority Effect - Context
  10. Data Visualization: Shapes, locations and colors based on „SAP Lumira:

    Data Visualization Handbook” and other
  11. 19 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Human eye can distinguish betwen 7-10 milion colors How many can you? source: https://en.wikipedia.org/wiki/Color_vision#/media/File:1Mcolors.png @Sygyzmundovych
  12. 25 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ The Colour Wheel @Sygyzmundovych
  13. 26 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Useful tool: https://color.adobe.com/create/color-wheel @Sygyzmundovych
  14. 27 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Example: SAP à Brand Elements à Visual à Color Palette Our range of primary colors consists of SAP Gold, white, black and the supportive neutral colors (SAP light, medium and dark gray) We use our secondary color palette for graphs and tables, as well as for accent and highlighting purposes https://www.sapbrandtools.com/color-palette/#palette-details @Sygyzmundovych
  15. 30 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Visual Perception „SAP Lumira Data Visualization Handbook” http://getlumira.sapstore.com/data-visualization-handbook/ @Sygyzmundovych
  16. 31 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Chart Picker Source: http://www.extremepresentation.typepad.com/blog/2008/06/visualization-taxonomies.html @Sygyzmundovych “…precise representation of the true data value…”
  17. 34 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ https://info.sapdigital.com/The-Data-Visualization-Handbook_WC.html
  18. Data Visualization: A short history sources: https://de.wikipedia.org/wiki/Microsoft_Excel https://aresluna.org/attached/computerhistory/spreadsheets/screenshots

  19. 36 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ First known chart? Inclinations of the planetary orbits from monastery school’s textbook Time series (X-XI century) @Sygyzmundovych
  20. 40 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ First known column chart? A Frenchman Nicole Oresme used a column chart in a 14th century publication, "The Latitude of Forms", to plot velocity of a constantly accelerating object against time @Sygyzmundovych
  21. 42 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Klaer Lightende Spiegel der Verfkonst (1692) @Sygyzmundovych
  22. 47 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Introduction of Relational Graphics: neither Time nor Geo Apparently the first use of pie charts: The Statistical Breviary, by William Playfair, 1801 @Sygyzmundovych
  23. 49 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ The most famous geospatial chart @Sygyzmundovych Inspired by Picquet, Dr John Snow adopted the same principle to depict cholera deaths in Central London in 1854. source: http://en.wikipedia.org/wiki/Soho#Broad_Street_pump
  24. 50 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Nightingale’s Rose diagram (1858): "a true pioneer in graphical representation of statistics" "Diagram of the causes of mortality in the army in the East" by Florence Nightingale @Sygyzmundovych
  25. 51 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ International Year of the Nurse and Midwife #Nightingale2020 https://www.smithsonianmag.com/history/the-worlds- most-famous-nurse-florence-nightingale-180974155/
  26. 54 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Escaping 2D: Introduction of 3D Chart by Luigi Perozzo, from the Annali di Statistica, 1880 The population of Sweden from 1750-1875 by age groups printed in color in a way which enhances the perception of depth. @Sygyzmundovych
  27. 56 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ 1975-85: the Golden Age of statistical graphics @Sygyzmundovych
  28. 60 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ 1990s: explosion of computer-aided visualizations @Sygyzmundovych
  29. IBCS

  30. 62 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Since 2013 the Creative Commons IBCS® project has been governed by the newly-founded IBCS Association. The further development of the IBCS® Standards is an ongoing process, which is managed by the not-for-profit IBCS Association. The International Business Communication Standards (IBCS®) are practical proposals for the design of reports, presentations, dashboards and the diagrams and tables contained therein. This involves the conception of the content, the visual perception and the application of a semantic notation.
  31. 63 © 2015 SAP SE or an SAP affiliate company.

    All rights reserved. International Business Communication Standards are proposals for the conceptual and visual design of management reports and presentations. The purpose of IBCS is to foster the level of understanding in published material for business communication. Business communication meets the IBCS® Standards when it complies with the rules of the seven areas SAY: Convey a message UNIFY: Apply semantic notation CONDENSE: Increase information density CHECK: Ensure visual integrity EXPRESS: Choose proper visualization SIMPLIFY: Avoid clutter STRUCTURE: Organize content
  32. 64 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ SAP and IBCS
  33. 66 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ https://www.youtube.com/playlist?list=PLXlX1D9Frc3YjdJDi2cgsyor4PW5-8hAQ https://www.sapanalytics.cloud/guided_playlists/ibcs-international-business-communication-standards/ @Sygyzmundovych
  34. EDA: Exploratory Data Analysis

  35. 69 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Modelling (Schema) Data Collection Data Analysis Data Storytelling Data Collection Data Analysis Modelling Data Storytelling Traditional Data Analytics Exploratory Data Analysis @Sygyzmundovych
  36. Demo: https://github.com/SAP-samples/hana-ml-samples/tree/master/Python-API/usecase-examples/estimate-car-price

  37. 79 © 2015 SAP SE or an SAP affiliate company.

    All rights reserved. Data Storytelling…
  38. 96 INTERNAL © 2019 SAP SE or an SAP affiliate

    company. All rights reserved. ǀ Now the spotlight is on you! Do you want to leave your mark in the history of visualization???
  39. Vitaliy Rudnytskiy, SAP @Sygyzmundovych Thank you Dziękuję