Red Pill Analytics Tips Archives

Architectural blueprint and project planning tools for data project specifications, featuring measuring tapes, levels, and drafting equipment on a vibrant orange workspace.

Mastering Data Project Specifications: A Strategic Guide

by André Deroide Data projects are helping organizations gain insights, drive efficiency, and keep a competitive edge in the age of big data. However, the complexity inherent in these projects can easily lead to misunderstanding, delays, misaligned outcomes, and unexpected results. Data Project Specifications serve as a critical roadmap to avoid these pitfalls. This guide […]

Mastering Data Project Specifications: A Strategic Guide Read More »

Proof that Less can be More

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.

Proof that Less can be More Read More »

Red Pill Analytics Tips, Snowflake, Tips

Installing Oracle Data integrator Cloud Service (ODICS)

Oracle Data Integrator Cloud Service is a new-ish cloud service from Oracle that allows us to run ODI as a platform in the Oracle Cloud. There are a lot of moving parts to this cloud service, so the first part of this article will cover creating the Oracle Cloud Database, The Java Cloud Service, and

Installing Oracle Data integrator Cloud Service (ODICS) Read More »

Cloud, ODI, Red Pill Analytics Tips, Tips

Checkmate for OBI is Now Free

For those of you in the Oracle Business Intelligence space, you have likely heard us or some one else talk about Checkmate in the past. We have several posts on our blog about Checkmate, as well as a YouTube playlist dedicated to it, so I won’t spend too much time in this article evangelizing it.

Checkmate for OBI is Now Free Read More »

Checkmate, OBIEE, Red Pill Analytics Tips, Red Pill News

Finding an Open Slip

Let’s pretend that you need to change ports within your OBIEE 12c instance due to new applications that natively install into ports that OBIEE is running. Or maybe you want to have the ports be the same as the OBIEE 11g ports. Whatever the reason, how do we go about changing the ports within the

Finding an Open Slip Read More »

OBIEE, Red Pill Analytics Tips, Tips

Are You Getting Your Point Across?

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. You spend all of this time and effort putting together an analysis to share with your users. But wait! Are your users able

Are You Getting Your Point Across? Read More »

Data Visualization, Oracle DV, Red Pill Analytics Tips, Tips

Duplicated Rows No More

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

Duplicated Rows No More Read More »

Red Pill Analytics Tips, Tips

Preparing Excel Data For Analysis

Whether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered.

Preparing Excel Data For Analysis Read More »

Big Data, Business Intelligence, Excel, Red Pill Analytics Tips, Tips, VBA