About the Course
Description: Ready to level up your Insights game? This course is all about taking control of your data. You’ll learn how to fine tune your reports so they show exactly what you need. No fluff, no confusion. From filters to formulas, we’ve got you covered.
Prerequisites: Search and Answers in Insights l Estimated Time: 30 minutes
Learning Objectives:
• Use filters to narrow down data and focus on what matters
• Build formulas and parameters to do quick math and make reports dynamic
• Use custom fields to tailor reports to your firm’s specific needs
• Build a custom report from scratch that you’ll actually want to use
Course Categories
-
Time to Customize
- Course Overview
- Creating Answers Review
-
Working with Filters
- Why Filters Matter
- Add a Filter to a Table
- Add a Filter to a Chart
- Create a Bulk Filter
- Delete a Filter
- Filter on Null values
-
Date Filters
- Working with Time in Insights
- Time Buckets
- Time Buckets in Action
- Filtering for a Date Range
- Date Filters in Real Life
-
Building Formulas and Parameters
- Unlocking the Power of Formulas
- Introduction to Formulas
- View or Edit a Formula in a Search
- Standard vs. Aggregation Formulas
- Date Formulas
- Percent (simple number) Calculations
- Conditional Formulas (operators)
- Using Parameters
- Common Calculations with Formulas
-
Custom Fields
- Custom Fields in Insights
- Adding Custom Fields
-
Understanding your Data
- Dig Deeper into Your Data
- See Underlying Data
- Drill Down on Your Data
-
Course Challenge
- Challenge Overview
- Step One: Create An Answer
- Step Two: Apply Filters and Conditional Formatting
-
Course Quiz
- Course Quiz
About the Course
Description: Ready to level up your Insights game? This course is all about taking control of your data. You’ll learn how to fine tune your reports so they show exactly what you need. No fluff, no confusion. From filters to formulas, we’ve got you covered.
Prerequisites: Search and Answers in Insights l Estimated Time: 30 minutes
Learning Objectives:
• Use filters to narrow down data and focus on what matters
• Build formulas and parameters to do quick math and make reports dynamic
• Use custom fields to tailor reports to your firm’s specific needs
• Build a custom report from scratch that you’ll actually want to use
-
Time to Customize
- Course Overview
- Creating Answers Review
-
Working with Filters
- Why Filters Matter
- Add a Filter to a Table
- Add a Filter to a Chart
- Create a Bulk Filter
- Delete a Filter
- Filter on Null values
-
Date Filters
- Working with Time in Insights
- Time Buckets
- Time Buckets in Action
- Filtering for a Date Range
- Date Filters in Real Life
-
Building Formulas and Parameters
- Unlocking the Power of Formulas
- Introduction to Formulas
- View or Edit a Formula in a Search
- Standard vs. Aggregation Formulas
- Date Formulas
- Percent (simple number) Calculations
- Conditional Formulas (operators)
- Using Parameters
- Common Calculations with Formulas
-
Custom Fields
- Custom Fields in Insights
- Adding Custom Fields
-
Understanding your Data
- Dig Deeper into Your Data
- See Underlying Data
- Drill Down on Your Data
-
Course Challenge
- Challenge Overview
- Step One: Create An Answer
- Step Two: Apply Filters and Conditional Formatting
-
Course Quiz
- Course Quiz