March 6, 2018

|

by: emily.carlsen

|

Categories: API, Arduino, Cloud, Functions, Google Cloud Platform

GitHub Source Code: https://github.com/RedPillAnalytics/gcloud-iot-helper “What the? How? Why? Why isn’t this workingggg…?!?” -Me Embedded electronics is a personal hobby of mine; the ability to write low level code, compile it, run it and see physical changes in the real world (spinning motors, flashing LEDs, sound, encoder input, etc.) is an incredible feeling. With the emergence […]

January 19, 2018

|

by: Phil Goerdt

|

Categories: Big Data, Data

What HBR’s Winter 2017 OnPoint Tells Us About Business & Data It was a November evening that I was at the grocery store, waiting in the line to check out when I saw the latest issue of Harvard Business Review’s OnPoint publication. For those that are unaware, OnPoint is a seasonal publication that focuses on a particular […]

January 6, 2018

|

by: Mike Fuller

|

Categories: Cloud, Cloud Computing, Red Pill News

Written by: Phil Goerdt and Mike Fuller Several years ago, I was working on an enterprise reporting project at a Fortune 15 company at about the same time that cloud-based services were really starting to catch on. During one of our meetings, a colleague of mine on the client side asked me to “explain what […]

November 27, 2017

|

by: Mike Fuller

|

Categories: Data, Git, Looker, Version Control

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 20, 2017

|

by: Phil Goerdt

|

Categories: Big Data, Cloud, Data, Google Cloud Platform, Google Data Studio

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 17, 2017

|

by: Mike Fuller

|

Categories: AWS, Data, Snowflake Computing

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 7, 2017

|

by: Michelle Kolbe

|

Categories: Code, Javascript

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. http://www.oracle.com/technetwork/middleware/bi/downloads/bi-bvt-download-3587672.html Unzip the download into a directory on your computer. To save yourself typing later on, […]

October 25, 2017

|

by: Michelle Kolbe

|

Categories: OBIEE, Oracle

I have a report that works fine in OBIEE 11g but when upgraded to 12.2.1.2, 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 11, 2017

|

by: Mike Fuller

|

Categories: Red Pill Analytics' Tips, Snowflake, Tips

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. […]