Data Modelling for BI Administrators Training Logo

Data Modelling for BI Administrators Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

This Create Pixel Perfect Reports training will help you build a foundation of understanding how to best leverage BI Publisher in Oracle Analytics Cloud.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Data Modelling for BI Administrators Certification Training about?

You'll learn how to create layouts for reports, build data models, work with template builder, schedule reports, perform translations as well as perform some common administration tasks.

What are the objectives of Data Modelling for BI Administrators Certification Training ?

At the end of this Data Modelling for BI Administrators course, you will be able to:


  • Schedule Reports
  • Perform Translations
  • Create Reports
  • Administration tasks
  • Create reports from different data sources
  • Create and Modify Data Models
  • Create RTF Templates by Using Template Builder
  • Create Layouts by Using the Layout Editor

Who is Data Modelling for BI Administrators Certification Training for?

  • Business Analysts
  • Data Modelers
  • End Users
  • Reports Developer

Available Training Modes

Live Online Training

12 Hours

Course Outline Expand All

Expand All

  • Explain Data Modeler and its components
  • Explain Star Relationships and Snowflake Relationships
  • Explain Normalized Sources and Modelling Denormalized Sources
  • Analyze the Workflow of Modeling the Data
  • Launch Data Modeler
  • Create a Data Model
  • Explore Data sources and Create Source Views
  • Manage database connections for a Data Model and Rename a Data Model
  • Describe Dimension and Fact tables
  • Create Fact and Dimension tables from a Single table or view
  • Join Fact and Dimension tables
  • Synchronize the Data Model with source objects in the database
  • Create a Time dimension
  • Validate a Data Model
  • Refresh a Data Model
  • Publish a Data Model
  • Export, Import and Delete a Data Model
  • Build Visualization for model testing
  • Edit Measures and Attributes
  • Specify Aggregation for Measures in Fact Tables
  • Create calculated Measures
  • Create Derived Attributes
  • Create Expressions in the Expression Editor
  • Copy Measures, Attributes and Model Objects
  • Describe Hierarchies and Levels
  • Understand the typical workflow to define Hierarchies and Levels
  • Create Hierarchies
  • Edit Hierarchies and Levels
  • Set Aggregation Levels for Measures
  • Secure a Data Model
  • Create Variables to Use in Expressions
  • Secure Access to Objects in a Model
  • About Secure Access Data
  • Data Modelling Errors and Solutions to handle errors in Data Model
  • General Errors and Solutions to handle the errors

Who is the instructor for this training?

The trainer for this Oracle training has extensive experience in this domain, including years of experience training & mentoring professionals.

Course Logo

Data Modelling for BI Administrators Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews