Siavash Kanani

Browse by source sorted by latest

Looker Studio Rolls Out Bins for Flexible Metric Buckets Trending ️‍🔥

Looker Studio Rolls Out Bins for Flexible Metric Buckets

7 months ago

New Looker Studio feature "Bins" allows for flexible metric bucketing with equal or custom sizes, simplifying data categorization and analysis. This enhances the creation of insightful visualizations and reports, marking a significant improvement over traditional CASE WHEN expressions.

How to apply Comparison Date Range to Bar Charts in Looker Studio

How to apply Comparison Date Range to Bar Charts in Looker Studio

8 months ago

Here's a workaround to apply Comparison Date Range to Bar Charts in Looker Studio using Data Blending.

BigQuery's SQL Toolbox Now Features GAP_FILL Function for Time Series Analysis

BigQuery's SQL Toolbox Now Features GAP_FILL Function for Time Series Analysis

10 months ago

BigQuery's SQL toolbox now includes the GAP_FILL function, designed to address missing data in time series analysis. GAP_FILL allows for seamless data interpolation, filling gaps based on specified criteria. This is particularly useful for datasets with missing data, such as daily sales tracking. Previously, gaps were handled using an array of all date values and a LEFT JOIN. The new function ensures continuous data flow for analyses.

Tired of spending too much time creating audits for your clients?

Tired of spending too much time creating audits for your clients?

Featured

Marketing Auditor simplifies your audit process, letting you generate comprehensive, white-label reports in just a few clicks. Save over 10 hours per report while analyzing 200+ data points and delivering 50+ pages of actionable insights. Customize reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides to showcase your expertise.