To remove duplicate table rows it is typically better (i.e. faster) to create a temporary table that contains all of the distinct rows from a…

February 8, 2019 • 2 minute read

If only Kodak or Blockbuster could have seen into the future, what would they have done? If they’d had access to the latest predictive analytics…

February 6, 2019 • 6 minute read

Like Artificial Intelligence, predictive analytics is not a new concept. It has been around for many years and, like AI, it has recently come to…

January 30, 2019 • 6 minute read

As a credit card provider, you’ve got less than a six-month window to win your customer over. If your customer doesn’t use your credit card…

January 30, 2019 • 5 minute read

Data has long been the lifeblood of manufacturing. Companies have used it to increase efficiencies, improve performance and productivity, and reduce waste. With the advent…

January 23, 2019 • 8 minute read

Big data analytics is near the top of every CIO’s agenda. All companies are faced with an explosion in the volume and variety of data…

January 16, 2019 • 7 minute read

The LISTAGG function transforms non-null values from a group of rows into a list of values that are delimited by a configurable separator. LISTAGG can…

January 11, 2019 • 2 minute read

The amount of data in the world continues to grow at an incredible rate. IDC suggests that, by 2025, there will be 163ZB (zettabytes) of…

January 9, 2019 • 7 minute read

Artificial intelligence or AI is fast becoming a key technology for the life sciences field. Combined with advanced analytics, it has almost limitless potential to…

January 4, 2019 • 8 minute read

Artificial Intelligence (AI) has been one of the key buzzwords in the technology industry over the last few years. From enabling devices on the Internet…

January 3, 2019 • 1 minute read

We live in an age of unequaled access to data.  By some estimates, the average company has between 150 and 400 terabytes of information stored….

December 19, 2018 • 6 minute read

For almost as long as there has been business, there has been business analytics. Frederick W. Taylor is often credited with introducing business analytics in…

December 18, 2018 • 9 minute read