Data Analytics 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

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste

By Deiby Gómez In this article, we’ll explore how to analyze the load and usage of a Snowflake warehouse to uncover opportunities for reducing credit waste and identifying overloaded warehouses. We’ll use the Prismafy tool, which generates detailed reports in just a few minutes. Prismafy is free to use and supports external authentication, including username/password

How to Analyze Snowflake Warehouse Performance and Reduce Credit Waste Read More »

Data Analytics, Data Warehousing, Snowflake, Snowflake Computing

eamwork in data project management, like rowers in sync, is crucial for success. Discover strategies to keep your data projects on track.

7 Key Strategies I Learned from 5 Years in Data Project Management

By Kristi Smith Effective data project management is key to the success of any data project. Over the past five years of managing these projects at Red Pill Analytics, I’ve learned that having the right strategies in place makes all the difference. Here’s what I’ve found works best: 1. Define Clear Objectives Start with a

7 Key Strategies I Learned from 5 Years in Data Project Management Read More »

Data Analytics, Elastic Delivery, project management, Team Collaboration

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

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