March 26, 2020

|

by: Renee Miller

|

Categories: dbt, Events, Oracle, Red Pill Analytics' Tips, Red Pill News, Tips

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 10, 2020

|

by: GregSuk

|

Categories: Analytics, Oracle Analytics, Snowflake, Snowflake Computing

I recently downloaded Oracle Analytics Desktop (OAD)12.2.5.4 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 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 16, 2019

|

by: Travis Brannan

|

Categories: Code, Data, Redshift

The easy way Before I learned how to load only the columns I needed from DynamoDB into Redshift, I created an entire glue job to load a single table. I’d like to prevent you from making the same mistake. But to understand how much easier the easy way is, you will first need to understand how [...]

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