Report Design Foundation

Report Design Foundation

This course walks you through the basic requirements for building report templates in Report Designer.

Not currently available

rate limit

Code not recognized.

About this course

This course includes a variety of report design lessons, grouped together by topic. At the end of each topic there is a quiz, allowing you to evaluate your knowledge.

NOTE: This course is applicable to users of both Solver Cloud/version 5 and BI360 version 4. Effective January  & July 2021, users of Solver see a new user interface (UI) with some updated terminology. Documents within this course are in the process of being updated to the new UI, however, video content is based on the previous display. 

Posted 12/17, Revised 3/23

Curriculum~ 60 minutes

  • Preview
    Quick Look: Report Designer
  • Template Navigation Basics

    These lessons present an overview of how to navigate templates in the BI360 Report Designer.

  • Training Demo Data Overview
  • Create New Template
  • Preview
    Excel Add-in Overview
  • Report Designer Pane
  • Layout Editor
  • Template Ownership
  • Printing Reports
  • Field Mapping
  • Quiz - Template Navigation
  • Working with Rows

    These lessons cover functionality used to create  account groupings and filters on rows that are commonly found in financial reports, such as trial balances and income statements.

  • Introduction to Accounts & Filters
  • Multiple Dimensions
  • Accounting Format Expanding Groups
  • Sum Formulas
  • Quiz - Working with Rows
  • Working with Columns

    These lessons  introduce how  column contents can be managed by the addition of period functions and dimension filters in order to create reports such as actual vs. budget and departments side-by-side.

  • Time-based Columns
  • Dimensions in Columns
  • Columns Recap
  • Quiz - Column Concepts
  • Working with Sheet Filters & Parameters

    These lessons cover Sheet Filters and run time selections known as Report Parameters.

  • Sheet Filters & Parameters
  • Parameter Wizard
  • Summary Worksheet Parameter
  • Quiz - Sheet Filters, Parameters, and the Parameter Wizard
  • Working with Dates

    These lessons  explore the Period dimension and its use in templates.

  • Date Display
  • Period Calculation Functions
  • Quiz - Working with Dates
  • Demo Report Templates

    These lessons deconstruct common financial reports and break down the key design elements of their related Report Designer templates.

  • Demo Templates Overview
  • Trial Balance Monthly Delta
  • Consolidating Trial Balance
  • Profit & Loss Actual vs Budget
  • Profit & Loss Act vs Bud - Departmental Expense
  • Profit & Loss Act vs Bud Department "Sheet per Value"
  • Profit & Loss Act vs Bud with Summary Sheet
  • Side-by-side Departmental Expenses

About this course

This course includes a variety of report design lessons, grouped together by topic. At the end of each topic there is a quiz, allowing you to evaluate your knowledge.

NOTE: This course is applicable to users of both Solver Cloud/version 5 and BI360 version 4. Effective January  & July 2021, users of Solver see a new user interface (UI) with some updated terminology. Documents within this course are in the process of being updated to the new UI, however, video content is based on the previous display. 

Posted 12/17, Revised 3/23

Curriculum~ 60 minutes

  • Preview
    Quick Look: Report Designer
  • Template Navigation Basics

    These lessons present an overview of how to navigate templates in the BI360 Report Designer.

  • Training Demo Data Overview
  • Create New Template
  • Preview
    Excel Add-in Overview
  • Report Designer Pane
  • Layout Editor
  • Template Ownership
  • Printing Reports
  • Field Mapping
  • Quiz - Template Navigation
  • Working with Rows

    These lessons cover functionality used to create  account groupings and filters on rows that are commonly found in financial reports, such as trial balances and income statements.

  • Introduction to Accounts & Filters
  • Multiple Dimensions
  • Accounting Format Expanding Groups
  • Sum Formulas
  • Quiz - Working with Rows
  • Working with Columns

    These lessons  introduce how  column contents can be managed by the addition of period functions and dimension filters in order to create reports such as actual vs. budget and departments side-by-side.

  • Time-based Columns
  • Dimensions in Columns
  • Columns Recap
  • Quiz - Column Concepts
  • Working with Sheet Filters & Parameters

    These lessons cover Sheet Filters and run time selections known as Report Parameters.

  • Sheet Filters & Parameters
  • Parameter Wizard
  • Summary Worksheet Parameter
  • Quiz - Sheet Filters, Parameters, and the Parameter Wizard
  • Working with Dates

    These lessons  explore the Period dimension and its use in templates.

  • Date Display
  • Period Calculation Functions
  • Quiz - Working with Dates
  • Demo Report Templates

    These lessons deconstruct common financial reports and break down the key design elements of their related Report Designer templates.

  • Demo Templates Overview
  • Trial Balance Monthly Delta
  • Consolidating Trial Balance
  • Profit & Loss Actual vs Budget
  • Profit & Loss Act vs Bud - Departmental Expense
  • Profit & Loss Act vs Bud Department "Sheet per Value"
  • Profit & Loss Act vs Bud with Summary Sheet
  • Side-by-side Departmental Expenses