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!

Learn SQL preview

Click the image to view a sample preview.

Learn SQL Today

What our customers are saying

Susan Holcomb

Susan Holcomb

Head of Data Science

“In the early stages of data analysis, running many queries to understand data is important. Treasure Data has been great for that. The only tool that provided the flexibility we needed.”

Ted Cardenas

Ted Cardenas

VP of Marketing, Car Electronics

“The partnership with Treasure Data was really about the scale...Treasure Data became involved over the past year as we expanded considerably the number of vehicles we have out there collecting this data, and Treasure Data was important as we increased the market size from five or six years with tens of thousands of vehicles to now millions of data points.”

Danny Zhang

Danny Zhang

Co-Founder

“Our engineers no longer worry about maintaining analytics infrastructure... Instead, they focus on how to use the logged data to make our products better.”