1
00:00:00,000 --> 00:00:09,420
[MUSIC]

2
00:00:09,420 --> 00:00:11,233
Howdy data analysts.

3
00:00:11,233 --> 00:00:14,860
Welcome to data visualization
with Google Sheets.

4
00:00:14,860 --> 00:00:18,900
My name is AJ and
I am an instructor at Treehouse.

5
00:00:18,900 --> 00:00:21,860
My pronouns include he and they.

6
00:00:21,860 --> 00:00:26,128
In this workshop, I'm excited to share
with you how to make different types of

7
00:00:26,128 --> 00:00:28,220
charts in Google Sheets.

8
00:00:28,220 --> 00:00:32,301
We will be practicing together
to make column and bar charts,

9
00:00:32,301 --> 00:00:37,580
line charts, scatter plots,
pie charts, and geographic charts.

10
00:00:37,580 --> 00:00:39,655
In the structure of this workshop,

11
00:00:39,655 --> 00:00:44,163
I will show you how to make each chart
before challenging you to make your own.

12
00:00:44,163 --> 00:00:48,917
We will also be going over how to create
alternative texts to make our charts

13
00:00:48,917 --> 00:00:52,540
more accessible for screen reader users.

14
00:00:52,540 --> 00:00:55,511
There are a few prerequisites for
this workshop, and

15
00:00:55,511 --> 00:00:58,160
you can find them below
in my Teacher's Notes.

16
00:00:59,470 --> 00:01:02,867
We will be exploring real
world global data sets and

17
00:01:02,867 --> 00:01:07,620
gaining insight into the data
with our visualizations.

18
00:01:07,620 --> 00:01:11,589
First, you will need to copy the Google
Sheets workbook to your personal

19
00:01:11,589 --> 00:01:12,900
Google Drive account.

20
00:01:12,900 --> 00:01:15,540
You can find a link below
in my Teacher's Notes.

21
00:01:16,790 --> 00:01:19,900
You will need to have a copy of
the data sets open in Google Sheets

22
00:01:19,900 --> 00:01:21,620
to follow along.

23
00:01:21,620 --> 00:01:25,080
Take a few moments right now to
explore the data on your own.

24
00:01:25,080 --> 00:01:29,428
There are three worksheets of economic and
demographic data for

25
00:01:29,428 --> 00:01:35,720
regions in the Western Hemisphere, Central
America, the Caribbean, and South America.

26
00:01:36,810 --> 00:01:40,825
At the bottom left of the workbook,
you can click the hamburger menu,

27
00:01:40,825 --> 00:01:43,547
that's the lines stacked
on top of each other,

28
00:01:43,547 --> 00:01:47,790
to navigate between the workbooks and
follow along with my screen casts.

29
00:01:52,080 --> 00:01:56,200
I will remind you which sheets
we will be using in each video.

30
00:01:57,880 --> 00:01:59,450
Are you ready?

31
00:01:59,450 --> 00:02:03,390
In the next video,
we will start with column and bar charts.