Knowledge Base

Application

• Database Connections
• Supported Databases
• Data Providers
• Configuration Options
• Metadata Synchronization

Data Modeling

• Shapes
• Items
• Connectors
• Aliases
• Relationship Items
• ER Notation
• Many-to-Many Relationships
• One-to-Zero/One Relationships
• Diagram Options
• Generated Models

Expressions

• Values
• Numbers
• Strings
• Date and Time
• Null Issues and Fixes
• Fluent Expressions
• Conditional Formula

Joins

• Basic Joins
• Join Notation
• Hierarchies
• Lookups
• Custom Joins
• Chains
• Union Joins
• Drill-Down

Basic Queries

• Query Types
• Sorting Data
• Filter Data
• Parameterized Queries
• Nesting Queries
• Demo Queries

Special Queries

• Skip-and-Keep Queries
• Inline Subqueries
• Aggregate Queries
• Crosstab Queries
• Grouping Sets
• Window Functions
• Result Extensions

Visualization

• Effects