January 24, 2017

|

by: Fahd Saeed

|

Categories: Red Pill Analytics' Tips, Tips

We all get by with a little help from our friends. Let us share a tech tip with you and offer you an opportunity to learn more from the Red Pill Analytics team. I came across a table with some troublesome duplicated rows and wanted to remove these dups so I used an old query of […]

January 23, 2017

|

by: pete.scott

|

Categories: GitHub

Last time I blogged about getting started with the new Git VCS functionality in Oracle Data Integrator (ODI) 12.2. Then, I promised to write a bit on integrating Git into the deployment process. Firstly, a disclaimer. I used to work for a IT services company that also ran one of the largest ITIL training organizations […]

January 11, 2017

|

by: Phil Goerdt

|

Categories: Analytics, Data Science, OBIEE, Oracle

As I’ve been discussing in my last few blogs, it’s possible to start using OBIEE for analytics, rather than the standard operational reporting and BI that is commonplace. Data science has been quite the buzz the last few years, and no doubt about it, data scientists can bring great value and understanding to an organization, […]

December 20, 2016

|

by: Phil Goerdt

|

Categories: OBIEE, Oracle, Oracle 12c

Clustering. Whether we’re talking about headaches, compute nodes, or uh, well, I’ll let you fill in the blank… isn’t anything worth doing, worth doing together? Clustering can be a powerful tool for understanding the relationships between data, and in this post I’ll walk through how to use the OBIEE 12c Advanced Analytics Cluster Function. As […]

December 15, 2016

|

by: pete.scott

|

Categories: GitHub, ODI

Last time I went through some of the basics about getting the latest patch-set of ODI to connect to a GitHub.com VCS repository. Today I will talk a little about versioning our ODI development in Git. Navigator The first point to make is that we can select the objects we wish to version-track in Git, […]

December 13, 2016

|

by: Phil Goerdt

|

Categories: Oracle 12c, Tips

Trending Up Using the Trend Line Function in OBIEE 12c One of the new features in OBIEE 12c is the availability of an “internal” R instance. This instance will allow the execution of R scripts, and the folks at Oracle have been kind enough to include some functions out of the box with the OBIEE 12c […]

December 9, 2016

|

by: pete.scott

|

Categories: GitHub

Working as an IT Professional I need to adhere to standards; working in consulting these standards may vary between customer organizations. Some places are Agile shops, some are classic waterfall, others use whatever flavor of methodology that suits them best. Two things are a given though: We use source control to protect and version the […]

The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” datasets–think census, stock market, and employment and inflation rate data–known to be publicly available? […]

November 16, 2016

|

by: GregSuk

|

Categories: Analytics, OBIEE, Oracle, Repositories, SQL

Recently I had a couple of interesting situations pop up in OBIEE 11g regarding dates. No not the edible kind, but the calendar kind. Specifically where it involves fact measures that are valid for a period of time beyond what the date id(s) on the rows in the table allow. The first scenario I will […]