Google Maps in DataStudio just don’t provide the granularity you need when you’re looking at data like COVID cases or election results – data that is collected and acted on at the county level. Without good maps, you’re stuck with presenting data in tables and that’s just not effective in communicating quickly and clearly. EvenContinue reading “Mapping Data to Counties with BigQuery”
Category Archives: Uncategorized
Understanding AB tests for different size groups
Only in textbooks do we get simple problems and perfect conditions. A very common challenge is that we need to compare results from groups of different sizes. A marketing team runs an AB test to 40,000 people. 39,000 get the old offer and 1,000 a new offer. Should the team switch to the new offerContinue reading “Understanding AB tests for different size groups”
Quick-n-dirty BigQuery Storage Cost Estimates
Managers and finance people always want to know how much a project costs. Here’s a quick copy-paste query you can run to estimate storage cost. /* Set your cost per GB per month*/ DECLARE monthlystoragecostperGB NUMERIC DEFAULT 0.02; SELECT table_id AS Table_Id, TIMESTAMP_MILLIS(creation_time) AS Creation_Time, TIMESTAMP_MILLIS(last_modified_time) AS Last_Modified_Time, FORMAT(“%’d”, row_count) AS Row_Count, /* BQ storageContinue reading “Quick-n-dirty BigQuery Storage Cost Estimates”
Variable Costs Can Shut Your Project Down
One week after we started using BigQuery, the head of IT came calling? “What are you doing? Did you know you spent $200 yesterday in BigQuery? How long is that going to go on?” Even though he knew we had a major project, he was surprised about the expense. Our team of two laughed toContinue reading “Variable Costs Can Shut Your Project Down”
BigQuery: Should I UPDATE rows?
BigQuery example of date partitions working with materialized views
Useful data analysis techniques and results 