Latest from AirOps

How to automatically write dbt SQL queries using AI

With AI Data Sidekick, you can use artificial intelligence to ✨automatically✨ write SQL queries in dbt Cloud.

Using AI to optimize your SQL queries

How to quickly optimize SQL queries using artificial intelligence.

Using AI to generate YAML entries for dbt models

How to use artificial intelligence to automatically generate YAML entries for your dbt models.

How to create Python scripts automatically using AI

Using artificial intelligence to generate a full Python script from any table.

by AirOps Team on Jan 25, 2023

How to use AI to automatically generate a Python script using dbt syntax

Use artificial intelligence to instantly generate a full Python script from a dbt model.

Automatically document SQL tables using AI

How to instantly generate documentation for your SQL tables using artificial intelligence.

Explain complex SQL queries using AI

Copy/paste complex SQL queries into AI Data Sidekick, get an instant explanation about what the query does, use cases, and more.

How to instantly fix SQL queries using AI

Getting errors on your SQL queries? Artificial intelligence can help you find the culprit.

How to use AI to explain a database table (instantly)

What information does your database table contain? Use artificial intelligence to find out.

What questions can your data answer? Use AI to find out

How to use artificial intelligence to determine which questions a data table can answer.

How to automatically write SQL with AI

Whether you’re new to SQL or a data pro, you can use artificial intelligence to ✨automatically✨ write SQL queries.

by Kyle Dempsey on Jan 19, 2023

SQL vs. Python: What language is best for data transformation?

SQL is the most widely used data language, but it’s not always the best choice for data transformation. Good thing dbt supports Python now.

by Alex Halliday on Feb 07, 2023

ChatGPT was the tip of the spear: Our 2023 generative AI predictions

2022 saw generative AI become mainstream helped by ChatGPT, Jasper AI and DALL·E 2. What comes next?

AirOps Updates

dbt + AirOps AI Data Sidekick

Write, optimize, and troubleshoot dbt SQL queries. Build Python models. Faster than ever before.

Calculating distance between two points in SQL

2 ways to calculate distance between two points using SQL (plus a bonus Python method for more advanced use cases).

AirOps Updates

Meet 🦸‍♀️ Data Sidekick

Every data superhero needs a Sidekick.

Learn SQL for free: Our all-time favorite SQL learning resources

25 free resources you can use to learn (and master) SQL.

by AirOps Team on Nov 23, 2022

16 critical customer success metrics you need to track

To measure the performance of your customer success team, track these essential metrics and KPIs.

How to design a winning metrics framework: PLG SaaS edition

What metrics should your PLG SaaS company measure, monitor, and move?

How to track Lead to Opportunity Conversion Rate in Google Sheets using AirOps

Lead to Opportunity Conversion Rate: What it is, how to improve it, and best practices for tracking it.

How to calculate Repeat Customer Rate in Google Sheets using AirOps

Repeat Customer Rate: A sales performance metric to assess growth from repeat buyers who come back again and again.

The PLG SaaS metrics dictionary: Essential product-led growth metrics to measure your company’s performance

A deep dive into the executive and operational PLG metrics that product-led companies can use to measure acquisition, activation, retention, revenue, and referrals.

How to Calculate Customer Lifetime Value (CLV) in Google Sheets using AirOps

Customer Lifetime Value: What it is, how to calculate it, and how to use CLV to drive growth.

How to calculate Average Revenue Per User in Google Sheets using AirOps

Average Revenue Per User (ARPU): What it is, how to calculate it, and how to use it to improve revenue in your product-led growth organization.

How to calculate Net Revenue Retention (NRR) in Google Sheets using AirOps

NRR: How to calculate it, why it’s so important (especially for SaaS companies), and frequently asked questions about NRR.

by AirOps Team on Nov 03, 2022

How to calculate Net Promoter Score (NPS) in Google Sheets using AirOps

Net Promoter Score, aka NPS, is often considered the gold standard of customer experience metrics. Here’s everything you need to know about it.

