Oracle BI 12c: Create Analyses and Dashboards Ed 2 Course in US
Master Oracle BI tools, analyses and dashboard creation
40 hours of training duration
Detailed learning path through 20 modules
Open doors to in-demand BI roles
Learn from Oracle-certified trainers
Includes hands-on labs and projects
Achieve Oracle BI 12c certification
Flexible learning options for working professionals
Easy instalment plans for stress-free payments
4.9/56369 EnrolledEnrolled Learners
4.9/56369 EnrolledEnrolled Learners
Overview
What our training includes:
- Understand the architecture and core components of Oracle BI 12c
- Build dynamic data analyses using Oracle BI Presentation Services
- Design and format sophisticated visual reports and charts
- Apply filters and custom SQL to refine analysis outcomes
- Develop advanced dashboard prompts for interactive reporting
- Create engaging visualisations, including Trellis charts and Heat Matrix
- Design mobile applications using Oracle BI Mobile App Designer
Upcoming sessions
Curriculum
1
Introduction
1
Explain Oracle Business Intelligence
2
Describe Oracle Business Intelligence Foundation Suite
3
Identify and describe the major components of the Oracle Business Intelligence 12c architecture Part 1
4
Identify and describe the major components of the Oracle Business Intelligence 12c architecture Part 2
5
Describe Oracle Essbase
6
Practice 2-1: Exploring Oracle BI Presentation Services Part 1
7
Practice 2-1: Exploring Oracle BI Presentation Services Part 2
1
Identify the important elements of analyses Part 1
2
Identify the important elements of analyses Part 2
3
Use Analysis Editor
4
Construct, modify, and save analyses by using the three avaliable types of columns Part 1
5
Construct, modify, and save analyses by using the three avaliable types of columns Part 2
6
Construct, modify, and save analyses by using the three avaliable types of columns Part 3
7
Apply advanced formatting to analyses
8
Practice 3-1: Creating and Formatting an Analysis Part 1
9
Practice 3-1: Creating and Formatting an Analysis Part 2
10
Practice 3-1: Creating and Formatting an Analysis Part 3
11
Practice 3-1: Creating and Formatting an Analysis Part 4
12
Practice 3-1: Creating and Formatting an Analysis Part 5
13
Practice 3-1: Creating and Formatting an Analysis Part 6
14
Practice 3-2: Controlling the Display of Columns Added to Analyses
1
Describe the use of filters in limiting the results of analyses
2
Design and Build Filters in Oracle Business Intelligence analyses
3
Use a saved analysis as a filter
4
Edit the SQL for a column filter in an analysis
5
Add filter prompts to an analysis
6
Practice 4-1: Adding Filters to Analyses Part 1
7
Practice 4-1: Adding Filters to Analyses Part 2
8
Practice 4-2: Adding an Inline Prompt to an Analysis
9
Practice 4-3: Using a Saved Analysis as a Filter
10
Practice 4-4: Editing SQL for a Column Filter
1
Create and saving selections Part 1
2
Create and saving selections Part 2
3
Create and saving selections Part 3
4
Create and save groups and calculated items
5
Practice 5-1: Using Selections, Groups, and Calculated Items to Manage Analysis Results Part 1
6
Practice 5-1: Using Selections, Groups, and Calculated Items to Manage Analysis Results Part 2
7
Practice 5-2: Adding Groups and Calculated Items to an Analysis Part 1
8
Practice 5-2: Adding Groups and Calculated Items to an Analysis Part 2
9
Practice 5-3: Including Selected Members Based on Family
1
Add Additional views of the data that is returned
2
Work with Compound Layouts
3
Modify and format views
4
Perform common tasks in views
5
Practice 6-1: Modifying and Formatting Views Part 1
6
Practice 6-1: Modifying and Formatting Views Part 2
7
Practice 6-1: Modifying and Formatting Views Part 3
8
Practice 6-1: Modifying and Formatting Views Part 4
9
Practice 6-1: Modifying and Formatting Views Part 5
10
Practice 6-2: Using the Table View Part 1
11
Practice 6-2: Using the Table View Part 2
1
Create and edit Pivot Tables Part 1
2
Override default aggregations rules in pivot tables
3
Format pivot tables
4
Show relative value of an item in a pivot table
5
Use calculations in a pivot table
6
Display running sums in a pivot table
7
Practice 7-1: Working with Pivot Tables Part 1
8
Practice 7-1: Working with Pivot Tables Part 2
9
Practice 7-2: Displaying Running Sums in Pivot Tables Part 1
10
Practice 7-2: Displaying Running Sums in Pivot Tables Part 2
1
Build a Trellis View
2
Build a Performance Tile View
3
Build a Treemap View
4
Build a Heat Matrix View
5
Use Master-Detail linking in views
6
Practice 8-1: Using the Trellis View Part 1
7
Practice 8-1: Using the Trellis View Part 2
8
Practice 8-2: Creating Performance Tiles
9
Practice 8-3: Creating a Treemap
10
Practice 8-4: Creating a Heat Matrix
11
Practice 8-5: Linking Views Together
1
Visualizing Data on Maps Part 1
2
Visualizing Data on Maps Part 2
3
Practice 9-1: Using Map Views
1
Distinguish between different types of dashboard objects
2
Build a Dashboard Part 1
3
Build a Dashboard Part 2
4
Build a Dashboard Part 3
5
Build a Dashboard Part 4
6
Practice 10-1: Adding Content and Pages to a Dashboard Part 1
7
Practice 10-1: Adding Content and Pages to a Dashboard Part 2
8
Practice 10-1: Adding Content and Pages to a Dashboard Part 3
9
Practice 10-1: Adding Content and Pages to a Dashboard Part 4
1
Add Dashboard Objects
2
Practice 11-1: Embedding Content in a Dashboard
1
Explain the Different Variables types supported by Oracle BI
2
Describe and build dashboard prompts Part 1
3
Describe and build dashboard prompts Part 2
4
Describe and build dashboard prompts Part 3
5
Describe and build dashboard prompts Part 4
6
Describe and build dashboard prompts Part 5
7
Practice 12-1: Create Dashboard Prompts and Variables Part 1
8
Practice 12-1: Create Dashboard Prompts and Variables Part 2
9
Practice 12-1: Create Dashboard Prompts and Variables Part 3
10
Practice 12-1: Create Dashboard Prompts and Variables Part 4
11
Practice 12-1: Create Dashboard Prompts and Variables Part 5
1
Identify the objects and components of Oracle Scorecards and Strategy Management
2
Identify Scorecard Document Types
3
Create a Scorecard and Key Performance Indicators Part 1
4
Create a Scorecard and Key Performance Indicators Part 2
5
Create a Scorecard and Key Performance Indicators Part 3
6
Practice 13-1: Measuring Results with KPIs Part 1
7
Practice 13-1: Measuring Results with KPIs Part 2
8
Practice 13-1: Measuring Results with KPIs Part 3
9
Practice 13-1: Measuring Results with KPIs Part 4
10
Practice 13-2: Building a Scorecard Part 1
11
Practice 13-2: Building a Scorecard Part 2
12
Practice 13-2: Building a Scorecard Part 3
13
Practice 13-2: Building a Scorecard Part 4
14
Practice 13-2: Building a Scorecard Part 5
1
Develop and Visualize reports using Visual Analyzer
2
Explain BI Ask
3
Describe Data Mashup
4
Practice 14-1: Using Visual Analyzer Part 1
5
Practice 14-1: Using Visual Analyzer Part 2
6
Practice 14-1: Using Visual Analyzer Part 3
7
Practice 14-1: Using Visual Analyzer Part 4
8
Practice 14-2: Data Mashup in Visual Analyzer
1
Set up Smart View
2
Work with views in Smart View Clients
3
Copy and paste Oracle BI content inro Microsoft Office
4
Create and publish BI Catalog content from Smart View
5
Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 1
6
Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 2
7
Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 3
8
Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 4
9
Practice 15-1: Working with Oracle BI Views in Smart View Clients Part 5
10
Practice 15-2: Creating and Publishing Views Using the View Designer Part 1
11
Practice 15-2: Creating and Publishing Views Using the View Designer Part 2
1
Use Oracle BI Mobile App Designer to create basic mobile apps and tile pages Part 1
2
Use Oracle BI Mobile App Designer to create basic mobile apps and tile pages Part 2
3
Describe subpages
4
Practice for Lesson 16-1: Creating a Basic Mobile App Part 1
5
Practice for Lesson 16-1: Creating a Basic Mobile App Part 2
6
Practice for Lesson 16-1: Creating a Basic Mobile App Part 3
7
Practice for Lesson 16-1: Creating a Basic Mobile App Part 4
1
Configure Delivery Devices and Delivery Profile
2
Build Alerts
3
Create Agents Part 1
4
Create Agents Part 2
5
Create Agents Part 3
6
Use Conditions
7
Practice 17-1: Creating and Running an Agent
1
Describe the use of roles in administering permissions
2
Administer Oracle Business Intelligence Presentation Catalog permissions Part 1
3
Administer Oracle Business Intelligence Presentation Catalog permissions Part 2
4
Administer system privileges
5
Explain Oracle BI Briefing Books
6
Work with Favorites
7
Practice 18-1: Administering Presentation Catalog Objects and Managing Permissions with Users and Roles Part 1
8
Practice 18-1: Administering Presentation Catalog Objects and Managing Permissions with Users and Roles Part 2
9
Practice 18-2: Working with Oracle BI Briefing Books Part 1
10
Practice 18-2: Working with Oracle BI Briefing Books Part 2
11
Practice 18-3: Working with Favorites
1
Create Direct Database Analyses
2
Edit XML and SQL on the Advanced Tab
3
Practice 19-1: Changing Direct Database Analysis Privileges
4
Practice 19-2: Creating and Executing a Direct Database Analysis
5
Practice 19-3: Modifying XML and SQL
1
SQL Syntax and Semantics
2
Aggregate Functions
3
Time Series Functions
4
Advance Analytics Functions
5
Practice 20-1: Performing Various Aggregate, Running Aggregate, and Time Series Functions Part 1
6
Practice 20-1: Performing Various Aggregate, Running Aggregate, and Time Series Functions Part 2
7
Practice 20-1: Performing Various Aggregate, Running Aggregate, and Time Series Functions Part 3
8
Practice 20-2: Performing Conversion Functions
9
Practice 20-3: Performing Advance Analytics Internal Logical SQL Functions Part 1
10
Practice 20-3: Performing Advance Analytics Internal Logical SQL Functions Part 2
Meet your Trainer
Our Trainers
Learners Point has a reputation for high-quality training that makes a difference in people's lives. We undertake a practical and innovative approach to working closely with businesses to improve their workforce. Our expertise is wide-ranging with ample support from our expert trainers who are globally recognized and hold a diverse set of experiences in their field of expertise. We are proud of our instructors who take ownership of our distinctive and comprehensive training methodologies, help our students imbibe those with ease, and accomplish gracefully.
We at Learners Point believe in encouraging our students to embark upon a journey of lifelong learning and self-development, with the aid of our comprehensive and distinctive courses tailored to current market trends. The manifestation of our career-oriented approach is what we assure through a pleasant professional enriched environment with cutting-edge technology, and an outstanding while highly acknowledged training staff that uses up-to-date methodologies and quality course material. With our aim to mold professionals to be future leaders, our industry expert trainers provide the best in town mentorship to our students while endowing them with the thirst for knowledge and inspiring them to strive for professional and human excellence.
Learning Outcomes
After you complete the course, you will be able to:
1
Master Oracle BI 12c architecture to build robust and effective BI solutions
2
Design engaging and interactive dashboards using Oracle BI Presentation Services
3
Create custom filters and write SQL queries to enhance data analysis accuracy
4
Utilise direct database queries and custom SQL for advanced analytical insights
5
Configure and manage dashboard prompts and variables for seamless user interactivity
6
Develop and maintain scorecards and KPIs to effectively track and evaluate business performance
Learners Point Certificate
Earn a Course Completion Certificate, an official Learners Point credential that confirms that you have successfully completed a course with us.
Prerequisites
To enrol in this Oracle BI 12c: Create Analyses and Dashboards Ed 2 Course in the US, candidates must fulfil these eligibility requirements:
- Basic knowledge of database concepts like tables, relationships, SQL and basic data operations
- Completion of the Oracle BI 12c: Build Repositories Ed 1 course is required
- Familiarity with business analytics principles, including data analysis and reporting methods
- Understanding of web-based and client-server computing environments
Overall ratings by our students
Related courses
Frequently asked questions
The Oracle BI 12c: Create Analyses and Dashboards Ed 2 course in the US teaches professionals how to design interactive dashboards and create advanced data analyses using Oracle BI 12c tools. Key skills include building dynamic reports, integrating with Smart View for Office, developing KPIs and scorecards, and performing direct database queries. The course offers hands-on labs that provide real-world experience, enhancing your ability to derive actionable insights from complex data.
The Oracle BI 12c: Create Analyses and Dashboards Ed 2 training in the US covers advanced features such as creating interactive dashboards, developing KPIs and scorecards, using filters and prompts to refine data analysis, and integrating with Oracle BI tools like Visual Analyser. The course also focuses on direct database analysis, SQL for deeper insights, dashboard management, and configuration techniques.
Oracle BI 12c certification is a highly recognised qualification in the US, particularly in the business intelligence (BI) sector. Oracle's tools offer seamless integration with cloud and on-premise environments, unlike other BI certifications. Oracle BI 12c provides a deeper understanding of data analysis, dashboard design, and advanced reporting techniques, setting it apart from certifications offered by other providers like SAP or Microsoft Power BI. This makes Oracle BI 12c certification highly valuable for professionals looking forward to advancing in the growing BI field in the US.
Oracle BI 12c certification is highly valued in the US job market, particularly in roles that require advanced data analytics skills. Companies across industries seek professionals who can leverage Oracle BI tools to enhance decision-making and operational efficiency. With increasing reliance on data analytics, Oracle-certified professionals are considered valuable assets to regional organisations.
Do you want to learn more about Learners Point Academy?
- Learn more about courses
- Understand about our methodology
- Let’s talk about Corporate trainings
- Anything else that you want to know, we are here for you!
