Skill UI

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.

This guide provides an expert framework for implementing robust analytics tracking, ensuring all data collected is actionable. It covers core principles, event naming conventions, defining key user actions (e.g., signups, purchases), and practical setup using industry tools like GA4 and Google Tag Manager (GTM). Use this when auditing existing tracking, defining conversion funnels, or measuring marketing campaign performance.

Provides a structured, actionable review of Power BI reports across their entire lifecycle—from development to active use. The tool assesses report effectiveness, usage adoption, data performance (load times), and structural integrity. It generates a prioritized list of findings and concrete recommendations, helping users determine if reports are worth maintaining, optimizing, or retiring.

An interactive workflow designed to audit and standardize naming conventions within Power BI semantic models stored as TMDL files. It ensures that tables, columns, measures, and display folders adhere to consistent, human-readable, and business-aligned standards. The tool guides users through gathering critical business context before auditing and applying complex, cross-file reference updates to maintain data integrity.

A static analysis tool that audits SQL code for common cost and performance anti-patterns (e.g., full-table scans, Cartesian joins). It calculates a query health score (0-100) for data warehouses like BigQuery, Snowflake, and Redshift, providing a prioritized, actionable plan with concrete fixes and estimated cost savings. Essential for FinOps and data quality assurance.