Webinars


Is there a topic you would like covered but do not see here? We are happy to take webinar suggestions. Email us at kgately@odtug.com.

Did you miss a webinar? As an ODTUG member, you can view all of our past webinars at any time. Just log in and you will see the link for the recorded list. Not a member? Join now for $99!

Our webinar calendar is constantly evolving! Check back frequently, as more webinars will be added to the schedule.

Suggest a Topic   Past ODTUG Webinar


Database.png

Thursday, September 21, 2017 12:00 PM - 1:00 PM EDT
 2017 CodeTalk Series: Ten Things About PL/SQL You Probably Don’t Know
Steven Feuerstein, Oracle Corporation and Sven Weller, Syntegris Information Solutions GmbH

The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG.

Join Steven Feuerstein for an exploration with Sven Weller (@svenweller) into interesting, lesser-known aspects of PL/SQL. Sven’s been working with Oracle database technology for more than 15 years. He loves to do in-depth analysis of problems, and find new ways to tweak SQL and PL/SQL to come up with solutions. These days, he focuses on performance tuning and rapid application development with Application Express.

 Register Here


EPM.png

Tuesday, September 26, 2017 12:00 PM - 1:00 PM EDT
 Cash Flow in FCCS
Greg Giles, Accelytics Consulting

Cash flow is often the last piece of the financial reporting puzzle and is often manual and time consuming.  Learn how Financial Consolidation and Close Cloud Service (FCCS) solves cash flow automation and reporting, leveraging out-of-the box functionality and configuration to meet your company’s needs.  

Register Here


Database.png

Thursday, September 28, 2017 12:00 PM - 1:00 PM EDT
 SQLcl & SQL Developer Tips & Tricks
Jeff Smith, Oracle Corporation

Fewer keystrokes, fewer clicks = more code, more productivity, more fun.

This session concentrates on the power features that most users bypass when using Oracle SQL Developer and our new command line interface, SQLcl. Do you use all the shortcuts available to you? After this talk, you'll know how to get what you want, as quickly as you want.

We're rebuilding this session from scratch. That's right, in 2017 this talk will be BRAND NEW. So, if it's been awhile since you've seen it, come back and get caught up.

As always, our goal is for each attendee to pick up one to three techniques that will drastically impact their productivity and save them time when working with Oracle Database.

Register Here


BI.png

Thursday, October 5, 2017 12:00 PM - 1:00 PM EDT
 QuickStart for OAC: Get Essbase in the Cloud Up and Running in Less Than a Month
Andrew Tauro and John McGale, Performance Architects

Oracle recently introduced Oracle Analytics Cloud (OAC), combining the best of Oracle’s BI, data discovery and big data solutions into a platform-as-a-service (PaaS) solution.  The Performance Architects team will discuss the components of the OAC solution (including Essbase, BI Cloud Service or BICS, and Data Visualization or DV); how to integrate with Oracle EPM (Hyperion) and related EPM and BI technologies; use cases; and a fast and easy way to get started in 30 days or less!  This leverages Performance Architects’ experience with hundreds of Oracle implementations both on-premise and in a hosted or cloud environment. 

Register Here


EPM.png

Thursday, October 12, 2017 12:00 PM - 1:00 PM EDT
 Elevating Your Workforce Planning Solution to the Cloud
Nicholas Blazosky and Juan Porter, Top Down Consulting

Thinking about elevating your organization’s workforce planning solution? Want to see a detailed demo of the capabilities of the latest version of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) SWP (Strategic Workforce Planning) and Workforce Planning modules? What has changed since the days of deployment in on-premise, and how can you be leveraging the enhanced functionality for your organization? Learn the differences between an on-premise deployment and strategies for getting you to the cloud in no time. Join seasoned WFP architects and Kscope speakers Juan Porter and Nicholas Blazosky for this informative deep dive into the newly enhanced world of Workforce. 

Register Here


EPM.png

Tuesday, October 17, 2017 3:00 PM - 4:00 PM EDT
 Data Integration Options for Planning and Budgeting Cloud Service
Deanna Sunde ACE.pngKey Performance Ideas

Explore the data integration and automation options available for EPBCS/PBCS. Use cases and pros and cons for the methods will be discussed, as well as the file format requirements, options, and code examples. Use cases include ad hoc and automated/scheduled data loads, moving data from/to BSO and ASO cubes, importing/exporting text accounts and smart list values, migration, and disaster recovery. Included will be data management, EPM Automate and FDMEE, as well as business rule data exports, export/import data, export/import metadata, Data Sync, and Smart Push. 
Attendees will understand how the EPBCS/PBCS tools replace the functionality of on premise bat and maxl scripts. Example EPM Automate scripts will be reviewed. Tips and tricks will be provided as to when to use which tool and how to automate these tools with EPM Automate. 

Register Here


EPM.png

Wednesday, October 18, 2017 3:00 PM - 4:00 PM EDT
 Leverage a Competitive Advantage with EPBCS Workforce Planning Module
Vince Tran, Vertical Edge Consulting  Group

Workforce enables planners to align critical corporate resources—people and dollars—with the strategies that best leverage a competitive advantage. Using Workforce, departments collaborate to plan headcount and related expenses such as salaries, health care, bonuses, and taxes. Planners can see up-to-date graphics that show expenses and trends. 
In this session, we will take a close look at Workforce Planning and how it enables planners to manage and track headcount expenses by analyzing, calculating, and reporting on salary, bonuses, taxes, and health care expense; planning for new hires, transfers, promotions, terminations; and defining country appropriate taxes and benefits.

Register Here


Database.png

Thursday, October 19, 2017 12:00 PM - 1:00 PM EDT
 2017 CodeTalk Series: Rapid Web Application Development in the Cloud
Blaine Carter and Kris Bhanushali, Oracle Corporation

