Course Overview

This Oracle BI 11g: Create Analyses & Dashboards course is designed to provide students with a step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. Students will learn the concepts, methods, and techniques for building sophisticated data analytic modules, along with organizing analytic results into interactive dashboards. Students will have a solid foundation in order to progress onto the latest and most advanced data analytic capabilities.

What you’ll learn

Upon completion of the Oracle BI 11g: Create Analyses & Dashboards course, students will be able to:

• Understand the background discussion of data warehousing, business intelligence (BI), and data analytics presented in a form that business professionals can readily understand.
• Explain background concepts regarding logical data models, star schema, and snowflake schema warehouse models.
• Build analytical models using fact tables, dimensions, dimension hierarchies, cubes, measures, and other multidimensional data model objects.
• Use interactive dashboards to analyze data, uncover trends, and make strategic business decisions.
• Export BI results to productivity software such as Microsoft Office or other external systems.
• Design customized dashboards to reflect an individual’s role, perspective, or business interest.
• Create data analyses and dynamically interact with results produced from Oracle BI.
• Form analyses using sorts, filters, and prompts.
• Format column output, subtotaling, customization of column properties, and transforming column data using formulas.
• Create results with compound layouts, including views such as tabular, chart, pivot table, gauge, and others.
• Manage content, permissions, and access within the Presentation Catalog.
• This textbook includes dozens of learning exercises, with detailed point-and-click solutions also provided.