The Hands-On Training Labs and Deep Dives are back—with fresh new content for the ODTUG Kscope21 Virtual Event. These labs and deep dives are included free of charge with your conference registration. Pre-registration is required as these classes have participant limits. Unfortunately, there are no waiting lists. Don’t miss out—make sure to add them to your registration today! Detailed instructions for adding Hands-on Labs to your conference registration can be found here.

Times shown in EDT.

See below for the class descriptions:

Analytics

Application Express

Database

Emerging Technologies

Enterprise Planning

EPM Foundations & Reporting

Essbase

Financial Close

Modern App Development

Profitability


Analytics:

OAC: Self-Service Data Visualization Hands-On Lab (max. 30 participants)
Tuesday, June 22, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Analytics HOL Room
Brendan Doyle and Nick Engelhardt, Oracle Corporation

Are you a business analyst that's curious about what Oracle Analytics can enable you to do? Join us for an Oracle Analytics Hands-On Lab (HOL)! This Analytics HOL will provide you with the necessary fundamentals to get started with Oracle Analytics Cloud (OAC) and you'll gain a deeper understanding of how to get the most out of your data!

You will learn to self-serve with your data by creating multiple data visualizations and mashing up different data sets. You'll build custom calculations where you will be able to display the results in captivating map visualizations. Additionally, you'll start to become a data storyteller with the creative control of using freeform canvases, custom backgrounds, 1-click statistical analyses, and Natural Language Generation to accelerate your analysis and reporting needs much further!
All you'll need in order to participate in this Hands-On Lab is a stable internet connection, a modern web browser, and an eagerness to learn! Your instructor will provide you the OAC environment, login credentials, and guidance throughout the exercises in this Oracle Analytics Cloud lab!

Build Immediate Business Agility with Oracle ADW + Machine Learning + Analytics Cloud Integration (max. 30 participants)
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Analytics HOL Room
Philippe Lions, Oracle Corporation 

Ever want to have an “algorithm in the cloud” help you make your important decisions? This session will walk you through the entire process;  launching ADW, uploading data, creating an Oracle Machine Learning notebook, exploring the data, building machine learning models, applying the models!   We’ll even review our insights and predictions from the interactive graphing in Oracle Analytics Cloud. Join us to learn some practical and fun Oracle tech tips!

Embed Analytics in Your Daily Decisions with Oracle Analytics Cloud Developer Capabilities (max. 30 participants)
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. | Analytics HOL Room
Mike Durran, Oracle Corporation

You analyze information to help drive new behavior and outcomes, but that's hard if the analysis is disconnected from your day-to-day work. In this session learn how you can easily inject Oracle Analytics into your daily activities and make all your actions data-driven. See how highly visual insights can be embedded into your own custom applications and web pages, in a secure, interactive manner. 

Self-Service Data Preparation Hands-On Lab (max. 30 participants)
Wednesday, June 23, 2021 | 2:20 – 5:00 p.m. | Analytics HOL Room
Tuesday, June 29, 2021 | 11:00 a.m. – 1:40 p.m. | Analytics HOL Room
Luis Rivas, Oracle Corporation

Are you looking to supercharge analysis and streamline your data management with Oracle Analytics Cloud (OAC)? This Hands-On Lab will illustrate how organizations worldwide rely on Oracle to manage their data and uncover value across the entire data lifecycle: creating and joining data, self-service data preparation, visualization and analysis, securely collaborating and sharing analysis across teams, and leveraging embedded augmented analytics and machine learning capabilities to deliver the fastest time to insight across all of your data. You'll learn how to create a connection to an Oracle Database, Create and prepare a dataset for analysis by joining data from multiple database tables. All you'll need in order to participate in this Hands-On Lab is a stable internet connection, a modern web browser, and an eagerness to learn! Your instructor will provide you the OAC and Oracle Database Environments, login and connection credentials, and guidance throughout the exercises in the Oracle Analytics Cloud!


Application Express:

