If you follow Red Pill Analytics at all, you know that we have our hands in a bit of everything when it comes to data and analytics; having the opportunity to work with various tools and technologies is one of the many benefits to working at RPA. One particular tool that we have found ourselves […]

November 27, 2017

Some tips, tricks and thoughts on using Google Data Studio Red Pill Analytics recently delivered a solution that exclusively used Google Cloud Platform. Our client, a marketing team at Google, wanted to know how they were engaging with users across several online channels. We used Google Analytics, YouTube Analytics, AdWords, among other sources via BigQuery to […]

November 20, 2017

Whether it’s an enterprise application, the automobile you drive, or your favorite tea kettle, seemingly everything in the world today produces data. This results in a need to transfer data to a place where people and technology can make sense of it. Typically, the faster data can be transferred and more data that can be […]

November 17, 2017

This post is part 2 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Post 1 with an intro to BVT, can be found here. Obtain the BVT tool Download the latest version of BVT from Oracle. Unzip the download into a directory on your computer. To save yourself typing later on, […]

November 7, 2017

I have a report that works fine in OBIEE 11g but when upgraded to, it gives an error stating: [nQSError: 22025] Function TimestampAdd is called with an incompatible type. This report has a SQL Expression in a filter that states: TimestampAdd(SQL_TSI_HOUR, 4.5, CURRENT_DATE) The problem is that we are trying to add hours onto […]

October 25, 2017

This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Overview of BVT With the 12c release of OBIEE, Oracle released a new tool called the Baseline Validation Tool or BVT. This tool allows you to run specific tests against your OBIEE reports, dashboards, and BI Publisher […]

October 19, 2017

Snowflake Data Warehouse release 2.11 (September 7, 2017) included the addition of an OVERWRITE parameter for the INSERT command. INSERT OVERWRITE effectively consolidates two commands, TRUNCATE TABLE and INSERT, into one. INSERT OVERWRITE also deletes the file load history and retains access control privileges on the target table; both of which are not insignificant details. […]

October 11, 2017

Fall is here and we are gearing up to head to San Francisco for Oracle OpenWorld, October 1–5. However, this year Red Pill Analytics, an analytics consulting firm, will also be participating in JavaOne, October 1–5. So what is JavaOne and why are we there? Let’s start by pointing out that Stewart Bryson, one of […]

September 27, 2017

Some of the best presentations at Oracle Open World are on User Group Sunday, on Oct 1st. It can be challenging to pay attention in sessions though when your stomach is growling because there’s no conference meal that day. Regional User Groups have the solution! Join regional user groups at the Children’s Museum next to […]

September 25, 2017

Fall is here and that means a trip to San Francisco is on the calendar for Red Pill Analytics. Once again, we are thrilled to be joining an amazing group of presenters at Oracle’s largest conference of the year, Oracle OpenWorld/JavaOne. Red Pill Analytics has six sessions, three at Oracle OpenWorld and three at JavaOne. […]

September 15, 2017