The Relentless Analyst: Episode 2 Databases and or Spreadsheets
The Relentless Analyst: Episode 2 Databases and/or Spreadsheets
April 15, 2021 - Oz and Robin team up again for episode 2 of the Relentless Analyst Podcast. This time they dive right into the topic of when you seek out databases over spreadsheets. This was a super big topic, and they covered a lot of ground. Listen if you want the answers to these questions:
What data tools does Robin love? (3:00)
What can you call a database? (4:24)
How does Robin see a database? (6:47)
How did Robin discover her love of databases? (8:22)
How did Oz get into Excel? (11:00)
Can you leverage database technologies to do your job? (14:15)
When does Robin think you go from a spreadsheet to a database? (18:00)
What does Robin want you to know about how to use databases? (21:30)
When does Oz think you go from a spreadsheet to a database? (27:30)
What is a data warehouse? (29:45)
When should you re-evaluate your data governance stack? (30:38)
What happens when your people don’t have data skills? (32:22)
Is Power Query a database technology? (34:30)
What should you know about joins? (35:30)
Who do Robin’s students think teaches joins better, Robin or Oz? (38:58)
Why does Robin think all data workers should have at least a basic knowledge of Access? (40:00)
What are the pros and cons of databases? (45:10)
What are the pros and cons of spreadsheets? (46:35)
When is a good time to investigate database technology? (49:22)
What should databases do? (52:40)
What does Robin want all data workers to develop? (57:00)
What are Robin’s takeaways? (1:00:00)
ThinkData's YouTube channel has lots of helpful videos- click the button below and take a look today!