Oracle APEX Spreadsheet Hands-On Lab (max. 50 participants)
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | APEX HOL Room
Oracle presenter TBA

What you will learn:
- Build your first app through uploading a spreadsheet.
- Improve the search and report pages.
- Link pages.

While all of this sounds daunting, you will be amazed at how quickly you go from a spreadsheet to a fully featured, responsive web app.

Proof-of-Concept Hands-On Lab (max. 50 participants)
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | APEX HOL Room
Oracle presenter TBA

What you will learn:
- Define new tables and views.
- Create an application on the new data structures.
- Refine the application.

Who knew creating new database tables could be so easy? And then just as easily, build a great app on top of those tables.

Remote Data Source Hands-On Lab (max. 50 participants)
Wednesday, June 30, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | APEX HOL Room
Oracle presenter TBA

What you will learn:

- Define and populate a table from a REST endpoint.
- Create an application on the new data.
- Refine the application.

Learn how to manipulate data using simple SQL and charts to gain new insights.


Database:

A Two-Step Process for Fraud Detection for Insurance Claims using ADW, OML, APEX and OAC 
Tuesday, June 22, 2021 | 11:00 a.m. - 1:40 p.m. | Database HOL Room
Charlie Berger, CharlieDataMine

This detailed demonstration walks the audience through a multi-step process to tackle anomaly and fraud detection for automobile insurance claims that uses ADW, Oracle Machine Learning, APEX and optionally, Oracle Analytics Cloud. The first step uses Oracle Machine Learning’s “unsupervised learning” algorithms to build predictive models that flag “suspicious claims”. Using an APEX application, our claims investigators can view OML’s suspicious claims and OML’s “explanations” and using their domain knowledge and investigative skills, make determinations about whether a claim is fraudulent or not. They enter their decisions into the APEX app. In a second process step, we use Oracle Machine Learning to build “supervised learning” models that based on the “labeled” data, target the most likely fraudulent claims. We can report on, analyze and investigate our most suspicious claims using APEX and optionally, Oracle Analytics Cloud. OML and APEX are free features of Oracle Databases. Come see how you can realize more value (insights and predictions) from your data.

Analytic Functions HOL (max. 30 participants)
Thursday, June 24, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Database HOL Room
 O-Ace-Director-Icon-rgb.png Kim Berg Hansen, Trivadis

When analytic functions appeared in the database in version 8, they were the best thing to happen to SQL since the keyword SELECT was invented. Analytic functions are indispensable in a lot of use cases for creating highly efficient queries, often enabling you to avoid slow procedural code. Once you have used analytic functions more than a couple of times, you'll develop the mindset for recognizing opportunities for utilizing them often in your daily work, making your applications highly efficient.

This Hands-On Lab will let you try out a series of examples demonstrating the powerful aspects of analytic function syntax and various use cases, giving you practical experience that'll help you know when you can profitably use analytic functions in your work.

Pre-requisites for attendees:

You must have an Oracle Single-Sign-On Account, as the lab will be using http://livesql.oracle.com
(You probably already have such an account for OTN, MOS, or another Oracle site, but if not, then it's free and you can create the account at the time of the conference. However, you'll have more time for the lab if you have the account ready ahead of time).

Pattern Matching HOL (max. 30 participants)
Friday, June 25, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Database HOL Room
 O-Ace-Director-Icon-rgb.png
Kim Berg Hansen, Trivadis

Often you need to work with how data interacts across rows, not just within a single row. Analytic functions can help a lot with this, but since version 12.1, row pattern matching has been an alternative that enables querying for patterns in the data in more complex ways than analytics can do—and at the same time in a simpler fashion as the syntax is very declarative. Once you are familiar with the syntax, you can use MATCH_RECOGNIZE for quite varied use cases, like searching patterns in stock ticker data, grouping sequences, bin fitting problems, and a lot more.

The syntax can be daunting at first glance, though with a lot of options. This Hands-On Lab lets you try out different ways of using the MATCH_RECOGNIZE clause, showing the syntax with various use cases, letting you come to grips with how the various parts of the syntax work and interact with each other.

