IT / Data Warehousing / Oracle / Oracle 19c / Oracle BI Discoverer / Analyzing Relational and OLAP Data
| ID | 2757914 |
|---|---|
| Classroom | 2 days 9:00-16:30 |
| Webinar | 4 days 9:00-12:30 |
| Method | Presentation with examples and hands-on labs. |
| Prequisite | Oracle SQL, PL / SQL |
| Audience | Business Intelligence Developer |
Oracle Business Intelligence Discoverer is an intuitive ad-hoc query, reporting, analysis and Web publishing tool set that gives business users immediate access to information in databases. Oracle BI Discoverer enables business users at all levels of the organization to make faster and more informed business decisions. Using any standard Web browser, you have secure and immediate access to data from both relational and multidimensional data sources. The Oracle BI Spreadsheet Add-In enables end users to display and navigate Oracle OLAP data from within Excel. Users can treat the Oracle OLAP data as regular Excel data. Using a wizard-driven interface, users can select data from Oracle OLAP simply by choosing from a list of values or by creating advanced selections, such as those based on exceptions, top/bottom analysis, or hierarchies.
Workbook and Worksheets - Queries - Tables and Cross-Tabs - Page Elements (Header and Footer, Title, Formatting Columns, Graphics) - Sorting and Grouping of Results - Aggregations
Types of Diagrams - Reports and Diagrams
Conditions and Conditional Formatting - OLAP Operations: Pivoting, Drilling, and Slicing/Dicing - Static and Dynamic Parameters - Calculations - Advanced Analysis
Scheduling Manager - Running Reports in Batch Mode - Managing Workbooks, Publishing and Exporting Reports
Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.
He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
