Power BI Practice Spreadsheet Audit
Prompts
-
Power BI Dashboard Decision Usefulness and Usage Audit
Check what people actually use.
-
Power BI Dataset Duplication and Certified Source Audit
Find competing versions of the same data.
-
Power BI Row-Level Security Rules Review (Defensive)
Review the row-level security roles on your own Power BI model for gaps, overlaps and test coverage, with a checklist for safe validation.
-
Power BI Date Table and Time Intelligence Check
Check a Power BI model's date table, relationships and year-to-date style measures for gaps and wrong comparisons, with test cases to verify.
-
Power BI Naming Conventions and Field Folder Audit
Review table, column and measure names in a Power BI model for clarity, consistency and hidden clutter, then set a naming standard.
-
Power BI Slicer and Filter Interaction Audit
Check how slicers, page filters and visual interactions in a Power BI report change numbers, to find confusing or misleading filter behaviour.
-
Power BI Gateway and Data Source Credential Hygiene Audit
Review data sources, gateway use and stored credentials behind your Power BI reports for ownership gaps and risk. Defensive review of your own setup.
-
Power BI Calculated Column Versus Measure Usage Audit
Examine calculated columns and measures in your Power BI model to find misplaced logic that bloats size or gives wrong totals, with a move plan.
-
Power BI Report Handover and Documentation Audit
Check that a Power BI report has the owner, sources, definitions and refresh notes a successor needs, and create a one-page documentation template.
-
Power BI Visual Choice and Misleading Chart Audit
Review the charts on a Power BI page for misleading scales, poor chart types and clutter, and suggest clearer visuals matched to each question.
-
Power BI Relationship Cardinality and Ambiguity Check
Examine the table relationships in a Power BI model for wrong cardinality, many-to-many risks and ambiguous paths that inflate or hide totals.
-
Power Query Transformation Steps Audit for Data Quality
Review the Power Query steps behind a Power BI dataset for risky type changes, silent row loss and hard-coded values, with a verification plan.
No prompts match those filters.