Staff
Since ‎01-05-2015
‎05-20-2023

My Stats

  • 36 Posts
  • 0 Solutions
  • 0 Likes given
  • 15 Likes received

bdavolls's Bio

Badges zlebowitz Earned

View all badges

Recent Activity

Knowledge DropLast tested: Aug 2, 2019Minimize joinsBecause in most scenarios, the most granular table usually has the most valuable information, and is therefore the most likely one to always be necessary in your queries! For example, for a B2B SaaS...
Let’s say I have graph on a dashboard that shows sales over time: In this example, I’m looking at 90 days of daily data. Daily seems like a reasonable granularity for a 90 day time frame. But what if I filter down the dashboard to 3 days? Wouldn’t it...
With the release of Big Query’s Standard SQL dialect, it’s now much easier to model nested data sets in LookML.For a quick primer on how nested and repeated files work in BigQuery, and why they’re valuable, take a look at Daniel’s post.You can also h...