Hands-On Lab: Advanced Spreadsheet Reporting

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 Information

• Audience: Primary Users, Data Analysts, Report Writers, Report Modifiers
• Prerequisite Courses:
  • Axiom Essentials
  • Axiom Intelligence
• Advanced Preparation: None
• Program Level: Intermediate
• Field of Study: Computer Software & Applications 
• CPE Credits: Up to 4 CPE credits. Refer to the Strata Academy homepage for more information. 

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 

Registration Instructions & Pricing

This stand-alone course costs $750 per attendee and is not included within a certification package. To purchase this course in Strata Academy, follow the steps in the Sign Up Guide. 

For more information regarding administrative policies such as complaints and refunds, please contact strataacademy@stratadecision.com.

Communications

After your registration in this course is confirmed, you will receive several emails:

• A calendar invitation for the course with Zoom information.  

• Closer to the course date, your instructor will email you information on your assigned Axiom training system. If you encounter any issues, email strataacademy@stratadecision.com.