SQL Best Practices

Create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with formulas, formatting, and financial modeling conventions.

Design database schemas, plan data migrations, optimize queries, and model data relationships using expert analysis and automated tools.

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

Define, track, and interpret product metrics across discovery, growth, and mature product stages using frameworks like AARRR, North Star, and HEART.

Enables the Google Analytics Data API, authenticates via gcloud, and creates customized reports using the v1beta client library.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.