by AirOps Team on Nov 09, 2022

How to measure Customer Churn in Google Sheets using AirOps

Customer Churn: What it is, why it’s important, best practices for measuring it, and how to improve your Customer Churn rates.

by Matt Hammel on Nov 03, 2022

How to increase the ROI of your data stack

Your data stack is an expensive investment. Here are six ways to make sure that investment pays off.

5 reasons dbt sets the standard for data transformation tools

dbt is the de facto data transformation tool for today's modern data stack (and here's why).

dbt exposures: A powerful [and underused] feature

Improve data visibility and get a full view of your data landscape with dbt exposures.

How to connect Snowflake to Google Sheets

Snowflake to Google Sheets: 3 options to move data from one to the other

by AirOps Team on Sep 19, 2022

How to track Monthly Recurring Revenue (MRR) in Google Sheets using AirOps

How to calculate and track MRR (plus important considerations to keep in mind, how to improve MRR, and more).

How to measure First Contact Resolution in Zendesk using AirOps

How to calculate and track First Contact Resolution (and why it’s so important).

by Alex Halliday on Sep 14, 2022

How to run a great Weekly Business Review and build a data-driven culture: A conversation with MasterClass COO Mark Williamson

Alex Halliday (AirOps Founder & CEO) and Mark Williamson (MasterClass COO) talk Weekly Business Reviews.

How to run excellent leadership meetings

8 steps for high-growth companies to launch, run, and maximize the value of their weekly leadership meetings.

How to calculate Average Resolution Time in Zendesk using AirOps

Average Resolution Time: What it is, why it’s important, and how to (easily) measure it.

by AirOps Team on Nov 04, 2022

How to measure CSAT in Zendesk using AirOps

Customer Satisfaction Score (CSAT): What it is, why it’s important, and how to (easily) measure it.

How to measure Average Response Time in Zendesk using AirOps

Average Response Time for customer service teams: What it is, why it’s important, and how to (easily) measure it.

by Isaac Chambers on Sep 14, 2022

15 common customer service metrics and how to use them

15 customer service metrics that your customer service team can use to measure performance.

How to measure the ROI of data analytics in your company

An interview with Chris Meier (Director, Data) at Bambee: A new way to think about measuring the return on investment of a data team and data stack.

by AirOps Team on Jan 10, 2023

Data Demystified, Part 4: Building an efficient data team

…and why an analytics engineer should be your first data team hire.

Best BI tools for startups: How to choose a BI tool

Find the right data analytics and business intelligence tool for your organization with this guide to some of the best BI tools for startups.

How to build your foundational data models

An overview of a modular data modeling process.

What is data modeling?

Types of data models, the data modeling process, & why data modeling is so important.

Best cloud data warehouses: Top provider comparison

Snowflake vs. Redshift vs. BigQuery vs. Synapse: Choosing the best cloud data warehouse.

What is reverse ETL?

To operationalize your data, you need reverse ETL.

by AirOps Team on Jan 10, 2023

Measuring sales performance: The 16 key metrics that highly productive teams monitor

Here are 16 sales metrics that your sales team can use to measure performance.

Data ingestion 101: What it is & how to choose the right tool

What data ingestion is, why it’s an important part of the modern data stack, and the best data ingestion tools.

by AirOps Team on Nov 22, 2022

How to measure ROAS (return on advertising spend)

A simple ROAS formula to measure how well your advertising works.

Building your metrics framework: A 7-step guide

What metrics should your company monitor? Here’s how to find out which ones will have the biggest impact.

How to design a winning metrics framework

What metrics should your business measure? Here’s how to find out.

ETL vs. ELT: Understanding the differences & benefits

Which data integration method is best for your organization?

What is a data warehouse?

Data Warehouses: Overview, benefits, and how to choose a data warehouse.

by AirOps Team on Jan 19, 2023

Data Demystified, Part 3: How to build a modern data stack

Part 3: The (non-technical) business leader’s guide to kicking off an effective data analytics & BI program.