Prerequisites for attendees:

You must have an Oracle Single Sign-On Account, as the lab will be using http://livesql.oracle.com
(You probably already have such an account for OTN, MOS, or another Oracle site, but if not, then it's free and you can create the account at the time of the conference. However, you'll have more time for the lab if you have the account ready ahead of time).

Picking a Good Wine Using Autonomous, Machine Learning and Analytics Cloud
Wednesday, June 30, 2021 | 2:20 p.m. - 5:00 p.m. | Database HOL Room
Charlie Berger, CharlieDataMine

We've all been there. We are invited to a party and want to bring something to contribute. A bottle of wine is always a good option. But which one? There are so many! And we don't want to break the bank for our party gift. Let's use the Autonomous Database, Oracle Machine Learning and Oracle Analytics Cloud to find a likely tasty and likely to be rated greater than 90 Points (GT_90_Points) adult beverage that is also affordable (Under $30). This workshop walks the users through an Oracle Machine Learning notebook, how to use Oracle Machine Learning to build, evaluate and apply machine learning models including performing text mining inside ADW. Then we use Oracle Analytics Cloud to apply the OML models inside ADW and use OAC’s interactive graphs and reports to select an inexpensive bottle of wine that is likely to be delicious! Audience members are invited to follow along using the OML notebook, Kaggle data and OAC .DVA posted on Github using this Oracle LiveLab.

Using Graph Studio for New Insights (max. 30 participants)
Thursday, July 1, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Database HOL Room
Jayant Sharma and Albert Godfrind, Oracle Corporation

Explore the new Graph Studio feature of Oracle Autonomous Database and its power to find new insights in your data. Graph analytics enables you to find important entities, hidden relationships, anomalous patterns, tightly connected clusters, and more. In this lab, you will load and model data as a graph, use graph algorithms, query for graph patterns in your data, and visualize results in an integrated notebook. With Graph Studio you will get started with graphs in minutes.

Note: All you'll need in order to participate in this Hands-On Lab is a stable internet connection, a modern web browser, and an eagerness to learn! Your instructor will provide you the Oracle Autonomous Database environment (using LiveLabs platform on the cloud), along with login credentials, and guidance throughout the exercises in this Graph lab.


Emerging Technologies:

Building Microservices with Oracle Converged Database (max. 100 participants)
Friday, June 25, 2021 | 11:00 a.m. – 1:40 p.m. | Emerging Technologies Room
Thursday, July 1, 2021 |11:00 a.m. – 1:40 p.m. | Emerging Technologies Room
Sanjay Goil, Paul Parkinson, and Richard Exley, Oracle Corporation

Building upon Oracle's LiveLabs, this HOL will cover the following:

-Set up OCI, OKE, and ATP.

-Build and deploy microservices.

-Set up database connection secrets, tables, and AQ messaging.

-Data-centric microservices walkthrough with Helidon MP.

-Polygot microservices.

-Scaling the application.

-Create an APEX app to make sense of the data.

Hands-On Lab using Oracle Machine Learning for Python on Autonomous Database (max. 100 participants)
Friday, June 25, 2021 | 2:20 p.m. – 5:00 p.m. | Emerging Technologies Room
Marcos Arancibia, Mark Hornick and Sherry LaMonica, Oracle Corporation

Python is one of the favorite languages used in AI and ML applications. Learn how the Oracle Database natively supports Python through a series of real-world use cases, highlighting the broad set of algorithms and high performance execution. Students will run the notebooks themselves to build and apply OML models inside Oracle Autonomous Database while leveraging both OML4Py’s in-database functionality and the ability to run open-source Python (pandas, scikit-learn, matplotlib, etc.). Having built OML models, students will then focus on model deployment using both SQL for in-database scoring, and they will experiment with OML AutoML for automated machine learning.


Workshop prerequisites:
• Knowledge of Python is desirable.
• Familiarity with machine learning processes and concepts is beneficial.
• Familiarity with Oracle Database is desirable but not required.


