Pivot your Excel skills into SQL
Having access to raw data is empowering. It allows analysts and business users to cut through the noise and find insights developers might not have thought to look for. Unfortunately, SQL, the query language used by 99% of modern databases, is not the most straightforward thing to learn. But if you already know how to use pivot tables in Microsoft Excel, you’re actually closer to picking up SQL than you think.
In this tutorial, we’ll walk through the process of calculating Customer Lifetime Value from marketing and sales data. We’ll look at how it’s typically done in Excel using pivot tables and draw parallels to the SQL queries that do the same thing on much larger datasets. By the time we’re done, you’ll be comfortable asking your development team for Read-Only access to start exploring your own business data.
Let’s get started!
Click the image to view a sample preview.