Analysts, Data Engineers and all data crew are always eager to offer the best set of analytical tools, qualified data, a good performance and agility when delivering data products to the user areas. And when it comes to KPI’s, the interest is a bit higher, because if you’re not tracking your indicators correctly, you may […]

January 12, 2021

|

by: Greg.suk

|

Categories: Code, Coding, dbt

Anyone who has worked with dbt knows that one of the most powerful features is packages. Packages allow you to reuse code across multiple projects in an organization. Packages can be installed from other projects in your organization, or by using the dbt hub you can install packages from the open-source community and Fishtown Analytics. [...]

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

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

April 18, 2019

|

by: Craig Coulter

|

Categories: Cloud, Code, Oracle, Oracle Cloud, Snowflake, Snowflake Computing

In this series, we are showcasing a fictitious midsize brokerage company moving their technical environment to the cloud. We have established previously, the company is experiencing contention issues, at both the user and hardware level. We will talk about the Oracle BI migration in a future blog; but first, we have to get the data [...]