#4 product of the week on ProductHunt, support us!

Latest from AirOps

All
How To
Best Practices
AirOps Updates
Metrics Guides
How To

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.

by AirOps Team on Jan 25, 2023
How To

Using AI to optimize your SQL queries

How to quickly optimize SQL queries using artificial intelligence.

by AirOps Team on Jan 25, 2023
How To

Using AI to generate YAML entries for dbt models

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

by AirOps Team on Jan 25, 2023
How To

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

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.

by AirOps Team on Jan 25, 2023
How To

Automatically document SQL tables using AI

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

by AirOps Team on Jan 25, 2023
How To

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.

by AirOps Team on Jan 25, 2023
How To

How to instantly fix SQL queries using AI

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

by AirOps Team on Jan 20, 2023
How To

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

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

by AirOps Team on Jan 20, 2023
How To

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.

by AirOps Team on Jan 20, 2023
How To

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 AirOps Team on Jan 20, 2023
Best Practices

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 Kyle Dempsey on Jan 19, 2023
Best Practices

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?

by Alex Halliday on Jan 04, 2023
AirOps Updates

dbt + AirOps AI Data Sidekick

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

by Kyle Dempsey on Dec 15, 2022
How To

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).

by Kyle Dempsey on Dec 15, 2022
AirOps Updates

Meet 🦸‍♀️ Data Sidekick

Every data superhero needs a Sidekick.

by AirOps Team on Dec 15, 2022
Best Practices

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 Jan 13, 2023
Best Practices

16 critical customer success metrics you need to track

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

by AirOps Team on Nov 23, 2022
How To

How to design a winning metrics framework: PLG SaaS edition

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

by Matt Hammel on Dec 15, 2022
How To

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.

by AirOps Team on Nov 18, 2022
How To

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.

by AirOps Team on Nov 18, 2022
Best Practices

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.

by AirOps Team on Dec 15, 2022
How To

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.

by AirOps Team on Nov 10, 2022
How To

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.

by AirOps Team on Nov 10, 2022
How To

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 10, 2022
How To

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 03, 2022
How To

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 AirOps Team on Nov 09, 2022
How To

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.

by Matt Hammel on Nov 03, 2022
Best Practices

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).

by Kyle Dempsey on Dec 15, 2022
How To

dbt exposures: A powerful [and underused] feature

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

by Kyle Dempsey on Dec 15, 2022
How To

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 Jan 13, 2023
How To

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).

by AirOps Team on Sep 19, 2022
How To

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 AirOps Team on Sep 14, 2022
How To

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.

by Alex Halliday on Sep 14, 2022
How To

How to run excellent leadership meetings

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

by Matt Hammel on Dec 15, 2022
How To

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 Sep 14, 2022
How To

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.

by AirOps Team on Nov 04, 2022
How To

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 AirOps Team on Sep 14, 2022
How To

15 common customer service metrics and how to use them

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

by Isaac Chambers on Sep 14, 2022
How To

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 Dec 15, 2022
Best Practices

Data Demystified, Part 4: Building an efficient data team

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

by AirOps Team on Jan 10, 2023
How To

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.

by AirOps Team on Sep 14, 2022
How To

How to build your foundational data models

An overview of a modular data modeling process.

by Kyle Dempsey on Dec 15, 2022
Best Practices

What is data modeling?

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

by AirOps Team on Dec 15, 2022
Best Practices

Best cloud data warehouses: Top provider comparison

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

by AirOps Team on Dec 15, 2022
Best Practices

What is reverse ETL?

To operationalize your data, you need reverse ETL.

by AirOps Team on Dec 15, 2022
Best Practices

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.

by AirOps Team on Jan 10, 2023
How To

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 Dec 15, 2022
How To

How to measure ROAS (return on advertising spend)

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

by AirOps Team on Nov 22, 2022
How To

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.

by Kyle Dempsey on Dec 15, 2022
How To

How to design a winning metrics framework

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

by Matt Hammel on Dec 15, 2022
Best Practices

ETL vs. ELT: Understanding the differences & benefits

Which data integration method is best for your organization?

by AirOps Team on Dec 15, 2022
Best Practices

What is a data warehouse?

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

by AirOps Team on Dec 15, 2022
How To

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 19, 2023
How To

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
Best Practices

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 Jan 11, 2023
Best Practices

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 AirOps Team on Dec 13, 2022
Best Practices

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 Sep 19, 2022
Best Practices

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?

by Alex Halliday on Jan 01, 2023
How To

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.

by AirOps Team on Jan 25, 2023
How To

Using AI to optimize your SQL queries

