Advanced Skill Level

Pipelines

Requirements Gathering

Workflow Mapping

Formula Queries

Formula Fields

Reporting

Embedded Display/Entry

Relational Database Structuring

End-User Adoption Planning

Dashboards

Notifications

Realm & User Management

API Calls

Rich Text & HTML Formulas

Expert Skill Level

V-Lookup

Embedded, Nested, and Conditional Formulas

Macros

Charts/Graphs

Advanced Sorting/Filtering

Data Cleaning, Manipulation, and Validation

Expert Skill Level

Word

PowerPoint

OneNote

Teams

To Do

Outlook

Intermediate Skill Level

Data structure & manipulation

Conditional Statements

Loops & Iterations

Object-Oriented Programming

Pandas Package

SQLite Package


Intermediate Skill Level

Visualization

Scientific Hypothesis Testing

Data Cleaning

Regression Analysis

Trend Projection

Multi-Factor Analysis

Structural Equation Modeling

Intermediate Skill Level

Skill Examples

SELECT/FROM

Conditional Filters (WHERE, OR, AND, ORDER BY. GROUP BY)

JOINS

Subqueries

Intermediate Skill Level

Skills Examples

Analysis of Variance

Charts

Multiple Regression Analysis