Posts

Association Rules and Recommendations with Oracle Analytics

Image
A few months ago, I was writing about Market Basket Analysis that you can perform in Oracle Autonomous Database and Frequent Itemsets that can also be created with Oracle Analytics .  When working with Oracle Analytics, one important part of Market Basket Analysis was missing - Association Rules and Recommendations . Oracle Analytics from version 6.0 supports this feature, therefore complete Market Basket Analysis can be done now. Let's take a look at the data flow we created for creation of Frequent Itemset. It consists of three steps: As usual, we begin a data flow by reading data. In our case we read database data table CARBO_TRANSACTIONS. This table has relatively simple structure: For our analysis only BASKET and UPC columns are important. In the second step, Database Analytics step with analytics operation Frequent Itemsets we define parameters for the algorithm. In the Outputs , we define output columns. In our case we are looking only for combinations of the two product

Anomaly Detection in Oracle Analytics

Image
Charlie Berger and Abi Giles-Haigh ran the hands-on lab session yesterday (11th May 2021) at Analytics and Data Oracle User Community's, AnDOUC ( https://analyticsanddatasummit.org/ ), TechCast Days, Spring Sessions with the title A Two-Step process for Detecting Fraud . I was invited to help with the HOLs alongside with Tim Vlamis and Edelweiss Kammermann .  The hands-on lab is about taking users through Oracle Machine Learning (SQL) Notebooks while using multiple use case scenarios for analysing insurance claims data and customer behavior data. Students were running the notebooks themselves to build and apply OML models inside Oracle Autonomous Database and then worked with Oracle APEX applications that leveraged OML’s insights and predictions ... So basically, what we did was: we took the Insurance Claims data set and ran 1-Class SVM algorithm, which is used for anomaly detection in order to identify suspicious claims.  For business (and any other) users we have an option to do

Oracle Analytics 6.0: Hierarchical Columns

Image
  Oracle Analytics 6.0 has arrived! Our Oracle Analytics instance was just patched a few hour ago. Everyone who is using Interactive Dashboards and Analytics (even from OBIEE times) is familiar with hierarchical columns. They are very popular with users and in some cases, like working with OLAP cubes (ie. Essbase), necessary. Oracle Data Visualisations (in the past) aka Oracle Analytics (today) lacked this functionality until now. In version 6.0 this has finally been included and here we are testing it. Data Visualisations with Hierarchical Columns Hiearchical Columns are the most applicable in tables or pivot tables, however they can be used in some other visualizations like trellis. We will create a project first. Hierarchical columns can be defined in Oracle Analytics Data Models aka Subject Areas, Oracle Planning applications or Essbase cubes. By selecting one of subject areas you can now see hierarchical columns in the data model in the Data panel: Working with hierarchical column

How to visualise Market Basket Analysis in Oracle Analytics?

Image
Frequent Itemsets and recommendations are two components of Market Basket Analysis. Everything is prepared within Oracle Autonomous Data Warehouse (ADW) and brought into Oracle Analytics where frequent itemsets and recommended items are visualised using Sankey and Network graphs.

SIOUG Event: Oracle Analytics Tips & Trips Series - What's new in Oracle Analytics 5.9?

Image
SIOUG (Slovenian Oracle User Group), in cooperation with Qubix , organised the first webinar in the Oracle Analytics - Tips & Tricks Series . What's new in Oracle Analytics 5.9 webinar took place on Thursday, 25th February 2021, starting at 11am CET .  Topics covered: How to prepare data to analyse the products that are most often sold together? How to register and use machine learning models from Oracle database in Oracle Analytics. How to parse text and how to use parsed text in combination with other business data to produce effective and interactive visualisations. How to use existing web mapping services (WMS and XYZ) in analyses using geo-data. What are the key changes and improvements in data visualisation. Webinar was delivered by: Mojca Gros , Qubix, Senior Business Analytics Consultant Žiga Vaupot , Qubix, Country Manager and Oracle ACE Here is the recording of the webinar (language used is Slovenian).

Oracle Analytics 5.9: What's New?

Image
Last night, our Oracle Analytics instance was upgraded to 5.9.  It was long awaited upgrade, which introduces some nice new features and improvements. My personal interest lies with the enhanced Machine Learning support, however, there are several other features that might draw your attention.  Let me briefly talk about some of them. Additional functions in Database Analytics step in Data Flows Two new Database Analytics steps in Data Flows are: Frequent Itemsets and  Text Tokenisation. About Frequent Itemsets , I'm describing in detail in my separate blog  Oracle Analytics 5.9: Frequent Itemsets , so let me not repeat myself here. Text Tokenisation allows users to analyse textual data by breaking it down into distinct words and counting the occurrences of each word.  Technically, when data flow is run, a new database table would be created, table is named  DR$IndexName$I , which contains the token text and the token count related details. Once created, this table can be used to c