Eğitim Süresi: 4 Gün

Eğitim Ön Koşul: Veritabanı ve SQL (temel düzeyde) 

Eğitim Hedefi:

• Create and modify Business Intelligence requests using Oracle Business Intelligence Answers
• Combine request criteria using set operations and execute direct database requests
• Work with views to display request information
• Create and modify Interactive Dashboards
• Create guided navigation links within Interactive Dashboards
• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards using Perform administrative tasks related to the development and configuration of Interactive Dashboards
• Customize the Oracle BI Presentation Services user interface
• Work with Oracle BI Presentation Services content in Microsoft Office applications
• Build Oracle BI Publisher reports based on Answers requests and BI metadata subject areas
• Integrate Oracle BI Publisher reports in Interactive Dashboards
• Employ recommended design principles and best practices

Eğitim İçeriği:

A - Introduction to Oracle BI (0.5 Gün)

• Understand features and benefits of suite components
• Introduction to administration tool
• Create a simple data model
• Introduction to presentation services
• Create a simple request and dashboard

B - Oracle BI Presentation – Create reports and dashboards (1.5 Gün)

• Create advanced interactive Dashboards
• Share content using Briefing Books
• Ad hoc query and analysis using Answers
• Create tables, charts and pivot tables
• Create filters, column prompts, and dashboard prompts
• Add conditional formatting and guided navigation
• Reference session, repository and presentation variables
• Build reports using Publisher and MS Word
• Generate alerts and notifications using Delivers
• Customise the look and feel of the user interface
• Integrate with third party systems and web services
• Implement best practices in Dashboards

C- Oracle BI Modelling – Create models and repositories (2 Gün)

• Create repositories using the Administration Tool
• Build Physical, Business and Presentation layers
• Import schemas from multiple physical data sources
• Design and build logical business models (star schemas)
• Present information to end users in subject areas
• Build dimension hierarchies and aggregate tables
• Build level based and time series measures
• Create session and repository variables
• Implement business rules and calculations
• Modelling 3rd Normal Form
• Model Fragmentation from multiple data sources
• Manage security authentication and authorisation
• Discoverer schema migration using the metadata conversion assistant

Course Outline