POWER BI – CHARITY DASHBOARD

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.

2017-02-03 19_39_05-C__Users_Daniel_Desktop_Volunteers.txt - Notepad++.png

Creating the tables in SQL Server.

2017-02-03 18_03_20-SQLQuery1.sql - DANIEL.Charity (daniel-sa (54))_ - Microsoft SQL Server Manageme.png

2017-02-03 18_05_57-SQLQuery1.sql - DANIEL.Charity (daniel-sa (54))_ - Microsoft SQL Server Manageme.png

Adding keys to form relationships between tables. This makes the Power BI process much smoother.

2017-02-03 18_03_20-SQLQuery1.sql - DANIEL.Charity (daniel-sa (54))_ - Microsoft SQL Server Manageme.pngThe data being used for the dashboard will come from the left hand side of this diagram.2017-02-03 20_37_07-DANIEL.Charity - Diagram_0_ - Microsoft SQL Server Management Studio (Administra.png

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.

2017-02-05 17_25_28-Charity DashBoard - Power BI Desktop.png

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.

2017-02-05 17_25_35-Charity DashBoard - Power BI Desktop.png

Going down further into December by clicking on ‘Fundraising and Events’ within the slicer.

2017-02-05 17_25_47-Charity DashBoard - Power BI Desktop.png

Multiple months and methods can also be selected if one wishes to view aggregated data.

2017-02-05 17_26_04-Charity DashBoard - Power BI Desktop.png

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.

2017-02-05 17_26_16-Charity DashBoard - Power BI Desktop.png

Selecting a suburb from the right hand side bar chart shows the specific details for ‘Clayton’ during ‘November’.

2017-02-05 17_27_27-Charity DashBoard - Power BI Desktop.png

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with WordPress.com.

Up ↑

%d bloggers like this: