Our solutions energize digital transformations. Our customers span industries including government, financial, and biotech. We inspire the future by enabling embedded and IoT technologies. We even make software development connect closely to the enterprise with value stream management. Our solutions free organizations to focus on their business challenges.

Learn More

Learn from the masters. As industry leaders in agile, we invite knowledge seekers interested in learning about agile and scrum certification to train with us. We have courses for students, engineers, project managers, and management. From fundamentals to mastery, our experts will teach you what you need to know to apply your new knowledge successfully in your role.

Learn More

At every phase of your agile journey, we guide your teams with a proven methodology for success. Start with us.

We combine the best enterprise agile lifecycle management platform with guidance from transformation experts who have helped many enterprises improve their software development.

Learn More

The CollabNet VersionOne global partner network helps our customers make their software development practices more productive.

Learn More

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