Oracle Analytics Server (OAS): Analytics Classic Course

Übersicht

Oracle Analytics Classic:

Upgraded Version of OBIEE for Oracle Analytics Cloud (OAC) and Oracle Analytics Server (OAS) What you'll learn:

Learn the basics of Oracle Analytics Server, including how to install and set it upExplore more advanced features like data modeling, creating RPDs, and building detailed reports and dashboardsSee how Oracle Analytics Server can be used in real-world situations to help your organization make better decisions based on dataWork through exercises and labs to apply what you've learned and build your confidenceUnderstand how to migrate between different environments using BAR files and follow best practices to ensure everything runs smoothly If you are looking for a simple Analytics tool to present your data then come to the right place.Learn how to make the most of Oracle Analytics Server with this easy-to-follow course, "Oracle Analytics Server:

Analytics Classic." Whether you're new to Oracle or have some experience, this course will guide you through everything you need to know to use Oracle Analytics Server effectively.In this course, you will:

Get Started:

Learn the basics of Oracle Analytics Server, including how to install and set it up.Go Deeper:

Explore more advanced features like data modeling, creating RPDs, and building detailed reports and dashboards.Practical Skills:

See how Oracle Analytics Server can be used in real-world situations to help your organization make better decisions based on data.Hands-On Practice:

Work through exercises and labs to apply what you've learned and build your confidence.Smooth Transitions:

Understand how to migrate between different environments using BAR files and follow best practices to ensure everything runs smoothly.By the end of this course, you'll have the skills you need to use Oracle Analytics Server in your day-to-day work, helping you to analyze data, create reports, and make informed decisions.This course is perfect whether you're looking to learn from scratch or want to build on what you already know. Join today and start your journey to becoming an Oracle Analytics Server professional.Training Agenda:

Introduction to Oracle Analytics ClassicCreating Users and TablesExploring the Data ModelOracle BI Repository RPD online and offline modeCreating New Database and Connection PoolCreate A New Business Model and MappingMerge detailed dimensions into a single dimensionCreate Alias in Physical LayerHow to create MeasuresRename Measures Dimensions and logical namesMerge detailed dimensions into a single dimensionUpload RPD if you work in offline modeLevel based HierarchyHow to create Logical Dimension Time HierarchyResolve the sorting issue with the Month namesSkipped and Ragged HierarchiesLogin to Oracle AnalyticsOracle Analytics AdministrationCreate An analysis stepsDescription of the Create Analysis SectionsTitle and TablePivot TablePie ChartBar ChartBar Chart HorizontalBar Chart StackedArea ChartLine ChartLine-BarPerformance TileTree MapHeat MatrixView SelectorsSelection StepsGaugeNarrativeCombine ResultsCreate analyses that combine subject areas using common dimensionsShow Percentage of Row or Column in Pivot TableInternal FilterMaster Detail LinkingSequence NumberCase Statement in Column FormulaCase Statement in Oracle AdministrationTimeStampDiff FunctionCreating a Hierarchy for CountryModify Data Types of Columns in the RPD Physical LayerCreating Performance Tiles by using Internal filterDashboards in Oracle AnalyticsCreation Finance Dashboard and Adding Content to Dashboard PagesCreation Internet Sales Dashboard and Adding Content to Dashboard PagesInline and Dashboard PromptsHow to Remove NULL from RPD Showing in Dashboard PromptsCreating Inline FiltersThe Scope of a Dashboard PromptCreate a Dashboard Prompt Using a SQL StatementCreate a Dashboard PromptSave the inline filter as a named filterCreating Named FiltersDivide the Analysis into Two Separate AnalysesReport Links LevelsCreate Home page and Landing pagesFormat with HTML TagsManaging Security for OAS - Creating Users and GroupsManaging Security for OAS - Creating Application RolesManaging Security for OAS - Report and Dashboard AccessManaging Security for OAS - Assign users to Roles or Dashboard directly without GroupPractical example for Users and Groups and Application RolesProtect filter and Convert the filter to SQL statementsAnalysis XML and Subject AreaConfigure the Oracle Analytics Server Logout URL to Redirect Back To Oracle Analytics URLPresentation Variables Column PromptVariable PromptNamed Conditions and Inline ConditionsDynamic Portal Path or Home pageRow-Level SecurityServer MigrationsAdvanced Topics

Lehrplan

• Introduction to Oracle Analytics Server (OAS)
Overview of Oracle Analytics infrastructure
Key features and capabilities of OAS
Installation and setup basics
• Data Source Connection and Management
Connecting to various data sources
Managing data models
Data preparation and cleansing techniques
• Building Data Visualizations
Creating and customizing reports
Designing interactive dashboards
Data visualization best practices
• Advanced Analytics Features
Utilizing built-in analytical functions
Implementing predictive analytics tools
Integrating machine learning models
• Security and User Management
Managing user roles and permissions
Data security protocols and practices
Auditing and monitoring usage
• Deployment and Maintenance
Best practices for deployment in enterprise environments
OAS performance tuning and optimization
Regular maintenance and troubleshooting
• Case Studies and Practical Applications
Real-world use cases of OAS in business
Hands-on labs and exercises
Evaluation and feedback on created dashboards
• Course Review and Assessment
Summary of key concepts
Final project presentation
Course assessment and feedback mechanisms

---

Unterrichtet von

Mohammed Abdelkarim

---

Fachgebiete

Business