September 28, 2020

|

by: Renee Miller

|

Categories: AWS, Databases, Redshift, Snowflake, Tips

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

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