Power BI Report Examples and Demonstration Video
These are just a few examples of reports that Sherlock Resources created in Power BI.
(These were created with public data.)
Interactive Capabilities and Forecasting
Power BI reports are not static like an Excel file. They are dynamic and interactive. Here is Sherlock's brief video demonstrating a few of the capabilities of Power BI. It won't take long; it's only about 6 minutes. It will be much better if you click the "Full Screen" button at the bottom right of the video. Otherwise, it's hard to see the data in the Power BI visuals.
If you don't want to watch the video, below are some screenshots to demonstrate some of the interactive features and the forecasting capability of Power BI. (It is probably much quicker and easier to see and understand from the video.) If you watched the video, no need to read the information below since these capabilities were demonstrated in the video; skip to the next page:
Below is an example of the Filtering interaction. In the Budget Report shown above, when the user clicks any year button at the top, the charts adjust to show the data for that year. Here is how the report above looks in Power BI if you click on 2023 ( in the top right of the report ):
Notice that after clicking the 2023 button, the amounts have all changed including the scales on the axes where appropriate to show just the data for 2023 rather than all the data (2018 through 2023). The Actuals to Budget metric now shows 0.72 for 2023 versus 0.91 when all years are included.
Power BI can also quickly highlight or filter the other visuals on the page based on your selection in any of the visuals, not just the filters or slicers:
In the screenshot above, I clicked on the Personnel Services GL Category in one visual. It highlighted not only the relevant columns in that visual, but also the relevant portions of all the columns in all the other visuals to show the portion of each column attributed to the selected category. Also notice that the Actuals to Budget metric changed from 0.91 to 0.92, now displaying the metric for just the selected category.
This screenshot also shows yet another interactive feature of Power BI, the Tool Tips. When I hover the cursor over the Fire Department expenses column in the bottom left visual, Power BI automatically displays the Tool Tip showing the department name, total actual expenses for that department, and the actual expenses for the selected GL Category in that department. So, you can quickly see that the actual expenses for Personnel Services in the Houston Fire Department were $2,648,822,963.
Here is another example showing Power BI's Tool Tip feature:
The screenshot above shows a Tool Tip on a forecast in the visual on the top right. The Tool Tip shows the year the forecast is for, the forecast, and the upper and lower bounds. The current bounds are for a 95% confidence interval, but it can be adjusted to show a different confidence level. If you are interested in forecasts, there is another example of Power BI's forecasting capability back in the second report on this page, the Checkbook report. The top left visual on that report shows Total Amount 2018 to 2023 plus a forecast through 2024. If I hover over any point on that forecast line in Power BI, the Tool Tip appears showing the selected month and year, the forecasted value, and the upper and lower bounds (95% confidence).