SQL for Data Warehousing and Analytics

  Here’s your absolutely Must-See agenda for Wednesday at OpenWorld 2018... Day one is a wrap so now is the perfect time to start planning your Day 3 session at   OpenWorld 2018. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Highlight of today is two additional chances to get some real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 12:45pm - 1:45pm and then again at 3:45pm - 4:45pm, both at the Marriott Marquis (Yerba Buena Level) - Salon 9B. We will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   WEDNESDAY'S MUST-SEE GUIDE     Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a com...

  Here’s your absolutely Must-See agenda for Tuesday at OpenWorld 2018... Day one is a wrap so now is the perfect time to start planning your Day 2 session at   OpenWorld 2018. The list is packed full of really excellent speakers from Oracle product management talking about Autonomous Database and the Cloud. These sessions are what Oracle OpenWorld is all about: the chance to learn from the real technical experts. Highlight of today is the chance to get some real hands-on time with Autonomous Data Warehouse in the ADW Hands-on Lab at 3:45 PM - 4:45 PM at the Marriott Marquis (Yerba Buena Level) - Salon 9B. We will help you sign up for a free cloud account and then get you working on our completely free workshop. Don't miss it, just bring your own laptop!   TUESDAY'S MUST-SEE GUIDE     Don't worry if you are not able to join us in San Francisco for this year's conference because I will be providing a comprehensive review after the conference closes on Thursd...

I have just uploaded a new workshop on sessionization analytics using the 12c pattern matching feature, MATCH_RECOGNIZE, to the Oracle Learning Library . The workshop is based on analysis of the log files generated by our the Big Data Lite Movieplex application, which is part of our Big Data Lite virtual machine . Oracle Movieplex is a fictitious on-line movie streaming company. Customers log into Oracle MoviePlex where they are presented with a targeted list of movies based on their past viewing behavior. Because of this personalised experience and reliable and fast performance, customers spend a lot of money with the company and it has become extremely profitable.  All the activity from our application is captured in a log file and we are going to analyze the data captured in that file by using SQL pattern matching to create a sessionization result set for our business users and data scientists to explore and analyze. The sections in the workshop (I have recorded a video of this wor...

This is your chance to get some winter sun and learn about the new 12c SQL pattern matching! I have just received confirmation from BIWA Summit team that my presentation and hands-on lab on SQL pattern matching have been accepted for the 2014 conference (Jan 14-16 2014 at the Oracle Conference Center, Oracle HQ, Redwood Shores). If you are not familiar with BIWA then here is an overview: The Oracle Business Intelligence, Warehousing and Analytics Special Interest Group (BIWA SIG) is the leading worldwide association of persons interested in the successful deployment of Oracle Database-centric business intelligence, data warehousing, analytical products, EPM/Essbase and Big Data related features and options. BIWA now has almost 2000 members worldwide. BIWA is a not-for-profit entity affiliated with the Independent Oracle Users Group (IOUG). BIWA runs all sorts of activities: Webcasts - BIWA holds monthly webcasts presenting BI and DW experts speaking on BI, Data Warehousing and ...

If you want to get hands-on time with Oracle's big data technology stack then we are rolling out, in collaboration with OTN, a new complementary one-day hands-on workshop - yes it really is FREE! The date will is Wednesday, February 20, 2013 at Oracle's HQ in Redwood Shores, California . The workshop will be based around the MoviePlex demonstration application that was first shown at last year's OpenWorld and you will get hands-on time with the source code and we will show you how to develop some of the key features of this application. What is Oracle MoviePlex? The Oracle MoviePlex is a fictional on-line movie streaming company and like many other on-line stores, they needed a cost effective approach to tackle their “big data” challenges. They recently implemented Oracle’s Big Data Platform to better manage their business, identify key opportunities and enhance customer satisfaction. The key challenge for Oracle Movieplex is how to manage and process massive vo...