Business Intelligence Archives - Red Pill Analytics

Silhouette of a person demonstrating how to combine filters in Looker with creative lighting effects.

How to Combine Advanced and Custom Filters in Looker Studio

By Kristi Smith Note: Looker, now part of Google Cloud’s Looker Studio, remains a powerful BI tool for creating dashboards. While this guide focuses on combining filters in Looker, the steps also apply to Looker Studio environments. Matches Advanced Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive, […]

How to Combine Advanced and Custom Filters in Looker Studio Read More »

Business Intelligence, Data Analytics, Data Visualization, Looker, Uncategorized

The reflection of the sky in the image of a glass building

Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers

We have a small project with four layers: 1. Raw — incoming raw data2. Validation —Relationship and data validations. Transformations into facts and dims3. Reporting — joining facts and dims to meet presentation requirements4. Business Application — presentation layer. Views, with security where needed, of the reporting objects When we added relationship tests between project

Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers Read More »

Business Intelligence, Data Engineering, dbt

Coin-operated binoculars facing a foggy seascape, symbolizing the exploration of data visibility with Looker.

Managing Snowflake Data Warehouse Compute in Looker

In a recent blog titled Managing Snowflake Data Warehouse Compute in OBIEE, I explained how to assign application users and roles to use designated compute clusters (warehouses) in Snowflake. The idea of specifying a Snowflake warehouse on a per user (or groups of users) basis is not specific to OBIEE and can be achieved with

Managing Snowflake Data Warehouse Compute in Looker Read More »

Business Intelligence, Cloud Computing, Data Warehousing

Managing Snowflake Data Warehouse Compute in OBIEE

How to Dynamically Set a Snowflake Virtual Warehouse Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouse instance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in

Managing Snowflake Data Warehouse Compute in OBIEE Read More »

Business Intelligence, Cloud Computing, Data Warehousing, Looker, Snowflake

A close up photograph of a mix of blue paint colors blends together.

OAC Extending Dimensional Attributes by Blending Data

Blending Data in Oracle Analytics Cloud allows us to share additional dimensions or measures from one data set with those from another, without having to do complicated metadata modeling using RPD functionality. This is a great feature for user-sourced categorizations and can empower users to utilize Data Visualization instead of forcing them to export into

OAC Extending Dimensional Attributes by Blending Data Read More »

Business Intelligence, Cloud Solutions, Data Analytics

An abstract image of hexagonal purple and blue gradient

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

This post is part 4 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). The previous posts are: Post 1: An intro to BVT Post 2: Setting up BVT Post 3: Running the Tests Interpreting the BVT Results As described in my third post in this series, here’s how to

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

Business Intelligence, Code, Data, OBIEE, Software Testing, Technical Tutorials

The year "2018" is written on the skyline in trails of fireworks.

Double down on Red Pill Analytics at Collaborate 2018

Red Pill Analytics is looking forward to placing some bets in Las Vegas for Collaborate18 on April 22–26, 2018. We are honored to be joining the amazing lineup of presentations and panels filled with the latest tips and information about various Oracle topics. Along with presenting Red Pill Analytics likes to take an active role

Double down on Red Pill Analytics at Collaborate 2018 Read More »

Analytics, Big Data, Business Intelligence, Cloud Computing, Data Analytics, Industry Events, Oracle, Red Pill News

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

Hunters Eat Better Than Gatherers

My last few blog posts have discussed how data failure happens, and how we can change failure into success (with a little economic thinking). Continuing with that train of thought, in this post I’ll be discussing how we can better implement analytic solutions by challenging the convention of requirements gathering. Don’t “Gather Requirements”. Hunt for

Hunters Eat Better Than Gatherers Read More »

Analytics, Business Intelligence, IT Management

BI-dentity Crisis

I had just gotten out of a discovery meeting with a client when she said “I’m sure we’re the worst you’ve seen”. The goal of the meeting was to better understand the process they were using, the data source, and how they were consuming that data. Turns out that data was entered into Share Point

BI-dentity Crisis Read More »

Analytics, Big Data, Business Intelligence, Data Science, Strategy, Tips