Hands-On Lab: Advanced Spreadsheet Reporting
When
2-Day Online Course, Group Internet Based
Available Dates
- September 4 – 5, 2024
- December 10 – 11, 2024
Registration
You can register for the course here.
Course Description
Axiom software provides enhanced spreadsheets to transform data into insightful reports and dashboards. In this course that expands on the spreadsheet fundamentals learned in Axiom Intelligence, you will develop best practices in creating robust spreadsheet reports using advanced techniques such as nesting Axiom queries to dynamically group and build data structures in a report. Additionally, you will learn to use Axiom diagnostic tools to troubleshoot and tune spreadsheets for high-performance and usability.
Course Length and Delivery Method
2 Day, Group Internet Based
Cost
$750
Audience
Primary Users, Data Analysts, Report Writers, Report Modifiers
Prerequisites
Axiom Essentials and Axiom Intelligence (Live or Virtual)
OR
Axiom Academy Certification - Fundamentals and Report Writing (before April 2022)
Advanced Preparation
None
Field of Study
Computer Software and Applications
Program Level
Intermediate
Learning Objectives
Module 1: Advanced Spreadsheet Reports
- Define advanced spreadsheet reports and contrast with other Axiom intelligence files
- Identify use cases for advanced spreadsheet reports
- List best practices for creating efficient and interactive spreadsheet reports
Module 2: Variables and Data Lookups
- Configure the Variables sheet
- Differentiate Data Lookups from Axiom Queries
- Add Data Lookups to a report
Module 3: Nested and Parallel Queries
- Identify use cases for multiple queries
- Create reports with Nested and Parallel Queries
- Decipher a complex report that uses multiple queries
Module 4: Stacked and Horizontal Queries
- Identify use cases for Stacked and Horizontal Queries
- Create reports that use Stacked queries
- Use a Horizontal Query to populate a field definition row
Module 5: Axiom diagnostic tools
- Enable Axiom diagnostic tools
- Generate a diagnostic report
- List best practices when using spreadsheet formulas
- Troubleshoot and optimize a slow performing report
For more information regarding administrative policies such as complaints and refunds, please contact strataacademy@stratadecision.com.