Create Your Own Sample Data Sets Google Sheets and Google Data Studio for Educators
Автор: Smith Visualizations
Загружено: 2021-07-21
Просмотров: 1767
Have you ever wanted to share an example of a spreadsheet or dashboard with someone else but you were worried about having them see the real data because of privacy issues? Many times, I need to create a sample data set, but still keep the integrity of the actual data. I'll show you a few ways to quickly create sample data sets to use in Google Sheets or Google Data Studio.
I use this site to get names for teachers and students: http://random-name-generator.info/
0:00 Introduction
0:37 Getting set up
2:44 Create sample student IDs
4:25 Using the SEQUENCE formula
5:47 Change real names to placeholders
6:30 Replace names with real sample names
10:02 Use VLOOKUP to replace names that repeat more than once
18:03 Using the ARRAYFORMULA with VLOOKUP
19:08 Fix # N/A errors with IFERROR
20:12 Create sample email addresses with CONCATENATE
22:09 Use RANDBETWEEN to create sample birthdays
24:24 Align sample data across tabs
30:07 Create sample test scores
35:51 Show growth with sample data
38:28 Use nested RANDBETWEEN for relative high and low values
40:03 Extend formulas across columns and rows
40:48 Cleaning up errors in scores
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: