Oracle Analytics Server (OAS): Analytics Classic Course

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 up
Explore more advanced features like data modeling, creating RPDs, and building detailed reports and dashboards
See how Oracle Analytics Server can be used in real-world situations to help your organization make better decisions based on data
Work through exercises and labs to apply what you've learned and build your confidence
Understand how to migrate between different environments using BAR files and follow best practices to ensure everything runs smoothly

Requirements
Basic knowledge of Oracle SQL and Data Warehousing

Description
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

Who this course is for:
This course is ideal for anyone who wants to learn a straightforward and powerful Analytics tool