Scheduling ODMr Workflows in SQL Developer 4.2+

A new feature for Oracle Data Mining (ODM) (part of SQL Developer 4.2) is the ability to schedule an ODM workflow to run a defined time or frequency. This blog post will bring you through the steps need to schedule an ODM workflow using this new feature. The first thing that you need is an ODMr workflow. The following image is a familiar looking one that I typically use to get a very quick (more...)

How was Game Of Thrones S07 E05? Tweet Analysis with Kafka, BigQuery and Tableau

How was Game Of Thrones S07 E05? Tweet Analysis with Kafka, BigQuery and Tableau

I don't trust statistics and personally believe that at least 74% of them are wrong.... but I bet nearly 100% of people with any interest in fantasy (or just any) TV shows are watching the 7th series of Game of Thrones (GoT) by HBO.
If you are one of those, join me in the analysis of the latest tweets regarding the subject. Please be also aware that, if you're not on the latest episode, some (more...)

Auto enabling APPROX_* function in the Oracle Database

With the releases of 12.1 and 12.2 of Oracle Database we have seen some new functions that perform approximate calculations. These include:

  • APPROX_COUNT_DISTINCT
  • APPROX_COUNT_DISTINCT_DETAIL
  • APPROX_COUNT_DISTINCT_AGG
  • APPROX_MEDIAN
  • APPROX_PERCENTILE
  • APPROX_PERCENTILE_DETAIL
  • APPROX_PERCENTILE_AGG

These functions can be used when approximate answers can be used instead of the exact answer. Yes can have many scenarios for these and particularly as we move into the big data world, the ability to process our data quickly is slightly more important (more...)

Six Plus One Types of Interviewers


R
emember Chuck Noland? The character in the movie Castaway, who has to use the blade of an ice-skate to extract his abscessed tooth, without anesthesia? The scene is painful to watch, yet you can't look away.

Interviews have this habit of turning up a Chuck Noland - in the interviewee or the interviewer. You willingly agree to subject yourself to the wanton abuse by random strangers who you may have to end up working (more...)

Part 5 – The right to be forgotten (EU GDPR)s

This is the fifth part of series of blog posts on 'How the EU GDPR will affect the use of Machine Learning'

Article 17 is titled Right of Erasure (right to be forgotten) allows a person to obtain their data and for the data controller to ensure that the personal data is erased without any any delay.

This does not mean that their data can be flagged for non-contact, as I've seen done (more...)

Trying out the Oracle Cloud Platform

One of the great things of working with Oracle is the possibility to try things out………., for free. Yes, some things at Oracle are indeed free 😃!! There are various places where you can download Oracle (related) software / scripts / examples / etc., so you can try things out. You should create an account … Continue reading "Trying out the Oracle Cloud Platform"

Data Architecture in a digital world; empowering the Data Driven Enterprise

Data is playing increasingly important role in organisations today. If you want to stay ahead of the competition you need to do things differently and preferably better than they do. This means you have to start initiatives. Initiatives which most likely involve an IT component. IT initiatives which are fed by reliable information / insights. … Continue reading "Data Architecture in a digital world; empowering the Data Driven Enterprise"

Management Mantra for Startups – Waste Not, Vacate Not

Image credit: pexels.com

Waste Not, Vacate Not.

W
hen Jeff Bezos, founder and CEO of Amazon, started out Amazon, he, along with Shel Kaphan, programmer and a founding employee, used sixty-dollar doors from Home Depot as desks. It was the demand of frugality. More than a decade later, when Amazon was a multi-billion dollar behemoth, conference-room tables were still made of door-desks. It reflected its CEO's adamant belief in "frugality." A (more...)

Part 4b – (Article 22: Profiling) Why me? and how Oracle 12c saves the day

This is the fourth part of series of blog posts on 'How the EU GDPR will affect the use of Machine Learning'

In this blog post (Part4b) I will examine some of the more technical aspects and how the in-database machine learning functions saves the day!

Probably in most cases where machine learning has been used and/or deployed in your company to analyse, profile and predict customers, it is more than likely that (more...)

Part 4a – (Article 22: Profiling) Why me? and how Oracle 12c saves the day

This is the fourth part of series of blog posts on 'How the EU GDPR will affect the use of Machine Learning'

In this blog post (Part4a) I will discuss the specific issues relating to the use of machine learning algorithms and models. In the next blog post (Part 4a) I will examine some of the more technical aspects and how the in-database machine learning functions saves the day!

