Training:
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
- Formfields
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