Here’s the situation: you’ve spent days crafting a dynamic period over period (PoP) selector that updates automatically with whatever period length and number of prior periods the user wants to see. It’s beautiful! It passes all the tests! Oh…and also…

It requires 3 specific dimensions and filters to be selected or it won’t work properly.

Pictured: Business User who left the enablement session early trying to remember which “Created Date” field to pivot on if they want the “Dynamic PoP Selection Tool” to display the correct values for the “Total Gross Revenue” field. (Photo by Tim Gouw on Unsplash)

Quick Start, to the rescue!

Explores in Looker have an excellent feature called Quick Start. This feature allows a LookML developer to create shortcuts to specific queries at the explore level. Why is that great for the complex, dynamically-generated queries you’ve painstakingly built? You can now pack all of the filters and fields necessary for your feature to function properly into a Quick Start.

Hands-on Tutorials

I’ve always had trouble distinguishing between really specific genres in music by the sound alone — I’m looking at you, metal! So, I turned the problem of classifying genre into a Digital Signal Processing problem. Let’s get processing!

[I should preface this by saying I have a master’s degree in music performance, am a recording artist, and self-publish my music, so this is where my interest in the subject began.]

Photo by Adi Goldstein on Unsplash

What is the problem and why is it important?

Genre classification is important for music distribution platforms (CD Baby, Distrokid, and Songtradr are some you may be familiar with). Good genre assignment helps artists and connect to new audiences…

Before I started data science, I was working with audio constantly: editing podcasts, mixing 50-track sessions of middle school band players, arranging the “Fairytale” theme from Shrek, and the list goes on. As an audio editor, you 100% absolutely need shortcuts or you will decompose in your chair while working on a large project. There’s just not enough time to click everything. So, when I learn a new technology like Jupyter Lab, one of the first things I do is find every shortcut I can so I don’t wind up clicking my way to an early grave.

Pictured: Me trying to clean up a Jupyter Notebook without using shortcuts. (Photo by Anne Nygård on Unsplash)

Let’s dig into…

“Hello, World!”

It’s the first program you’ll learn to run in just about any coding language. It was initially referenced by Brian Kernighan in his book, A Tutorial Introduction to the Programming Language B. It’s also a symbolic statement — you’re stepping into a previously unknown world, so you might as well be polite and say hello to it before you start poking and prodding at the structure of it and squashing bugs along the way. Poor bugs.

Photo by Gabriel Manlake on Unsplash

Want to read this story later? Save it in Journal.

Since 2012, I’ve considered myself a professional freelance musician. Here’s an intentionally…

Eric Heidbreder

I’m a Chicago-based analytics consultant at Analytics8 who is certified in Looker and Qlik. I’m also a bassoonist and songwriter. Someday, I’ll own a Pug.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store