AST - Visual Data Presentation Lesson

BusTech_LessonTopBanner.png Visual Data Presentation

Introduction

Why is it important to visualize your data? Data visualization highlights business operations strengths and exposes problems. Huge amounts of data are usually overwhelming and difficult to process, thus effective charts, graphs, and tables can simplify complex data and bring it to life, enabling us to make important decisions.

However, wrong visual aids can actually mislead, so it’s important to be careful when selecting visual data tools. Different types of charts and graphs have different purposes. Proper formatting is very important, too. Typically, it’s best to keep visual aids simple and uncluttered.

This lesson provides the basics of visual data presentation in Excel.

explore-30.jpg  

Visual Data Presentation

 

To view all of the videos from the video showcase below, you will need to use the scrollbar on the right of the list of videos. There are 10 videos in the showcase.

 

challenge-31.jpg  

Challenge Activity

You are keeping track of the value of your stock portfolio over the course of one day, at half-hour intervals. Create a chart to represent your data visually.

Based on what you have learned in this lesson, what chart will work best in this situation?

Line Chart

When you complete the project, check your answer via Stock Portfolio Chart Demo Video below. There is no audio with the video.

 

Snap206-23.jpg  

 

Scatter Charts

Scatter charts are used to show the correlation between two variables. For example, a scatter chart would be useful for showing the relationship between daily high temperatures and ice cream sales. Scatter charts are not as commonly used by businesses and organizations but they can be very useful.

*

Here is a tutorial that shows you how to create a scatter chart (also known as scatter plot). There is no audio with the video.

 

BusTech_LessonBottomBanner.png   IMAGES CREATED BY GAVS