AirOps Consulting

Become an Airtable Champion

The world's most comprehensive course on Airtable

Build on your existing Airtable skills and learn to design, create, and manage Airtable Bases that adhere to the highest industry standards.

Artboard 1
Play Video
Artboard 1 copy 2
Ethical Swag (1)
Prosper-Portland-logo-tagline-300x300
OutbackPresents-square
PH_fulllogo_pink
Artboard 1 copy 4
BECOME AN AIRTABLE CHAMPION

A Course Designed for those who want to learn Airtable the right way.

Excellence in Airtable is a course designed for those looking to work and use Airtable professionally in their their career.

Throughout the course, students will learn everything they need to manage and grow the Airtable bases they work with each day. The course will start with fundamentals, but quickly dive into advanced topics like database schema design, data management, custom fields and formulas, advanced interfaces/views, and automations.

The course is instructed by award winning, Airtable certified instructor Cherry Yang - who will be there each step of the way as you grow your skills as an Airtable developer.

Module 1: Database Design

Module 1 explores the concept of scalable database design and the fundamental principles of implementing modular, maintanable, and scalable Airtable bases. In Module 1 we'll cover: ➣ Defining database scope ➣ Relational database principles ➣ How to define business needs ➣ How to define Airtable base requirements ➣ Designing Airtable base architecture ➣ Creating an Airtable base

Module 2: Implementation

In Module 2 we take a deep dive into Airtable and create an Airtable base from scratch - exploring all the features available to you when building a base. In Module 2 we'll cover: ➣ Fields and tables (All 28 types) ➣ Formulas (Text, Numeric, Date/Time, Arrays, Record Functions) ➣ Views (Grid, Form, Calendar, Kanban, Timeline, Gantt, Gallery) ➣ Automations (Triggers & Actions, Tools, Email, Time Based, Zapier, Conditionals, 3rd Party Integrations) ➣ Reporting (Rollup Fields, Pivot Tables, Quarterly/Annual Reporting, Charts/Graphs) ➣ Interfaces & Portals

Module 3: Support

Module 3 wraps up the course by exploring the various third-party tools available to supercharge an Airtable database. In Module 3 we'll cover: ➣ Useful 3rd Party Tools (On2Air, MiniExtensions, Pory, Stacker, and more!) ➣ Permission Management ➣ Data Integrations ➣ Data Synchronization ➣ Ongoing training & team onboarding ➣ Best practices for maintaining your database

WHAT WILL I KNOW BY THE END OF THE COURSE

Course Outcomes

We've designed our course with two primary learning objectives in mind:

1) We want to our students to internalize good principles of database design
We want to help our students understand the fundamental principles that make up good database design. Databases that are organized, structured, and planned right the first time lead to cleaner, easier to manage, and modular Airtable applications.

and;

2) We want our students to leave with extrordinarily usable skills
We want our students to develop the intermediate/advanced skills they'll need to manage, extend, and improve the bases they build and work with on the daily. We want our students to leave the course comfortable bringing the skills they've learned back to their organizations; implementing their own new ideas with confidence and creativity.

Preview a Sample Lesson

Module 1 - Lesson 5 - What is Design

Custom Airtable Database Implementation

Harness the power of your data to transform your organization.

Databases to Write Home About

AirOps Consulting creates bespoke, streamlined Airtable solutions that let you connect information, collaborate, and build powerful databases to help your business reach its potential.

Design

How to scope your project Understanding and analyzing the business needs Architecting your base

Implementation

- configuring fields and tables - Automations - Implementations

Support

Ongoing training Onboarding your team Best practices for maintaining your database

6

Course Modules

100+

Video Lessons

40+

Airtable Templates

10+

Hours of Content

Customizable

All of our databases are built from the ground up to fit the needs of your organization and team.

Scalable

Our Airtable solutions are designed to grow alongside the success of your business.

Simple

All of our databases are streamlined, intuitive, and easy to use.

Course Curriculum

Our approach is named The AirOps Advantage.

The AirOps Advantage contains 3 steps:

  1. Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
  2. Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
  3. Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.

Our approach is named The AirOps Advantage.

The AirOps Advantage contains 3 steps:

  1. Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
  2. Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
  3. Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.

Airtable is a customizable database solution. Since 2019, we have worked with over 100 organizations from many industries. The list below contains common industries that our clients are from:

  • Retail
  • Entertainment and Media production
  • Event Management
  • Technology
  • Manufacturing
  • Real Estate
  • Non-profit organizations
  • Government organizations
  • Professional Services and Agencies

Our projects typically take 5 – 12 weeks to complete depending on the size of the project. Larger and more complex projects could take up to 6 months.

AirOps Consulting can provide ongoing support to the client through a monthly hourly retainer. Clients use this retainer for many purposes like ongoing training, technical support, feature updates, and other database inquiries.

We integrate with a wide array of third-party apps through various methods. Airtable is constantly adding new integrations with different tools like Twilio, Outlook, Gmail, and Google Calendar. We also integrate with thousands of other apps using Zapier and Integromat like Quickbooks, SignNow, Shopify, and Mailchimp. If you need special integration requests, we can also create custom scripts to connect your Airtable.