The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG.

Oracle is quickly ramping up its cloud services, and one of the things you will need to be able to do is combine multiple services to build your apps in the cloud. This immediately leads to questions of how to best manage application changes and deploy them to production in the cloud. In this CodeTalk webcast, Blaine Carter of the Developer Advocates team picks the brains of Kris Bhanushali, senior principal product manager, who will give a live demo showing how various cloud services come together to enable a developer to build enterprise-grade applications quickly with little external dependency.

Register Here


BI.png

Thursday, October 26, 2017 12:00 PM - 1:00 PM EDT
 Migrating OBIEE to the Oracle Analytics Cloud (OAC): Challenges, Tips and Tricks
John McGale, Performance Architects

Is your organization using Oracle BI Enterprise Edition (OBIEE) 11g, and you are at the crossroads regarding tool selection for cloud migration? If so, this webinar is for you! The Performance Architects team explains:

  • Feature/functionality and licensing benefits of upgrading to OAC
  • What to do about those tricky ELT/ETL solutions
  • Cloud versus on-premise considerations
  • Options for lifting and shifting your content
  • Important focus areas for Oracle BI applications (OBIA) customers
  • Real-world case study examples and pitfalls to avoid

Register Here


TuesdaEPM.pngy, October 31, 2017 12:00 PM - 1:00 PM EDT
 Mastering MDX for Analytics and Reporting
Jennifer Hanks, Key Performance Ideas

MDX is often used in ASO cube member formulas, but did you know you can also use MDX to write reports and Smart View queries? Did you know that these reports and queries can be written against both BSO and ASO cubes? 
MDX can seem daunting, but with a basic understanding of syntax and functions, MDX is not that difficult. Join us for our webinar and learn what you need to get started writing MDX reports and queries that can supplement your reporting and add a new tool to your reporting tool set. 
Presented by Jennifer Hanks at Kscope 17 and awarded best presentation of the BI & Reporting Track, Jennifer will share: 

  • Best practices for building formulas, including examples to visualize the appropriate approach 

• A comparison of MDX to BSO formulas and the conversion of BSO to ASO, specifically instances where very distinct differences can occur, and how to make the   process run smoothly
• How to use MDX editor to write queries and reports against both BSO and ASO cubes

The goal of this webinar is to help attendees brainstorm new formulas their leadership might find useful, particularly when reviewing how other companies have built and leverage MDX on a daily basis for trend analysis, salary projections, turnover analysis, forecasting, and budgeting purposes using KPIs, and more. 

Register Here


BI.pngEPM.pngThursday, November 2, 2017 12:00 PM - 1:00 PM EDT
Essbase in the Cloud: It's Here...Now What?
Andrew Tauro, Performance Architects

Are you an old-school, on-premise Oracle Essbase customer who’s accustomed to using Essbase for analysis outside of your “traditional” Oracle EPM (Hyperion) applications like Planning, HFM, HSF, etc.? Did you hear that Essbase is moving to the cloud and are you wondering what this means for Essbase improvements and changes how you use and license Essbase today? Are you looking to extend Essbase analytics using one of Oracle’s newer business analytics / BI solutions like Data Visualization (DV) or BI Cloud Service (BICS)? Finally, have you heard that Essbase is now part of Oracle Analytics Cloud (OAC) and are you wondering what this all means? If so, this webinar is for you.

Join the Performance Architects team to learn all about Essbase in the cloud…what it means, what it does, and how it’s different than the on-premise Essbase we all know and love.

Register Here


BI.png

Tuesday, November 14, 2017 3:00 PM - 4:00 PM EDT
 Oracle Analytics: Cloud or On-premise, You're Doing It Wrong - Part 1 of 2
Christian Berg ACEAss-01.png, Dimensionality

Turning the standard best-practice/how-to presentation format on its head, this presentation will look at some real-life OACS or OBI implementations and where it all went wrong. We’ll look at the worst, the weirdest, the most absurd and the wackiest ways the Oracle Analytics tool is abused: 

  • How did projects get to these points? 
  • What were the original misconceptions? 
  • How to counter these misconceptions? 
  • Why are “it works” and “it fulfills the requirements” not only not enough but rather dangerous pitfalls? 
  • Can I actually jeopardize the future of my BI system by choosing a cheap quick and dirty approach? 
  • Is it ever OK to simply execute without comprehension? 

This session will give attendees a deeper understanding of the impact seemingly innocuous design and implementation decisions can have on the stability and success of an entire Analytics system. An end-to-end view of the stack will be taken, covering areas including logical modelling, analysis design, and architectural topics. The importance of a holistic view and an appreciation of alternatives will be emphasized as well as the need to understand, comprehend, and reflect on the implications of a “best practice” being followed, as well as the technology stack simply being misunderstood. Attendees will be in a position to better weigh and judge implementation options knowing their long-term effect and impacts in terms of: 

  • user experience 
  • performance 
  • upgrade capability 
  • ease-of-use 
  • reproduciblity 

Register Here


Database.png

Thursday, November 16, 2017 1:00 PM - 2:00 PM EDT
 2017 CodeTalk Series: JSON in the Oracle Database 
Steven Feuerstein, Oracle Corporation and Darryl Hurley, Implestrat.com

The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG.

Did you know that Oracle Database 12c makes it easy for you to store, manipulate, and serve up JSON documents? You certainly do NOT need to install a document store database side-by-side with Oracle Database when your UI developers start demanding JSON! Join Steven Feuerstein for an interview with and demonstrations by Darryl Hurley of Implestrat.com. Darryl, an active database developer and DBA for many years, has lately been diving into the JSON features of 12.1 and 12.2. Make sure you are positioned to have a smart conversation with the JavaScript developers in your company about how you can help meet their JSON needs.

Register Here