
What are effective strategies to increase data literacy of modelsso that stakeholders can self-answer basic questions without digging deep into PowerBI semantic model?
Basic metric: the legacy report had calculation which counted total records against status field relating to engineering performance metrics.
Problem: My main annoyance is that I have to open the PowerBI report and read comments every time just to understand simple questions e.g. "what is the logic behind status being on hold, but work is still counted?"
It feels painful I can't remember the basic BI logic behind these reports despite working 2 years at current job and I feel the expectation of stakeholders is to know the answers on the fly as we "own" the reports.
Tried: I have tried creating read me pages, but stakeholders don't seem to read it. Added comments to measures but this means I have to open and load models just to answer question on the spot which doesn't inspire much confidence.
What advice would you give to improve literacy amongst stakeholders and what tools would you suggest making our lives easier?