March 4, 2020

|

by: angie.brown

|

Categories: Code, Coding, dbt, Modernize Not Migrate

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. [...]

February 11, 2020

|

by: victoria.davis

|

Categories: Code, Coding, Looker

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 [...]
Event Storming is the creation of Alberto Brandolini, a lightweight but powerful workshop approach for software development and domain-driven design. Using sticky notes, experts like software developers and product designers work together at an accelerated pace to focus, rethink, reframe, and bounce ideas off each other. Event Storming is a methodology meant to: Be quick, [...]

October 30, 2019

|

by: Renee Miller

|

Categories: Data, Data Visualization, Looker

Looking at Looker, Part 2 By Renee Miller and Victoria Davis Why should we talk about Looker? With Looker JOIN19 a week away, we thought we’d dive deeper into the Looker platform (See Part 1 here). Earlier this year, Google Cloud announced a plan to buy Looker for $2.6 billion, making it even more of a [...]

October 10, 2019

|

by: Kristi Smith

|

Categories: Analytics, Looker

Matches (Advanced) Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive, once you get the hang of the syntax. As always, if you run into an issue or need more context, Looker’s documentation is a great place to start. Advanced filters allow you to specify an expression for [...]

October 7, 2019

|

by: Renee Miller

|

Categories: Events, Looker

Looker is at it again, bringing together the best data enthusiasts on the planet. Since we had such an absurdly enjoyable time at last year’s JOIN (read about it in our blog here), we were hyped for pre-conference celebration. Consider this our tailgating. Mike Jelen, representing Red Pill Analytics at Looker JOIN 18, takes home [...]

September 5, 2019

|

by: Renee Miller

|

Categories: Events, Red Pill Analytics

Let's Talk Oracle OpenWorld 2019…But first Before we get into OpenWorld, we have some exciting (actually… groundbreaking) news to share. Stewart Bryson, Red Pill’s CEO and Founder, was announced as a recipient of the Oracle Groundbreaker Ambassador Award. Now, what does that mean, exactly? Individuals are nominated based on their impact on the developer community [...]

August 7, 2019

|

by: Stewart Bryson

|

Categories: Analytics, Confluent, Gradle, Kafka, KSQL

This blog, Deploying Kafka Streams and KSQL with Gradle – Part 3: KSQL User-Defined Functions and Kafka Streams was originally posted on the Confluent Blog on July 10, 2019. See the original source here. Building off part 1 where we discussed an event streaming architecture that we implemented for a customer using Apache Kafka, KSQL, and Kafka Streams, and part 2 where we discussed how [...]