Efficiency - Reuse - Do you create a report whenever you need a number from a system?

Last updated by Brady Stroud [SSW] 7 months ago.See history

Whenever you need a number from a system you should think of how you can create a report, so next time you can press a button to get the result.

If you found yourself doing ad-hoc reports, or random SQL queries, a few years ago, the best thing to do was to make sure the boss knows you could not find the data you needed, so he could commission a new report to be built.

Since 2015, the best practice is instead to jump into Power BI and build the report yourself.

Figure: Bad example - Can't build it yourself, sending an email to your boss for a number

Power BI
Figure: Good example - Sate your own curiosity with Power BI

See Ulysses' video on how Power BI is the best tool for this:

Video: Power BI - Decisions based on facts: A Real World Look at Power BI (1 h 6 m)

We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS