Paid Courses

Ad-hoc Reporting (AHR)


Description
This is a Standard Course. See Course Types for more details about how to book a Standard Course.


Participants will be taken through an overview of the ContrOCC database and shown how to create a query using their specific reporting tool, such as MS Access, Business Objects Universe, MS Power BI or SSRS. This course includes a workshop session.

Objectives
By the end of the course, participants will:
• Understand the ContrOCC database structure, including tables, views, and quick views
• Understand key query building concepts, including how to join data together, parameters and filters
• Complete a workshop building a pre-agreed query

Who is it for?
• Users with basic ContrOCC experience
• Local authority reporting teams

Outcomes & benefits
By the end of this course, participants will be able to:
• Create ad-hoc reports for the local authority

Prerequisites
• Basic knowledge of ContrOCC

Product: ContrOCC Level: Advanced Type: Standard Duration: 1 Day

Content
  • Section 1 - Databases
  • The ContrOCC Database
  • The Datamart
  • MS Access
  • Business Objects
  • Power BI / SSRS
  • Section 2 - Building Queries
  • Building Queries
  • Section 3
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever