Red Pill Analytics, Author at Red Pill Analytics

Abstract image of lasers criss-crossing above internal computer hardware.

Securing Network Access for Snowflake Data Warehouse and Amazon S3

As technology moves further into a service-oriented (read: Cloud) world, people and enterprises alike need to ensure that securing their assets is taken seriously. Security has always been one of the first of topics covered before purchasing a cloud service which is why good cloud vendors typically spend more time securing their products than any […]

Securing Network Access for Snowflake Data Warehouse and Amazon S3 Read More »

AWS, Code, Data Integration, Data Warehousing, Security, Snowflake

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3

This post is part 3 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. Post 2 about setting up BVT to run, can be found here. Running the Test Against Both Environments We need to execute BVT twice with the same

Using Oracle’s Baseline Validation Tool with OBIEE — Part 3 Read More »

Business Intelligence, Code, Coding, Data Analytics, Data Integration, Java, JavaScript, OBIEE, Technical Tutorials

What’s the Big Deal with Big 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

What’s the Big Deal with Big Data? Read More »

Big Data, Data

A Jump to the Cloud

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

A Jump to the Cloud Read More »

Cloud, Cloud Computing, Red Pill News

Lookering at 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

Lookering at Version Control Read More »

Cloud Computing, Data, Git, Looker, Version Control

The Good, The Bad, and the Gorgeous

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

The Good, The Bad, and the Gorgeous Read More »

Big Data, Cloud, Data, Data Visualization, Google Cloud Platform

A library card catalogue showing multiple organization squares.

Bulk Loading Zone

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

Bulk Loading Zone Read More »

AWS, Cloud Computing, Data, Snowflake Computing

Using Oracle’s Baseline Validation Tool with OBIEE — Part 2

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,

Using Oracle’s Baseline Validation Tool with OBIEE — Part 2 Read More »

Code, JavaScript

TimestampAdd Error in OBIEE Migration from 11g to 12c

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

TimestampAdd Error in OBIEE Migration from 11g to 12c Read More »

OBIEE, Oracle

Using Oracle’s Baseline Validation Tool with OBIEE — Part 1

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

Using Oracle’s Baseline Validation Tool with OBIEE — Part 1 Read More »

Coding, OBIEE, Oracle, Oracle 12c