The data for this dashboard report was randomly generated in visual studio using C# script. And then loaded into SQL Server tables for later processing by Power BI.
Creating the tables in SQL Server.
Adding keys to form relationships between tables. This makes the Power BI process much smoother.
The data being used for the dashboard will come from the left hand side of this diagram.
At first glance the dashboard has a count of distinct donors and donations. Filters at the top left corner can be used to focus in on data from a specific time or donation method.
Donation performance is sorted by profit descending in bar chart. Money donated per suburb is sorted by descending order. A matrix includes the finer details of donation inflows. The gauge displays the total amount of donations received relative to a preset target.
Selecting December from the month list, all the metrics on the dashboard responded accordingly. The only thing that does not respond is the target on the gauge. This is because a monthly target is not set in place.
Going down further into December by clicking on ‘Fundraising and Events’ within the slicer.
Multiple months and methods can also be selected if one wishes to view aggregated data.
Selecting the bar for ‘Cash Collection’ within the bar chart shows the same numbers as selecting the same option within the Donation Method slicer. However now the data is shown as a proportion, rather than absolute.
Selecting a suburb from the right hand side bar chart shows the specific details for ‘Clayton’ during ‘November’.