Loader
Mitratech - Connecting People, Knowledge, Process Connecting People, Knowledge, Process
Home » Solutions » Services » Mitratech University » Courses Solutions:

Mitratech University

Mitratech University provides end users, administrators and developers continuing education for sound practices and discipline in Collaborative Accountability for high-liability enterprise processes.

TeamConnect Data Warehouse Reporting

This course provides in-depth knowledge of how to install, configure, and maintain the TeamConnect Data Warehouse for creating TeamConnect reports. The Data Warehouse ERD schema is covered to understand how to design reports. If you are using BusinessObjects (BO) Web Intelligence to generate reports against the Data Warehouse, this course provides information necessary for customizing the TeamConnect BO Universe.

Course Name:
TeamConnect Data Warehouse Reporting

Audience:
Developer, Admin, Business Objects Designer

Duration:
1/2 Day

Format:
80% Lecture; 20% Lab

Type:
Instructor-led training

Who Should Attend:

TeamConnect report developers and BO report creators.

Skill Level:
Intermediate

Available Locations:
Private Location, Online Course Delivery, Client Location

Skills Obtained:

After this training you should be have a strong understanding of:

  • How to create reports for the Data Warehouse for data analysis;
  • How to create and modify objects in the TeamConnect BO Universe;
  • How to maintain/administer the Data Warehouse.
Prerequisites:

Prior to attending this course you should have:

  • Previous System Administration training;
  • Experience with Structured Query Language (SQL);
  • BO Designer experience.

Course Outline:

Data Warehouse overview

  • Installing and configuring the Data Warehouse
  • How changes in TeamConnect affect the Data Warehouse
  • Data Warehouse best practices
  • Data Warehouse Schema Basics
    • System Object tables
    • Custom Object tables
    • Helpful views and tables
    • Relating TeamConnect custom design to Warehouse tables
  • Querying TeamConnect Data Warehouse
    • Joining warehouse tables
    • Using views
    • TeamConnect vs. Data Warehouse queries
       

Register Contact Us