by AirOps Team on Jan 11, 2023

Data Demystified, Part 2: Setting your data strategy

Part 2: The (non-technical) business leader’s guide to setting a data analytics and BI strategy

by AirOps Team on Jan 11, 2023

Data Demystified, Part 1: Getting started with data analytics & business Intelligence

Part 1: The (non-technical) business leader’s guide to running an effective data analytics & BI program.

by AirOps Team on Dec 13, 2022

No-code operations: What it is and why It Will shape the internal tool landscape

What are the best practices for using no-code tools in internal business operations?

by Alex Halliday on Sep 19, 2022

What is product operations? (and why is it so important for scaling?)

How a product operations team can help your organization scale quickly and efficiently.

by Alex Halliday on Jan 01, 2023

No-code tools vs. engineering teams: Avoid conflict and ship faster

The way the best teams build software, internal tools and customer experiences is undergoing a sea change, thanks in large part to the emergence of low and no-code tools. How can teams manage this change without conflict?

How to automatically write dbt SQL queries using AI

With AI Data Sidekick, you can use artificial intelligence to ✨automatically✨ write SQL queries in dbt Cloud.

Using AI to optimize your SQL queries

How to quickly optimize SQL queries using artificial intelligence.

Using AI to generate YAML entries for dbt models

How to use artificial intelligence to automatically generate YAML entries for your dbt models.

How to create Python scripts automatically using AI

Using artificial intelligence to generate a full Python script from any table.

by AirOps Team on Jan 25, 2023

How to use AI to automatically generate a Python script using dbt syntax

Use artificial intelligence to instantly generate a full Python script from a dbt model.

Automatically document SQL tables using AI

How to instantly generate documentation for your SQL tables using artificial intelligence.

Explain complex SQL queries using AI

Copy/paste complex SQL queries into AI Data Sidekick, get an instant explanation about what the query does, use cases, and more.

How to instantly fix SQL queries using AI

Getting errors on your SQL queries? Artificial intelligence can help you find the culprit.

How to use AI to explain a database table (instantly)

What information does your database table contain? Use artificial intelligence to find out.

What questions can your data answer? Use AI to find out

How to use artificial intelligence to determine which questions a data table can answer.

How to automatically write SQL with AI

Whether you’re new to SQL or a data pro, you can use artificial intelligence to ✨automatically✨ write SQL queries.

Calculating distance between two points in SQL

2 ways to calculate distance between two points using SQL (plus a bonus Python method for more advanced use cases).

How to design a winning metrics framework: PLG SaaS edition

What metrics should your PLG SaaS company measure, monitor, and move?

How to track Lead to Opportunity Conversion Rate in Google Sheets using AirOps

Lead to Opportunity Conversion Rate: What it is, how to improve it, and best practices for tracking it.

How to calculate Repeat Customer Rate in Google Sheets using AirOps

Repeat Customer Rate: A sales performance metric to assess growth from repeat buyers who come back again and again.

How to Calculate Customer Lifetime Value (CLV) in Google Sheets using AirOps

Customer Lifetime Value: What it is, how to calculate it, and how to use CLV to drive growth.

How to calculate Average Revenue Per User in Google Sheets using AirOps

Average Revenue Per User (ARPU): What it is, how to calculate it, and how to use it to improve revenue in your product-led growth organization.

How to calculate Net Revenue Retention (NRR) in Google Sheets using AirOps

NRR: How to calculate it, why it’s so important (especially for SaaS companies), and frequently asked questions about NRR.

by AirOps Team on Nov 03, 2022

How to calculate Net Promoter Score (NPS) in Google Sheets using AirOps

Net Promoter Score, aka NPS, is often considered the gold standard of customer experience metrics. Here’s everything you need to know about it.

by AirOps Team on Nov 09, 2022

How to measure Customer Churn in Google Sheets using AirOps

Customer Churn: What it is, why it’s important, best practices for measuring it, and how to improve your Customer Churn rates.