The EU GDPR has (more...)

Analyzing Wimbledon Twitter Feeds in Real Time with Kafka, Presto and Oracle DVD v3

Analyzing Wimbledon Twitter Feeds in Real Time with Kafka, Presto and Oracle DVD v3

Last week there was Wimbledon, if you are a fan of Federer, Nadal or Djokovic then it was one of the events not to be missed. I deliberately excluded Andy Murray from the list above since he kicked out my favourite player: Dustin Brown.

Analyzing Wimbledon Twitter Feeds in Real Time with Kafka, Presto and Oracle DVD v3

Two weeks ago I was at Kscope17 and one of the common themes, which reflected where the industry is going, was the usage of Kafka as central hub for all data (more...)

Dashboards For Banking

The integration of huge financial data, time sensitivity and security restrictions is an extremely complex process. In this regard, the banking sector has found dashboards to be useful.

There’s no doubt your own institution grapples with humungous sets of data. Because of the large volumes of data and the manual treatment given to it, it is highly likely that you cannot make sense of these data in a way that you can fully take advantage (more...)

Importance Of Executive Dashboards For Insurance Companies

Were there times when you became so handicapped because data were not readily available? You demanded for reports for your perusal but the teams were still scrambling for data from files.

This is not happening only to you. It is a common flaw among insurance company managers.

What is being sacrificed when this happens?

  • Companies incur revenue losses.
  • Customer trust erodes.
  • Management loses times in meetings without the availability of concrete data.
  • Tension builds up (more...)

Possible solution for TLS 1.2 issues between Windows 10 and Oracle EPM Weblogic


We have recently seen some users of both Dodeca and Hyperion products where Windows 10 machines have issues connecting to the Weblogic servers shipped with Oracle EPM due to the absence of the TLS 1.2 protocol.  The underlying issue is that Windows 10 is an evolution of technology whereas Oracle EPM Weblogic, and more specifically the Java version tested and shipped with it, are stuck in the stone age.  Java 1.6 started its (more...)

Dashboards for Credit Unions

Business intelligence tools will thrive wherever there is available data that is reliable and accessible. When it comes to BI tools, these work not only by recording and reporting gains, losses, or delinquencies but also aid its users in finding potential opportunities in their industry.

Performance dashboards and other BI tools are increasing in popularity especially for credit unions. This is because these tools help organizations to assess risks aligned with loan portfolios. These (more...)

KPI Reporting and Dashboards for Project Management

KPIs enable managers to easily get an insight on how well a project has been handled. Although results are usually taken into account, the use of performance indicators considers all aspects of project management, which often makes KPI reporting more comprehensive as opposed to simple data analysis.

At the end of the day, KPIs provide a way for managers to improve how they handle projects and supervise their own team members. Its contribution to any (more...)

PRECIS R package

If you use R then you are very familiar with the SUMMARY function.

If you use R then you are very familiar with the name Hadley Wickham. He has produced some really cool packages for R.

He has produced a new R package and function that complements the commonly used SUMMARY R function.

The following outlines how you can install this new R package from GitHub (Hadley's GitHub is https://github.com/hadley/).

Install the R (more...)

Oracle Mobile Analytics

Imagine yourself without a mobile device. There was a time we used our mobile phone to make calls only. Ok, we did some text sending via sms. But that was it. Nowadays (if I look at myself) I do not use my phone to make phone calls. Yes, when I am in the car the … Continue reading "Oracle Mobile Analytics"

Streaming Global Cyber Attack Analytics with Tableau and Python

Streaming Global Cyber Attack Analytics with Tableau and Python

Streaming Global Cyber Attack Analytics with Tableau and Python

Introduction and Hacks

As grandiose a notion as the title may imply, there have been some really promising and powerful moves made in the advancement of smoothly integrating real-time and/or streaming data technologies into most any enterprise reporting and analytics architecture. When used in tandem with functional programming languages like Python, we now have the ability to create enterprise grade data engineering scripts to handle the manipulation and flow of data, large or small, for (more...)

Building a digital dashboard for small business

You take pains to make the most out of every dollar you earn. Do you have the same attitude for data?

Data that are used optimally for small businesses are great tools to help their owners come up with better decisions.

Digital reporting and performance dashboards can improve a business’ performance dramatically, but that’s only possible in your own situation if you use the right tools and strategies.

Here we will be taking up what (more...)