Enterprise Planning:

Groovy Scripting for Enterprise Planning Cloud (max. 25 participants)
Tuesday, June 22, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Ent Plan HOL Room
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Ent Plan HOL Room
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Ent Plan HOL Room
Chris McManus, Keyteach

Explore how Groovy rules, a multi-faceted language for the Java platform, can be written in Calculation Manager as an alternative to traditional business rules. Discover how Groovy can be used with Enterprise Planning Cloud to generate calc scripts dynamically at runtime, based on the context in which they are executed. Attendees will also explore the use of pure Groovy rules for performing data validation.


EPM Foundations:

Explore the REST APIs for Oracle EPM Cloud (max. 25 participants)
Thursday, June 24, 2021 |11:00 a.m.  – 1:40 p.m. | EPM Found/Reporting HOL Room
Wednesday, June 30, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room
Chris McManus, Keyteach


Discover how REST API functions allow clients to issue requests to and receive responses from a server using the HTTP protocol. Find out how to extend and automate the Oracle EPM Cloud using the available REST APIs, allowing the monitoring of applications and the execution of processes through simple URL-based requests.

Introducing Restricted Use DRM for Hyperion 11.2 (max. 25 participants)

Thursday, June 24, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room
Wednesday, June 30, 2021 | 11:00 a.m. – 1:40 p.m. | EPM Found/Reporting HOL Room
Simon Beesley, Keyteach


Not just a replacement for EPMA, “Restricted Use” DRM is available for all to use for FREE within a Hyperion EPM environment. Find out how organizations can synchronize master data between Oracle EPM on-premises applications—ideal for multi-product/multi-application or where a number of administrators maintain EPM metadata. Find out what is required for installation and discover more about the features, capabilities, and benefits of adopting this software.

An Introductory Overview of Narrative Reporting (max. 25 participants)
Friday, June 25, 2021 | 11:00 a.m. – 1:40 p.m. | EPM Found/Reporting HOL Room
Tuesday, June 29, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room
Caroline Robinson, Keyteach


Get an overview of how to define, author, review, and publish management and regulatory reports using a secure, auditable workflow. Discover the key configuration tasks and learn how to combine data and textual narrative content. Discover how reports can be grouped to produce executive briefing books and explore the use of report bursting to distribute report content securely.

Managing Enterprise Data with EDM (max. 25 participants)
Friday, June 25, 2021 | 2:20 – 5:00 p.m. | EPM Found/Reporting HOL Room

Tuesday, June 29, 2021 | 11:00 a.m. – 1:40 p.m. | EPM Found/Reporting HOL Room
Simon Beesley, Keyteach

Get an overview of the capabilities and understand the architecture of Oracle's Enterprise Data Management Cloud (EDMCS) and find out how to share and map enterprise data across applications. Discover the advantages of unified control of diverse data silos, crucial to the effective administration and synchronization of master data across the enterprise.


Essbase:

Get “Hands On” with Essbase 21c (max. 25 participants)
Friday, June 25, 2021 |11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Essbase HOL Room
Thursday, July 1, 2021 |11:00 a.m. – 1:40 p.m. and 2:20 – 5:00 p.m. | Essbase HOL Room
Chris McManus, Keyteach

Get “hands on” with the latest Essbase platform, review the differences in features and functionality between Essbase 11g on premises and Essbase 21c. Discover the modern browser-based UI for management and administration, explore the new Cube Designer plugin for Smart View, and learn about new platform features such as connections/data sources, new security roles, dynamic filters, and more.


Financial Close:

Getting Started with Account Reconciliation Cloud (max. 25 participants)
Tuesday, June 22, 2021 | 11:00 a.m. – 1:40 p.m. | Financial Close HOL Room
Wednesday, June 23, 2021 | 2:20 – 5:00 p.m. | Financial Close HOL Room
Monday, June 28, 2021 | 11:00 a.m. – 1:40 p.m. | Financial Close HOL Room
Graeme Gibson, Keyteach

