Data Warehouse

Demo 1

• Lecture1.1
  OBIEE 12C Product Tour 01 hour
• Quiz1.1
  Quiz on Product Tour 3 questions

Data Warehouse concepts 1

• Lecture2.1
  Transnational Data Vs Analytical Data 01 hour 20 min
• Quiz2.1
  Quiz on Transnational Data 5 questions
• Lecture2.2
  OLTP vs OLAP 01 hour
• Lecture2.3
  Star Schema Vs Snow Flake Schema 01 hour 30 min

OBIEE 12C Installation Direct (Optional) 0

• Lecture3.1
  OBIEE 12C Direct Installation 01 hour 30 min

OBIEE 12C VM Installation 1

• Lecture4.1
  OBIEE 12C VM Installation 30 min

Level 01 :Practitioner Level Training Part 01 of 04 4

Createing Physical ,BMM and Presentaion Layers

• Lecture5.1
  Handson 1: Physical Layer Part 01 of 04 01 hour 10 min
• Lecture5.2
  Handson 1: Physical Layer Part 02 of 04 01 hour
• Lecture5.3
  Handson 1: Physical Layer Part 03 of 04 01 hour 02 min
• Lecture5.4
  Handson 1: Physical Layer Part 04 of 04 01 hour
• Lecture5.5
  Handson 2: BMM Layer 01 hour 10 min
• Lecture5.6
  Handson 3: Presentation Layer 01 hour

Level 01 : Practitioner Level Training Part 02 of 04 3

End of this section you will learn testing rpd all three layers ,OBIEE 12C architecture ,Debugging report using log level,ofline vs online .. .etc

• Lecture6.1
  OBIEE 12C Tutorial Part 10 Testing RPD 01 hour 50 min
• Lecture6.2
  OBIEE 12C Architecture 30 min
• Lecture6.3
  OBIEE 12C Tutorial Part 12 Upload RPD into OBIS 01 hour 06 min

Level 01 : Practitioner Level Training Part 03 of 04 2

Learn how to load RPD in case of 11G

• Lecture7.1
  OBIEE 12C Tutorial Part 13 Upload RPD into OBIS in OBIEE 11G Part 01 01 hour 40 min
• Lecture7.2
  OBIEE 12C Tutorial Part 14 Upload RPD into OBIS in OBIEE 11G Part 02 01 hour 20 min

Level 01 : Practitioner Level Training Part 04 of 04 6

You will learn Working with multiple physical tables inside LTS ,calculations and Level based hierarchies

• Lecture8.1
  OBIEE 12C Tutorial Part 15 Modify RPD Online Mode and Adding Multiple Physical Tables to LTS 01 hour 40 min
• Quiz8.1
  Quiz on Hierarchy 1 question
• Lecture8.2
  OBIEE 12C Tutorial Part 16 Calculations Part 1 01 hour 30 min
• Lecture8.3
  OBIEE 12C Tutorial Part 17 Calculations Part 2 01 hour 30 min
• Lecture8.4
  OBIEE 12C Tutorial Part 18 Level Based Hierarchies Part 1 01 hour 30 min
• Lecture8.5
  OBIEE 12C Tutorial Part 19 Level Based Hierarchies Part 2 01 hour 30 min
• Lecture8.6
  OBIEE 12C Tutorial Part 20 Level Based Measures 01 hour 30 min

Level 02 : Lerner Level Training Part 01 of 04 1

Creating Catalog in 12C and 11G

• Lecture9.1
  OBIEE 12C Tutorial Part 21 Creating Catalog 01 hour 30 min

Level 02 : Lerner Level Training Part 02 of 04 8

Create different types of reports

• Lecture10.1
  OBIEE 12C Tutorial Part 22 Column Properties 01 hour 30 min
• Lecture10.2
  OBIEE 12C Tutorial Part 23 Filters Part 1 01 hour 30 min
• Lecture10.3
  OBIEE 12C Tutorial Part 24 Filters Column Prompt Part 2 01 hour 30 min
• Lecture10.4
  OBIEE 12C Tutorial Part 25 Image and Variable Prompt and Set Operators 01 hour 30 min
• Lecture10.5
  OBIEE 12C Tutorial Part 26 Direct Database Request 01 hour 30 min
• Lecture10.6
  OBIEE 12C Tutorial Part 27 Views Part 1 01 hour 30 min
• Lecture10.7
  OBIEE 12C Tutorial Part 28 Views Part 2 01 hour 30 min
• Lecture10.8
  OBIEE 12C Tutorial Part 29 Views Part 3 01 hour 30 min

Level 02 : Lerner Level Training Part 03 of 04 2