We also have extensive knowledge of the apps listed below:

  • On2Air
  • Pory
  • Stacker
  • AirPower
  • MiniExtensions
  • Zapier

We work with many large teams and have built databases that enable collaboration with many stakeholders. Typically, we will use a combination of forms, portals, and automation to help our clients save on costs and properly configure the view and editing capabilities of various stakeholders.

Consistent, smart, thinks up stuff you never thought about.

Cherry is a consummate professional when it comes to Airtable and business in general. She has been working as a part of my team for several months now to create and launch an amazing new CRM for my business. I am thrilled with her results.

Jason Ford
Owner, Property Problem Solvers

About the Instructor

I’m Cherry Yang, founder of AirOps Consulting - As a Airtable Consultant Partner and certified Zapier expert, I’ve been building databases and workflows using Airtable and Zapier for over 100 clients; helping corporations untangle complex processes and streamline operations.

Course Overview

A deep dive into the content.

Module 1.1

Database Design

In the first section of the course we… 

In this section we’ll cover:
➣ Database scope
➣ Relational database principles
➣ How to define business needs

Module 1.2

Database Implementation

In this section we’ll cover:
➣ How to define Airtable base requirements
➣ Designing Airtable base architecture
➣ Creating an Airtable base

Module 2.1

Fields and Tables

Once the database is live, we'll train your team on how to make the most of the new tools and offer ongoing support through a monthly retainer.

Module 2.2

Formulas

In this section we’ll cover:
➣ How to define Airtable base requirements
➣ Designing Airtable base architecture
➣ Creating an Airtable base

Module 2.3

Views

Once the database is live, we'll train your team on how to make the most of the new tools and offer ongoing support through a monthly retainer.

Module 2.4

Automations

In this section we’ll cover:
➣ How to define Airtable base requirements
➣ Designing Airtable base architecture
➣ Creating an Airtable base

Module 2.5

Reporting

Once the database is live, we'll train your team on how to make the most of the new tools and offer ongoing support through a monthly retainer.

Module 2.6

Interfaces & Portals

In this section we’ll cover:
➣ How to define Airtable base requirements
➣ Designing Airtable base architecture
➣ Creating an Airtable base

Module 3.1

Third Party Integrations

Once the database is live, we'll train your team on how to make the most of the new tools and offer ongoing support through a monthly retainer.

Module 3.2

Data Management

In this section we’ll cover:
➣ How to define Airtable base requirements
➣ Designing Airtable base architecture
➣ Creating an Airtable base

Module 3.3

Implementation

Once the database is live, we'll train your team on how to make the most of the new tools and offer ongoing support through a monthly retainer.

Questions about the course

Frequently Asked Questions

Answers to our most common Database Implementation questions.

Our approach is named The AirOps Advantage.

The AirOps Advantage contains 3 steps:

  1. Database Strategy and Design – The first step allows our client’s internal team and AirOps Consulting to be entirely aligned on the process and what the outcome of the project will look like. The deliverable for this phase is the mockup of your database so the client can know how it will be set up.
  2. Database Implementation – The second step is for the AirOps Consulting consulting team to build the database by configuring fields, setting up automation, and implementing views and interfaces for various team members. The client team and AirOps team will have periodic meetings to communicate on the progress and clarifying questions
  3. Team Training and Support – The third step of our projects is to train the client team on how to use their database. AirOps Consulting can also provide ongoing support to the client through a monthly retainer.

Airtable is a customizable database solution. Since 2019, we have worked with over 100 organizations from many industries. The list below contains common industries that our clients are from:

  • Retail
  • Entertainment and Media production
  • Event Management
  • Technology
  • Manufacturing
  • Real Estate
  • Non-profit organizations
  • Government organizations
  • Professional Services and Agencies

Our projects typically take 5 – 12 weeks to complete depending on the size of the project. Larger and more complex projects could take up to 6 months.

AirOps Consulting can provide ongoing support to the client through a monthly hourly retainer. Clients use this retainer for many purposes like ongoing training, technical support, feature updates, and other database inquiries.

We integrate with a wide array of third-party apps through various methods. Airtable is constantly adding new integrations with different tools like Twilio, Outlook, Gmail, and Google Calendar. We also integrate with thousands of other apps using Zapier and Integromat like Quickbooks, SignNow, Shopify, and Mailchimp. If you need special integration requests, we can also create custom scripts to connect your Airtable.

We also have extensive knowledge of the apps listed below:

  • On2Air
  • Pory
  • Stacker
  • AirPower
  • MiniExtensions
  • Zapier

We work with many large teams and have built databases that enable collaboration with many stakeholders. Typically, we will use a combination of forms, portals, and automation to help our clients save on costs and properly configure the view and editing capabilities of various stakeholders.

Explore Our Services

See what we offer and how we deliver customized services that make your data work for you.

About AirOps Consulting

Get to know our company, our values, and why we’re the right partner for you.

Ready to Get Started?

Book a meeting with an AirOps Consultant.