Discover how Account Reconciliation Cloud (AR) can streamline close processes and deliver insight about the real-time status of account reconciliations and transaction matching. Find out how reconciliation compliance is used to manage reconciliation processes and explore the automation of high-volume/labor-intensive transaction matching.

 

Understanding Calculations in Financial Consolidation and Close Cloud (max. 25 participants)
Tuesday, June 22, 2021 | 2:20 – 5:00 p.m. | Financial Close HOL Room
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. | Financial Close HOL Room
Monday, June 28, 2021 | 2:20 – 5:00 p.m. | Financial Close HOL Room
Simon Beesley, Keyteach

This session introduces techniques for manipulating calculations and writing custom business logic for Financial Consolidation and Close Cloud (FCC). Explore the concepts required for writing calculations in the new multi-dimensional environment for financial consolidation and gain insight into the relationship between built-in calculations and those over which there is full control.


Modern App Development:

Building Apps for Mobile Devices: The Easy Way (max. 30 participants)
Wednesday, June 23, 2021 | 11:00 a.m. – 1:40 p.m. | MAD HOL Room
Susan Duncan, Oracle Corporation

In this Hands-On Lab, build a mobile application and deploy it to your mobile device with Visual Builder. We’ll start from scratch, creating data objects and a mobile optimized UI experience that will allow us to interact with data. Then we’ll learn how to deploy the application as both a Progressive Web App (PWA) as well as a packaged app for android and iOS which you can publish to app stores. No prior experience needed.

 

Visual Builder Deep Dive: The End-to-End Development Experience (max. 30 participants)
Wednesday, June 23, 2021 | 2:20 – 5:00 p.m. | MAD HOL Room
Shay Shmeltzer, Oracle Corporation

In this demo-focused deep dive session, we’ll first introduce you to Visual Builder’s architecture, building blocks, and the development experience.

We’ll then expand to cover advanced features of the Visual Builder Studio environment, focusing on how they help teams manage development processes and software delivery. We’ll cover tracking issues, managing agile development sprints, versioning, branching and merging code, and automating continuous delivery of your app.

Get “Hands On” and Build Your First Digital Assistant (max. 30 participants)
Tuesday, June 29, 2021 | 11:00 a.m. – 1:00 p.m. | MAD HOL Room
Grant Ronald, Oracle Corporation

In this instructor-led session you are going to turbo charge your practical knowledge of conversational digital assistants by getting “hands on”. The session starts with an insight into the main building blocks of building chatbots, and then an end-to-end demo of how to build an AI-driven chatbot that understands natural language. You’ll then get access to an instance to build your own chatbot with step-by-step guidance and support from the Oracle Digital Assistant development team.

The Real-World Lessons of Building a Product Digital Assistant: From Conception, Going Live, and Learning to Be Smarter (max. 30 participants)
Tuesday, June 29, 2021 | 2:20 – 3:50 p.m. | MAD HOL Room
Grant Ronald, Oracle Corporation

There is a universe of difference between the emp/dept/“hello world” of conference demos and building production quality 24x7 software used by thousands of people. In this session we’ll introduce Artie, which is not only a production chatbot but is also a framework for other production digital assistants being developed inside Oracle.

We will discuss the conception of the idea of Artie, how the project was defined, architected, designed, and how the software was developed. We’ll also look at and demonstrate how we measured the success of Artie and how we improved language understand and user experience over time.

You’ll also get access to Artie to test and then ask any questions.


Profitability:

Discover the Capabilities of Profitability and Cost Management (max. 25 participants)
Thursday, June 24, 2021 |11:00 a.m. – 1:40 p.m. | Profitability HOL Room
Wednesday, June 30, 2021 | 2:20 p.m. – 5:00 p.m. | Profitability HOL Room
Simon Beesley, Keyteach

Discover the capabilities and the concepts required to design and create Oracle Profitability and Cost Management (PCM) applications. In this introductory hands-on session, attendees will get an overview of how to identify and exploit profitability through the development of advanced modelling and complex what-if scenarios and reporting.