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

November 7, 2017

|

by: Michelle Kolbe

|

Categories: Code, Javascript

This post is part 2 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Post 1 with an intro to BVT, can be found here. Obtain the BVT tool Download the latest version of BVT from Oracle. http://www.oracle.com/technetwork/middleware/bi/downloads/bi-bvt-download-3587672.html Unzip the download into a directory on your computer. To save yourself typing later on, […]