Why should BAs understand basic indexing concepts?

< 1 min read

Understanding indexing helps me design reports that load fast and are usable for business teams.
If I request filters on non-indexed columns, dashboards can become very slow.
In a transaction report, filtering by customer_name caused delays.
I changed the requirement to filter by customer_id which was indexed.
It also helps me write better SQL when validating data during UAT.
I avoid using functions on indexed columns because it breaks index usage.
When performance issues occur, I can explain root cause clearly to engineers.
So I don’t implement indexes myself, but I ensure requirements are performance-friendly.

Power BI Essentials