Advanced Developer
Course Duration: 1 day
This course is designed to give users an understanding of how to rapidly create complex reports and dashboards using CXAIR’s advanced calculation, charting and filtering capabilities.
Who Should Attend?
IT Professionals, Analysts and Business Users who have prior experience in developing reports and dashboards in CXAIR who wish to extend their knowledge by learning advanced techniques and features.
Course Benefits
Upon completion of this course, attendees will be able to:
Understand the advanced features within CXAIR
Understand how to use saved queries to format P&L style reports
Use conditional statements for advanced calculations
Use advanced CXAIR functions
Define dynamic, rolling calendar and form based filters
Understand how to use Pages Text/ HTML Editor to enhance Page reports
Define advanced row and column based calculations
Understand best practices for successful report creation
Course Content
The following topics will be covered during this course:
Advanced Features Essentials
Core Concepts
Crosstab Refresher
Calculation Syntax
Row and Column Totals
Saved Queries
Advanced Charting
Multi-Index Page Reports
Advanced Reporting
Row and Column Totals
Cell Calculations
When to Use These Totals
Linking Totals
DrillThru Calculation
Placeholder Queries
Report Formatting
Dynamic Labelling
Hiding Report Levels
Using Hidden Measures
Advanced Calculations
CASE and IF Statements
Date Calculation Syntaxes
Conditional Statements
Form fields
Hints and Tips
Best Practices
Naming Conventions
Example Crosstabs
Example VENN Diagrams
Example Flow Reports
Example Dashboards
Mobile Design Considerations
Advanced Pages
Break Fields
Layers
Text / HTML Editor
Multi-Index Reports
Sentiment Analysis
Setting up Sentiment Analysis and applying it to an index
Using the Sentiment Analysis output