Three day minimum for onsite training. Up to 25 students can attend this course.
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
- 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
- Custom Field Configuration
Client Reporting Tools
- Report Definition – Requirements and Data Identification
- Report Creation – Building Custom Reports within Clients Reporting Tool