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 […]
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 […]
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, […]
I think it’s fair to say that I like models. Whether manifested with Legos, metadata, or economic indicators, I love seeing how inputs can affect outputs. So, when I discovered the forecast capabilities in the R suite, I couldn’t wait to give it a go. Never Tell Me the Odds! Many of the companies I have […]
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 […]
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, […]
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? […]