How to quickly optimize SQL queries using artificial intelligence.

by AirOps Team on Jan 25, 2023
How To

Using AI to generate YAML entries for dbt models

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

by AirOps Team on Jan 25, 2023
How To

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

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.

by AirOps Team on Jan 25, 2023
How To

Automatically document SQL tables using AI

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

by AirOps Team on Jan 25, 2023
How To

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.

by AirOps Team on Jan 25, 2023
How To

How to instantly fix SQL queries using AI

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

by AirOps Team on Jan 20, 2023
How To

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

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

by AirOps Team on Jan 20, 2023
How To

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.

by AirOps Team on Jan 20, 2023
How To

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 AirOps Team on Jan 20, 2023
How To

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).

by Kyle Dempsey on Dec 15, 2022
How To

How to design a winning metrics framework: PLG SaaS edition

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

by Matt Hammel on Dec 15, 2022
How To

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.

by AirOps Team on Nov 18, 2022
How To

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.

by AirOps Team on Nov 18, 2022
How To

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.

by AirOps Team on Nov 10, 2022
How To

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.

by AirOps Team on Nov 10, 2022
How To

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 10, 2022
How To

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 03, 2022
How To

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 AirOps Team on Nov 09, 2022
How To

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.

by Matt Hammel on Nov 03, 2022
How To

dbt exposures: A powerful [and underused] feature

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

by Kyle Dempsey on Dec 15, 2022
How To

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 Jan 13, 2023
How To

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).

by AirOps Team on Sep 19, 2022
How To

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 AirOps Team on Sep 14, 2022
How To

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.

by Alex Halliday on Sep 14, 2022
How To

How to run excellent leadership meetings

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

by Matt Hammel on Dec 15, 2022
How To

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 Sep 14, 2022
How To

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.

by AirOps Team on Nov 04, 2022
How To

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 AirOps Team on Sep 14, 2022
How To

15 common customer service metrics and how to use them

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

by Isaac Chambers on Sep 14, 2022
How To

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 Dec 15, 2022
How To

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.

by AirOps Team on Sep 14, 2022
How To

How to build your foundational data models

An overview of a modular data modeling process.

by Kyle Dempsey on Dec 15, 2022
How To

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 Dec 15, 2022
How To

How to measure ROAS (return on advertising spend)

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

by AirOps Team on Nov 22, 2022
How To

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.

by Kyle Dempsey on Dec 15, 2022
How To

How to design a winning metrics framework

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

by Matt Hammel on Dec 15, 2022
How To

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 19, 2023
How To

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
Best Practices

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 Kyle Dempsey on Jan 19, 2023
Best Practices

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?

by Alex Halliday on Jan 04, 2023
Best Practices

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 Jan 13, 2023
Best Practices

16 critical customer success metrics you need to track

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

by AirOps Team on Nov 23, 2022
Best Practices

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.

by AirOps Team on Dec 15, 2022
Best Practices

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).

by Kyle Dempsey on Dec 15, 2022
Best Practices

Data Demystified, Part 4: Building an efficient data team

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

by AirOps Team on Jan 10, 2023
Best Practices

What is data modeling?

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

by AirOps Team on Dec 15, 2022
Best Practices

Best cloud data warehouses: Top provider comparison

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

by AirOps Team on Dec 15, 2022
Best Practices

What is reverse ETL?

To operationalize your data, you need reverse ETL.

by AirOps Team on Dec 15, 2022
Best Practices

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.

by AirOps Team on Jan 10, 2023
Best Practices

ETL vs. ELT: Understanding the differences & benefits

Which data integration method is best for your organization?

by AirOps Team on Dec 15, 2022
Best Practices

What is a data warehouse?

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

by AirOps Team on Dec 15, 2022
Best Practices

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 Jan 11, 2023
Best Practices

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 AirOps Team on Dec 13, 2022
Best Practices

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 Sep 19, 2022
Best Practices

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?

by Alex Halliday on Jan 01, 2023
AirOps Updates

dbt + AirOps AI Data Sidekick

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

by Kyle Dempsey on Dec 15, 2022
AirOps Updates

Meet 🦸‍♀️ Data Sidekick

Every data superhero needs a Sidekick.

by AirOps Team on Dec 15, 2022
No articles found.
How To

How To

How to automatically write dbt SQL queries using AI

Using AI to optimize your SQL queries

Using AI to generate YAML entries for dbt models

How to create Python scripts automatically using AI

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

Automatically document SQL tables using AI

Explain complex SQL queries using AI

How to instantly fix SQL queries using AI

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

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

Read all