Creating Dashboards ,Dashboard Prompts and using dashboard objects

• Lecture11.1
  OBIEE 12C Tutorial Part 30 Dashboards and Dashboard Prompts 01 hour 30 min
• Lecture11.2
  OBIEE 12C Tutorial Part 31 Dashboards Objects 01 hour 30 min

Level 02 : Lerner Level Training Part 04 of 04 1

Scheduling Reports and dashboard pages

• Lecture12.1
  OBIEE 12C Tutorial Part 32 Oracle BI Delivers and Agents 01 hour 30 min

Level 03 : Specialist Level Training 23

• Lecture13.1
  OBIEE 12C Tutorial Part 33 Aggregate Tables for Performance Tuning 01 hour 30 min
• Lecture13.2
  OBIEE 12C Tutorial Part 34 Partition Tables for Performance Tuning 01 hour 30 min
• Lecture13.3
  OBIEE 12C Tutorial Part 35 Repository Varaibles Part 1 01 hour 40 min
• Lecture13.4
  OBIEE 12C Tutorial Part 36 Repository Varaibles Part 2 01 hour 30 min
• Lecture13.5
  OBIEE 12C Tutorial Part 37 Session System Variables 01 hour 30 min
• Lecture13.6
  OBIEE 12C Tutorial Part 38 Session System and Non System Variables (Data Security) 01 hour 30 min
• Lecture13.7
  OBIEE 12C Tutorial Part 39 Row Wise Initilization Blocks 01 hour 30 min
• Lecture13.8
  OBIEE 12C Tutorial Part 40 Request Variables 01 hour 30 min
• Quiz13.1
  Quiz on Variables 3 questions
• Lecture13.9
  OBIEE 12C Tutorial Part 41 Modeling Time Series Data 01 hour 30 min
• Lecture13.10
  OBIEE 12C Tutorial Part 42 Security Part1 01 hour 30 min
• Lecture13.11
  OBIEE 12C Tutorial Part 43 Security Part2 01 hour 30 min
• Lecture13.12
  OBIEE 12C Tutorial Part 44 Security Part3 01 hour 30 min
• Lecture13.13
  OBIEE 12C Tutorial Part 45 Security Part4 01 hour 30 min
• Lecture13.14
  OBIEE 12C Tutorial Part 46 Security Part5 01 hour 30 min
• Lecture13.15
  OBIEE 12C Tutorial Part 47 Security Part6 01 hour 30 min
• Lecture13.16
  OBIEE 12C Tutorial Part 48 Security Part7 01 hour 30 min
• Lecture13.17
  OBIEE 12C Tutorial Part 49 Cache Managment1 01 hour 30 min
• Lecture13.18
  OBIEE 12C Tutorial Part 49 Cache Managment2 01 hour 30 min
• Lecture13.19
  OBIEE 12C Tutorial Part 50 MUDE 01 hour 30 min
• Lecture13.20
  OBIEE 12C Tutorial Part 51 Usage Tracking 01 hour 30 min
• Lecture13.21
  OBIEE 12C Tutorial Part 52 Opaque View and Working with Database Function 01 hour 30 min
• Lecture13.22
  OBIEE 12C Tutorial Part 53 Alias 01 hour 30 min

Level 04 : Advanced Level Training 11

• Lecture14.1
  OBIEE 12C Tutorial Part 54 Parent Child Hierarchy 01 hour 30 min
• Lecture14.2
  OBIEE 12C Tutorial Part 55 Ragged and Skipped Hierarchy 01 hour 30 min
• Lecture14.3
  OBIEE 12C Tutorial Part 56 Deployment 01 hour 30 min
• Lecture14.4
  OBIEE 12C Tutorial Part 57 Catalog Manager 01 hour 30 min
• Lecture14.5
  OBIEE 12C Tutorial Part 58 Action Links 01 hour 30 min
• Lecture14.6
  OBIEE 12C Tutorial Part 59 Master Detail Reports Parent Child Hierarchy 01 hour 30 min
• Lecture14.7
  OBIEE 12C Tutorial Part 60 ID Column 01 hour 30 min
• Lecture14.8
  OBIEE 12C Tutorial Part 61 KPI KPI WATCH LIST SCORECARD 01 hour 30 min
• Lecture14.9
  OBIEE 12C Tutorial Part 62 BI PUBLISHER PART 1 01 hour 30 min
• Lecture14.10
  OBIEE 12C Tutorial Part 63 BI PUBLISHER PART 2 01 hour 30 min
• Lecture14.11
  OBIEE 12C Tutorial Part 64 BI PUBLISHER PART 3 01 hour 30 min