Skip to content
The Layman's Guide to Data Terminology: Part One episode artwork

Feb 29, 2024 9 min

The Layman's Guide to Data Terminology: Part One

from The Dashboard Effect Hosted by Brick Thompson, Jon Thompson, Caleb Ochs

This episode is the first installment in a series of episodes that will serve as a primer on the key terms and technologies surrounding data management. Brick and Caleb begin with the fundamental differences between transactional and analytical databases, explaining concepts like OLAP, OLTP, normalization, and denormalization in an accessible way. They also clarify the essence of SQL, how it interacts with databases, and introduce the concept of Serverless SQL. Whether you're new to data or looking to deepen your understanding, this episode is a good place to start getting a handle on common data terminology. Click here to watch this episode on our YouTube channel. Blue Margin increases enterprise value for PE-backed, mid-market companies by serving as their fractional data team. We advise on, build, and manage data platforms. Our strategy, proven with over 300 companies to-date, expands multiples through data transformation, as presented in our book, The Dashboard Effect. Subscribe here to get more episodes of The Dashboard Effect podcast on your favorite podcast app. Visit Blue Margin's library of additional BI resources.

Episode details come from the podcast's RSS feed.

Embed this episode

This episode is the first installment in a series of episodes that will serve as a primer on the key terms and technologies surrounding data management. Brick and Caleb begin with the fundamental differences between transactional and analytical databases, explaining concepts like OLAP, OLTP, normalization, and denormalization in an accessible way. They also clarify the essence of SQL, how it interacts with databases, and introduce the concept of Serverless SQL. Whether you're new to data or l...

Ready to play

The Layman's Guide to Data Terminology: Part One

0:00 9:36

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Dashboard Effect?

This episode is 9 minutes long.

When was this The Dashboard Effect episode published?

This episode was published on February 29, 2024.

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this The Dashboard Effect episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.