by Matt Hammel on Nov 03, 2022

How to increase the ROI of your data stack

Your data stack is an expensive investment. Here are six ways to make sure that investment pays off.

dbt exposures: A powerful [and underused] feature

Improve data visibility and get a full view of your data landscape with dbt exposures.

How to connect Snowflake to Google Sheets

Snowflake to Google Sheets: 3 options to move data from one to the other

by AirOps Team on Sep 19, 2022

How to track Monthly Recurring Revenue (MRR) in Google Sheets using AirOps

How to calculate and track MRR (plus important considerations to keep in mind, how to improve MRR, and more).

How to measure First Contact Resolution in Zendesk using AirOps

How to calculate and track First Contact Resolution (and why it’s so important).

by Alex Halliday on Sep 14, 2022

How to run a great Weekly Business Review and build a data-driven culture: A conversation with MasterClass COO Mark Williamson

Alex Halliday (AirOps Founder & CEO) and Mark Williamson (MasterClass COO) talk Weekly Business Reviews.

How to run excellent leadership meetings

8 steps for high-growth companies to launch, run, and maximize the value of their weekly leadership meetings.

How to calculate Average Resolution Time in Zendesk using AirOps

Average Resolution Time: What it is, why it’s important, and how to (easily) measure it.

by AirOps Team on Nov 04, 2022

How to measure CSAT in Zendesk using AirOps

Customer Satisfaction Score (CSAT): What it is, why it’s important, and how to (easily) measure it.

How to measure Average Response Time in Zendesk using AirOps

Average Response Time for customer service teams: What it is, why it’s important, and how to (easily) measure it.

by Isaac Chambers on Sep 14, 2022

15 common customer service metrics and how to use them

15 customer service metrics that your customer service team can use to measure performance.

How to measure the ROI of data analytics in your company

An interview with Chris Meier (Director, Data) at Bambee: A new way to think about measuring the return on investment of a data team and data stack.

Best BI tools for startups: How to choose a BI tool

Find the right data analytics and business intelligence tool for your organization with this guide to some of the best BI tools for startups.

How to build your foundational data models

An overview of a modular data modeling process.

Data ingestion 101: What it is & how to choose the right tool

What data ingestion is, why it’s an important part of the modern data stack, and the best data ingestion tools.

by AirOps Team on Nov 22, 2022

How to measure ROAS (return on advertising spend)

A simple ROAS formula to measure how well your advertising works.

Building your metrics framework: A 7-step guide

What metrics should your company monitor? Here’s how to find out which ones will have the biggest impact.

How to design a winning metrics framework

What metrics should your business measure? Here’s how to find out.

by AirOps Team on Jan 19, 2023

Data Demystified, Part 3: How to build a modern data stack

Part 3: The (non-technical) business leader’s guide to kicking off an effective data analytics & BI program.

by AirOps Team on Jan 11, 2023

Data Demystified, Part 2: Setting your data strategy

Part 2: The (non-technical) business leader’s guide to setting a data analytics and BI strategy

by Kyle Dempsey on Jan 19, 2023

SQL vs. Python: What language is best for data transformation?

SQL is the most widely used data language, but it’s not always the best choice for data transformation. Good thing dbt supports Python now.

by Alex Halliday on Feb 07, 2023

ChatGPT was the tip of the spear: Our 2023 generative AI predictions

2022 saw generative AI become mainstream helped by ChatGPT, Jasper AI and DALL·E 2. What comes next?

Learn SQL for free: Our all-time favorite SQL learning resources

25 free resources you can use to learn (and master) SQL.

by AirOps Team on Nov 23, 2022

16 critical customer success metrics you need to track

To measure the performance of your customer success team, track these essential metrics and KPIs.

The PLG SaaS metrics dictionary: Essential product-led growth metrics to measure your company’s performance

A deep dive into the executive and operational PLG metrics that product-led companies can use to measure acquisition, activation, retention, revenue, and referrals.