Course details
Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This course will guide participants through all of the features available from the product, allowing them to build sophisticated database requests and to format resulting answers.
Prerequisites:
No specific prerequisite courses are required. A general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites.
DATABASES & DATA MODELS:
- ABOUT DATABASE TECHNOLOGIES
- LOGICAL DATA MODELS
- PHYSICAL DATA MODELS
DATA WAREHOUSING & BI:
- TRANSACTIONAL DATABASES
- WAREHOUSE DATABASES
- WAREHOUSE MODELS & SCHEMAS
- ABOUT BUSINESS INTELLIGENCE
- OLAP, BI, DSS
INTRODUCTION TO ORACLE BI ANSWERS & DASHBOARDS:
- ORACLE BI ARCHITECTURE
- LAUNCH BI PRESENTATION SERVICES
- LOG ON
- BASIC NAVIGATION
USING A DASHBOARD :
- UNDERSTANDING THE DASHBOARD INTERFACE
- VIEWING THE REQUEST RESULTS
- USING PROMPTS TO FILTER DATA
- SAVING & REUSING FILTER SETTINGS
- MANAGING THE VIEW OF THE DASHBOARD PAGE
- VIEWING SUPPLEMENTARY CONTENT
- MISCELLANEOUS TASKS
BUILDING A DASHBOARD:
- CREATING A DASHBOARD
- UNDERSTANDING THE DASHBOARD STRUCTURE
- USING THE DASHBOARD EDITOR
- MANAGING SAVED CONTENT
- MANAGING DASHBOARD OBJECTS
CREATING A REPORT:
- NAVIGATING THE ANSWERS INTERFACE
- CREATING A NEW REQUEST
- ADDING COLUMNS TO A REQUEST
- PREVIEWING THE ANSWERS
- CONTROLLING THE REPORT DEFINITION
- DOWNLOADING THE ANSWERS
REPORT FORMATTING:
- REPORT ATTRIBUTES
- SORTING DATA
- FILTERING DATA
- REUSING FILTERS
- PROMPTS
COLUMN FORMATTING:
- COLUMN FORMATTING
- COLUMN FORMULAS
USING PRIMARY VIEWS :
- ABOUT VIEWS
- CUSTOMIZING THE TABLE VIEW
- CHART VIEW
- GAUGE VIEW
- FILTERS VIEW
- MANAGING THE VIEWS
USING SECONDARY VIEWS:
- COLUMN SELECTOR VIEW
- VIEW SELECTOR VIEW
- TICKER VIEW
- LEGEND VIEW
- NARRATIVE VIEW
- NO RESULTS VIEW
USING PIVOT TABLE VIEWS:
- PIVOT TABLE CONCEPTS
- A PIVOTING SCENARIO
- DEFINING THE PIVOT VIEW
- SECTIONS & PAGES
- TOTALS WITHIN PIVOT TABLES
ADVANCED FORMATTING :
- SET OPERATIONS
- PDF & PRINT CONTROL
- VIEW XML & SQL CALLS
ADMINISTERING THE PRESENTATION CATALOG:
- ACCESSING THE PRESENTATION CATALOG
- BI & PRESENTATION CATALOG SECURITY
- MANAGING PRESENTATION CATALOG OBJECTS
DEPLOYING REQUESTS TO DASHBOARDS :
- VARIABLE REFERENCES
- USING DASHBOARD PROMPTS
- PREPARING OBJECTS FOR DASHBOARD DEPLOYMENT
Course Location
About Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd courses Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Oracle starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Programmer - CPD Certified Apex LearningEUR 165Duration: Upto 165 Hours
- EUR 11Duration: Upto 3 Hours
