16 business prompts
Data engineering and quality
Make data reliable enough to use.
A question to explore
Which data quality issues can change the analysis?
A practical way to begin
Start with a question you can check.
Profile keys, row counts, types, missing values and join cardinality. Retain source lineage and concrete exception records so a correction can be checked.
The collection
Find your next question.
Analysis, interactive Apps and repeatable Actions. Choose the outcome first.
Data engineering and quality
- Audit missing values in business dataField completeness issue tableAnalysis
- Find duplicate business records safelyDuplicate groups for reviewAnalysis
- Build a data freshness dashboardData freshness AppApp
- Detect incoming dataset schema changesSchema change ActionAction
- Reconcile a dashboard metric to source recordsMetric reconciliation variance bridgeAnalysis
- Check join keys before combining datasetsJoin key integrity reportAnalysis
- Find invalid values against business rulesBusiness rule violation reportAnalysis
- Standardize reporting timezones and date cutoffsDate boundary variance tableAnalysis
- Map which reports depend on a data ModelModel dependency tableAnalysis
- Identify expensive analytical SQL patternsRanked SQL improvement proposalsAnalysis
- Find orphan records in related business datasetsRelationship integrity findingsAnalysis
- Track analytical workload by query categoryQuery workload distributionAnalysis
- Find conflicting metric definitions across teamsMetric definition difference tableAnalysis
- Detect data grain mismatches in a reportGrain mismatch evidence reportAnalysis
- Validate data after a warehouse migrationMigration comparison scorecardAnalysis
- Build a Google Cloud cost and activity AppOne editable cost and activity review AppApp
From a question to useful work
Start with the data.
Build from what you find.
Choose a prompt, bring permitted inputs, and review the result. A useful analysis can become an App for your next review or an Action with configured repeat execution.