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

June 27, 2018

|

by: emily.carlsen

|

Categories: Code, CSS, Data, Google, HTML

Google Data Studio (https://datastudio.google.com/) is a pretty powerful and yet easy to get started with tool to visualize data from a variety of sources (everything from CSV files, to large scale databases). And it lends itself to presenting those graphs in other places on the web and thankfully there is an embed option using the […]

March 28, 2018

|

by: emily.carlsen

|

Categories: Code, Javascript

GitHub Repo: https://github.com/emilyplusplus/js-keylogger-data-viz   I wanted to come up with an interesting data analytics blog post and I started looking for data cause well… garbage in, garbage out. I wanted to start with a good solid base of semi-interesting data so I could make some cool visualizations and play with some JavaScript based charting libraries (specifically Chart.js). […]