About the Course
Approximate Time: 90 minutes
Course Point Value: 375 total points (150 points + 225 bonus points)
- Optimize model queries for performance.
- Set up aggregate models to summarize data.
Prerequisites
This course will be most helpful if you’ve already completed the Level 1 series. Click here to complete that series first. As you complete each course, you will also earn points, badges, and prizes!
Course Instructor
Mari Trainer
Course Outline
-
Tips to Optimize Performance with Models
-
4 Tips to Improve Model Queries
-
#1: Don’t Query Models Until Needed
-
#2: Set a Smaller Limit
-
Actions to Query Models
-
#3: Optimize Ordering, Fields, and Conditions
-
Skuid Expedition: Optimize Model Performance
-
#4. Use Aggregate Models to Summarize Data
-
Groupings
-
Ideas for Aggregate Models
-
Tips for Aggregate Models
-
Skuid Expedition: Create an Aggregate model
-
Lesson Summary — Tips to Optimize Performance with Models
-
Solo Adventure: Create KPIS using Aggregate Models
-
Adventure Unlocked: Create Aggregate Models
-
Think or Swim: Tips to Optimize Performance with Models
-
About the Course
Approximate Time: 90 minutes
Course Point Value: 375 total points (150 points + 225 bonus points)
- Optimize model queries for performance.
- Set up aggregate models to summarize data.
Prerequisites
This course will be most helpful if you’ve already completed the Level 1 series. Click here to complete that series first. As you complete each course, you will also earn points, badges, and prizes!
Course Outline
-
Tips to Optimize Performance with Models
-
4 Tips to Improve Model Queries
-
#1: Don’t Query Models Until Needed
-
#2: Set a Smaller Limit
-
Actions to Query Models
-
#3: Optimize Ordering, Fields, and Conditions
-
Skuid Expedition: Optimize Model Performance
-
#4. Use Aggregate Models to Summarize Data
-
Groupings
-
Ideas for Aggregate Models
-
Tips for Aggregate Models
-
Skuid Expedition: Create an Aggregate model
-
Lesson Summary — Tips to Optimize Performance with Models
-
Solo Adventure: Create KPIS using Aggregate Models
-
Adventure Unlocked: Create Aggregate Models
-
Think or Swim: Tips to Optimize Performance with Models
-
Course Categories
Level 2
Course Instructor
Mari Trainer