VersionOne Enterprise Agile Platform

Overview

Custom Agile Reporting with the VersionOne DataMart

Course Information

Who Should Attend

Technical Analysts, DBAs, Reporting Tool SMEs

Duration

One Day

Where

Your Location

Three day minimum for onsite training. Up to 25 students can attend this course.

Overview

Custom Agile Reporting with the VersionOne Data Mart is designed to get attendees up and running quickly with the VersionOne data mart. This one day class introduces participants to the data mart structure and installation procedures. All participants will gain hands-on experience writing queries against the data mart to produce custom reports in Excel, as well as hands-on assistance configuring and installing your custom data mart. This engagement also includes collaborative identification of reporting requirements and custom report definition.

Detailed Course Guide

Overview

  • Schema Definition and Benefits – Facts, Dimensions and Bridges
  • SQL Crash Course
  • Domain Structure Defined

Set Up and Configuration

  • Software Installation
  • Query Writing (Common Joins Exercises)
  • ETL Configuration with Custom Fields
  • Sample Excel-based Reports
  • Scheduling
  • Custom Field Configuration

Client Reporting Tools

  • Report Definition – Requirements and Data Identification
  • Report Creation – Building Custom Reports within Client€™s Reporting Tool