Oracle Business Intelligence (BI): Create Reports & Interactive Dashboards Professional Training Solutions Ltd
Price: TBA

    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
    Updated on 08 November, 2015

    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. See all courses

    Is this the right course for you?

    Didn't find what you were looking for ?

    or