Oz and Robin team up again for episode 2 of the Relentless Analyst Podcast. This time they dive right on in to 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:
3:00 What data tools does Robin love?
4:24 What can you call a database?
6:47 How does Robin see a database?
8:22 How did Robin discover her love of databases?
11:00 How did Oz get into Excel?
14:15 Can you leverage database technologies to do your job?
18:00 When does Robin think you go from a spreadsheet to a database?
21:30 What does Robin want you to know about how to use databases?
27:30 When does Oz think you go from a spreadsheet to a database? 29:45 What is a data warehouse?
30:38 When should you re-evaluate your data governance stack?
32:22 What happens when your people don’t have data skills?
34:30 Is Power Query a database technology?
35:30 What should you know about joins?
38:58 Who do Robin’s students think teaches joins better, Robin or Oz?
40:00 Why does Robin think all data workers should have at least a basic knowledge of Access?
45:10 What are the pros and cons of databases?
46:35 What are the pros and cons of spreadsheets?
49:22 When is a good time to investigate database technology?
52:40 What should databases do?
57:00 What does Robin want all data workers to develop? 1:00:00 What are Robin’s takeaways?