Loading
Notes
Study Reminders
Support
Text Version

Data Visualization in Excel - Lesson Summary

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

Visual Perception
Visual perception is the interpretation of processed information we receive from the visual world.
• Our brains are receptive to a certain types of patterns.
• „Connecting the dots“ refers to our cognitive ability to link disparate information.
• Visualization can help us gain a good understanding of the data.

Gestalt Laws of Grouping
• Similarity
• Proximity
• Closure
• Common Grouping
• Continuation

Preattentive Attributes
• Colour: Hue / Intensity
• Spatial: Lenght / Width
• Orientation: Shape / Size /Curvature
Data visualization
• Data visualization is used to examine and investigate data.
• Data visualization allows us to uncover an underlying story that we may not have been aware of.
• As we discover new facts or test different outcomes, the story becomes more dynamic.
• The finding and analysis are the key objectives here.

Infographics
• Infographics help us tell a story that already exists.
• Infographics don't always follow best practice
• The primary goal of infographics is narration.

Types of Infographics
• Progress Bar
• Donut Chart
• Waffle Chart
• Camera Tool