Data Warehousing

Indian Institute of Bright Careers
In Bangalore

Rs 1
VAT incl.
Compare this course with other similar courses
See all

Important information

  • Course
  • Bangalore
  • Duration:
    60 Days

Important information

Where and when

Starts Location
On request
39,40, 1st Floor, Above Reliance Fresh, Ramaiah College Bus Stop, HMT Main Road, Mathikere, , 560054, Karnataka, India
See map

Course programme

Course Content

Database Run through

Data definition language, Data Manipulation Language,, DTL statements
Writing fundamental SQL SELECT Statement
Get rid of Duplicate Rows
Restricting in addition to Sorting Data
Joins: inner join, outer join, self join, natural join

Introduction to Data Warehousing

Differences flanked by Transactional in addition to Warehoused Data
Data Warehouse structural design
Logical and Physical plan
Difference flanked by Data Warehouse & Data Mart
Source Data, Staging Data & Target Data

Database Design in addition to Modeling

Conversion of Logical Model into corporal representation
Application of Business system
Constraints, Triggers, Domains, Backend Programs, etc.
Dimensional Model for Data storehouse
Defining Dimensions and actions
Defining Levers as well as Hierarchies
Granularity of information
Introducing Star Flake plan
Introducing Snow Flake diagram
Dimension Table and Fact table

Business Objects XI R2

Administrating the Users furthermore Groups
Administrating the Servers
Access rights
Designing the world
Central Configuration Manager
Accessing the Info view

OLAP & Presentation using Business Objects

Creating in addition to Maintaining Universe
Formatting information
Slicing & Dicing Reports
DrillDown, Drillup Reports


• Data Staging Area
• Facts & Dimensions
• Data warehouse and Latency
• Data Integration
Repository Topics
• Repository Server and agent
• Repository maintenance
• Repository Server Administration Console
• Security, Repository, privileges and folder permissions
• Objects sharing, searching, and locking
• Metadata extensions

Compare this course with other similar courses
See all