OAC has a nice button for a person to unsubscribe within an Agent itself. But this required a person to navigate to the catalog to find the agent and look inside the details of the agent.  Seems like a lot of steps to me. But what if you want to enable this capability for an [...]

October 19, 2020

Are you considering a cloud-native data warehouse? Our experts debate the differences between Snowflake, Redshift, and BigQuery. Prefer to listen? Watch the Stump The Experts webinar on our Youtube channel. We are new to cloud data warehousing. We are considering Snowflake, Redshift, and BigQuery. What are some things to consider? Neal Achord Red Pill Consultant [...]

September 28, 2020

Moving your data warehouse from on-prem to the cloud? Our experts discuss data lake and data warehouse building in AWS. Prefer to listen? Watch the Stump The Experts webinar on our Youtube channel. Our data warehouse is on-prem at the moment, but we are starting to evaluate moving it to the cloud. We are already [...]

July 29, 2020

Yeah. Yep. Big hero moment. (Captain Marvel 59:58) Good news is hard to come by these days, so it's nice when we have something to celebrate. The world, despite the doom, does go on. So when we got the news that Stewart Bryson (CEO of Red Pill Analytics) had been given the title of Data [...]

April 23, 2020

Here we have created a Dynamic Visualization based on the Dimensional Hierarchies of Country -> State -> City. When Country is selected in the Filter, the Visualization shows the States for the specified Country. When State is selected in the Filter, the Visualization shows the Cities for the specified State. Here is how it works. [...]

April 9, 2020

COVID-19 has created an anxiety-ridden week. With the chaos of preparing to quarantine over (hopefully), what’s next? If you’re looking for a way to be productive at home, we have an answer - we’ve taken our canceled and postponed live events and converted them to online educational opportunities. With a worldwide pandemic at our heels, [...]

March 26, 2020

I recently downloaded Oracle Analytics Desktop (OAD) to check in on what's new. The last time I used Oracle's desktop tool, it was called Data Visualization Desktop; I figured they must have made some updates over the last few years. I was not terribly impressed with the original application (at least early versions of it), [...]

March 10, 2020

Google BigQuery has neat functionality that allows users to schedule queries in standard SQL, DDL or DML statements. Additionally, you can set them to run on a recurring basis. This can be great for light transformations; however, if more comprehensive transformation and automated regression testing is needed dbt (data build tool) is an affordable solution. [...]

March 4, 2020

Looker gives users the ability to swap between dimensions or measures in a visualization by the use of Liquid Parameters. To learn more, explore Looker’s documentation on Liquid Parameters here.  Currently, when a user selects measure from the parameter filter, it does not pass through the value format given for that measurement. In the following [...]

February 11, 2020