This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
What you'll learn?
- You will learn how to create Brochures, Certifications and Templates by using Pixel Perfect Reports
- You will learn how to create Reports by different types of charts
- Manage the Weblogic server and users
- Overview about Oracle Analytics Server OAS and their products (DV, Analytics and xmlpserver)
Course Overview
If you are looking for a simple Business Intelligence tool to present your data then come to the right place
In this course you will learn how to create pixel prefect report, certificates and brochures
We will start diving from scratch to the advanced topics
The journey will begin with Introduction to BI Publisher,
Architecture,
Login to Oracle Analytics server ,
Build your data model,
Blending your data from two different data sources
Use group functions
Create reports with different chart types
Build your template by using Microsoft word
Create style template
Schedule report jobs
Localization
Create OBIEE Dashboards
Administrating BI Publisher by Stop and start Oracle analytics server
Login to Console and create Users
Login to EM and assign roles to the users
So are you ready
Then sign up today to access presentation, queries and resources and sample questions for Oracle Cloud Platform Enterprise Analytics 2021
And full support
Training Agenda:
• Introduction to BI publisher
• Login to Oracle Analytics Server including DV, OBIEE and BI Publisher
• Define Data source
• Create data models by using SQL Query and Query Builder
• Create BI Publisher reports using report builder
• Building an RTF Template in online and offline mode
• Create a Style Template
• Configure Delivery Options
• Schedule Reports Jobs
• Translate or BI Publisher Localization
• Creating OBIEE Dashboards and adding BI Publisher reports to Dashboard Pages
• Managing BI Publisher Objects
• Administrating BI Publisher
Pre-requisites
- Basic knowledge of Oracle SQL
Target Audience
- Anyone want to learn a simple Business Intelligence tool
Curriculum 51 Lectures 08:31:52
-
Section 1 : Introduction
- Lecture 2 :
- BI Publisher Overview
-
Section 2 : Complete Steps to Install and Configure Oracle Analytics Server OAS 6.4
- Lecture 1 :
- Installation of a supported Java Development
- Lecture 2 :
- Set JAVA_HOME Environment Parameter
- Lecture 3 :
- Installation of Fusion Middleware Infrastructure
- Lecture 4 :
- Installation of the OAS binaries
- Lecture 5 :
- RCU (Repository Creation Utility)
- Lecture 6 :
- Configuration of OAS into Weblogic Domain
- Lecture 7 :
- Installing Oracle BI Administration Tool and open RPD on online and offline mode
-
Section 3 : Build your data model
- Lecture 1 :
- Create Data Sources
- Lecture 2 :
- Create Data model by SQL Query – Writing SQL Query
- Lecture 3 :
- Parameters List of Values LOV
- Lecture 4 :
- Refresh other parameters on change
- Lecture 5 :
- Create Data model by SQL Query - Query Builder
- Lecture 6 :
- Create Data model with Aggregation function
- Lecture 7 :
- Create Data model by using flat file and Blend your data
-
Section 4 : Create BI Publisher Reports
- Lecture 1 :
- Create Report Using report builder
- Lecture 2 :
- Create Report using Report Editor
- Lecture 3 :
- BI Publisher is an Interactive report
- Lecture 4 :
- Component’s Properties
-
Section 5 : Building an RTF Template
- Lecture 1 :
- Building an RTF Template By using Microsoft Office
- Lecture 2 :
- Building an RTF Template - Online mode
- Lecture 3 :
- Building an RTF Template - Offline mode
- Lecture 4 :
- Configuring Delivery Options
- Lecture 5 :
- Create style template
-
Section 6 : Schedule Report Jobs and Localization
- Lecture 1 :
- Schedule Report Jobs
- Lecture 2 :
- Translate or Localization
-
Section 7 : Creating Oracle BI Repository (RPD)
- Lecture 1 :
- Creating New Database and Connection Pool
- Lecture 2 :
- Oracle BI Metadata Repository (RPD) Features
- Lecture 3 :
- Data Source Name configuration
- Lecture 4 :
- Create A New Business Model and Mapping
- Lecture 5 :
- Merge detailed dimensions into a single dimension
- Lecture 6 :
- How to create Measures
- Lecture 7 :
- Presentation Layer – Create a new Subject Area
- Lecture 8 :
- How to upload RPD
- Lecture 9 :
- How to Create BI Publisher reports using Subject Area
- Lecture 10 :
- Dimension Hierarchies
- Lecture 11 :
- How to create Time Dimension
- Lecture 12 :
- Logical Column – Sort Order
- Lecture 13 :
- Skipped & Ragged Hierarchies
-
Section 8 : Creating Oracle Analytics reports using Subject Area
- Lecture 1 :
- How to create Oracle Analytics reports using subject area
- Lecture 2 :
- Edit Oracle Analytics Report Details - Part 1
- Lecture 3 :
- Edit Oracle Analytics Report Details - Part 2
- Lecture 4 :
- Edit Oracle Analytics Report Details - Part 3
- Lecture 5 :
- Creating Oracle Analytics reports based on Orders Subject Area
- Lecture 6 :
- Creating Oracle Analytics reports based on Orders_Items Subject Area
- Lecture 7 :
- Creating Oracle Analytics reports based on Inventories Subject Area
-
Section 9 : Dashboards Managing Objects
- Lecture 1 :
- Create Dashboards
- Lecture 2 :
- Managing BI Publisher Objects
-
Section 10 : Administrating Oracle Analytics Server
- Lecture 1 :
- Start and Stop server and add users
-
Section 11 : Practice Tests
- Lecture 1 :
- BI Publisher Questions
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion. -
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
1458 Course Views
1 Courses