data science Introduction to Oracle Data Science Service Part 1 Getting started with OCI Data Science Service The Oracle Cloud Infrastructure (OCI) Data Science service allows you to build, train and deploy Machine Learning (ML) models. Notebook Sessions are created on compute instances of the required shape, and allow you to work with a JupyterLab notebook interface. These Notebook Sessions
OAC Oracle Analytics Cloud March 2023 Update: What's New? The March 2023 Update for Oracle Analytics Cloud came out few days ago and in this article I'm going to have a look at the features it includes. If you are also interested in a comprehensive list of the defects fixed by the update, please refer to Doc ID 2919336.
Being Groovy without an ODI IDE In this blog post, we will show you how to execute Groovy scripts outside of the ODI IDE, opening up the opportunity to include the scripts in workflows and pipelines.
Breaking the Assumptions of Linear Regression Linear Regression must be handled with caution as it works on five core assumptions which, if broken, result in a model that is at best sub-optimal and at worst deceptive.
OAC Leveraging OCI Functions (Custom Scripts) in Oracle Analytics Cloud - Part 1 Leveraging custom Python/R scripts in Oracle Analytics Server; unfortunately, the custom script feature is not available in Oracle Analytics Cloud, but you should not worry too much about it as there is an alternative: OCI functions!
Odi2Package tool - reverse-engineers and generates ODI Packages Introducing new reverse-engineering capability In my previous blog post, I introduced our new Odi2Package tool that allows you to auto-generate ODI Packages. Our ODI development teams were quick to adopt the tool for their project needs. Soon, however, we noticed a significant weakness: the manual creation of templates for new
Analytics and Data Oracle User Community Data Summit 2023 We are excited to be sponsoring the first post-pandemic Analytics and Data Oracle User Community Data Summit next week, March 14-16, 2023 The three day summit will be held at the Oracle Conference Center in Redwood Shores, California and will feature keynotes by industry experts, educational sessions by practitioners and
Oracle Oracle APEX - Universal theme tip #1 - Grid Responsiveness I finally had some time to play with the responsiveness in the Universal Theme of Oracle APEX. Given that our APEX instance has just been upgraded to 22.2, and I had to refresh the theme anyway, I decided to invest some time into checking a hidden feature that I
Oracle APEX – Analytics Publisher REST API Integration We have produced this blog to describe how to integrate an Oracle Analytics Publisher part of Oracle Analytics (previously called BI Publisher) into APEX without using the latter's built-in reporting features. Seasoned developers of APEX applications will be familiar with its reporting capabilities, which can use uploaded templates created by
automl Oracle AutoML UI at a glance At the RMOUG 2023 training days, I co-presented a paper with my colleague Hannah Patrick titled "Data Science - Your Path to Predictive Analytics". Today I'd like to share with you an overview of the part of the paper that focused on the Oracle AutoML User Interface. We will automatically
Comparison of Tableau vs Power BI vs Oracle Analytics Introduction Business Intelligence (BI) tools are a vital part of the data and analytics architecture, as they allow end users to consume the data and help them to take better data-driven, actionable decisions, for example: * Increasing profitability by analysing customer behaviour * Eliminate inefficiencies by optimising operations * Quickly adapt to market
FILTER function A Hitchhiker's Guide to the FILTER Function in Oracle Analytics The FILTER function is a must-know feature for any Oracle Analytics developer to create advanced calculations in their own reports. Despite already being available when I entered the working world in 2010, it's plagued by a bug and the one line documentation is not exhaustive at all: as a result,
Data Governance Taking a Data Governance Programme to Maturity In this mini-series, I’ve looked at the business benefits of employing a data governance framework; and how to get startedwith some quick wins in the first six months. I’m going to close the series by explaining how to embed a data governance programme in your business, so that
Conferences RMOUG Training Days 2023 We are proud to be the platinum sponsor and soon-to-be attendee of the Rocky Mountain Oracle User Group (RMOUG) Training Days event. Expect to be Informed and Inspired to Initiate new Ideas to Improve your working lives at Training Days 2023 Live - Virtual - Hybrid Conference.
Data Governance How to Get a Data Governance Programme Underway... Quickly Data governance does not need to begin life fully fledged. There are some quick wins that most organisations should be able to implement in six months without the need for significant additional budget or board level agreement.
Odi2Package tool - auto-generates ODI Packages Introducing Odi2Package We have added a new tool to our arsenal - Odi2Package. It auto-generates ODI Packages based on a template. In combination with our Sql2Odi tool, we are now one step closer to the utopian dream of generating ETL straight from Low-level Design. Generating DDL statements (CREATE TABLE, CREATE
OAC Oracle Analytics Cloud January 2023 Update: What's New? The January 2023 Update for Oracle Analytics Cloud came out few days ago and in this blog post I'm going to have a look at the most important new features it includes.
Sql2Odi - best practices for auto-generating your ETL content I blogged a while ago about our Sql2Odi tool that converts SELECT (and WITH as well) statements into Oracle ODI Mappings. (Blog posts 1, 2 and 3.) Now that the tool has been around for close to 2 years, let us reflect on lessons learnt and best practices adopted. Let
Data Governance Why Data Governance Is More About Enabling Good Than Stopping Bad It seems like every day businesses are bombarded with reminders of the value of data. Data, we are told, leads us to make smarter decisions that deliver better outcomes.
Oracle APEX - Debugging Tip #1 If I would need this feature I would probably invest a lot of time trying to find out an answer. But funny enough I found out by mistake and as it might be useful to someone else I have just decide to publish this short blog post. Application Process on
We've added Search! Well, to be precise, our blog is hosted on Ghost, and we have just upgraded to version 5.0 which includes search, see here. 0:00/1× What does this mean? Well, now you don't have to use external search engines to find pages on the Rittman Mead blog, you
Oracle APEX - Social Login I looked into Social Sign-in as an option for Oracle APEX a few years ago. This was pre APEX 18.1 and, at this time, it was not simple to configure (in fact it would have taken a considerable amount of code to implement) Fortunately, since 18.1 APEX offers
OAC Oracle Analytics Cloud November 2022 Update: the New Features, Ranked The November 2022 Update for Oracle Analytics Cloud came out few days ago and in this blog post I'm going to have a look at all the new features it includes.
oas Leveraging Custom Python Scripts in Oracle Analytics Server This post illustrates how to leverage custom Python scripts in Oracle Analytics Server to give you greater control and flexibility over specific data processing needs.
Rittman Mead - de Novo Partnership 26th October 2022 On behalf of Rittman Mead I am delighted to announce the market disrupting partnership of de Novo - Rittman Mead. Oracle is a large investment for any organisation and as such it needs to be done correctly. By combining forces this new partnership gives clients access to
