Showing posts with label RE Dashboards. Show all posts
Showing posts with label RE Dashboards. Show all posts

Wednesday, June 5, 2013

The Raiser's Edge Financial Dashboard Part III - Drill-Down Analysis

In our last post about the "Big Picture" on the Raiser's Edge Financial Dashboard we looked at the details on the main dashboard.  However, the dashboard and reporting application also has more than the one dashboard.  In this episode we will look at the drill-down capabilites of the application.

After the Tucamino Solutions Raiser's Edge Financial Dashboard opens, displaying the Main Dashboard with the charts, graphs, and data tables, the user can drill-down to get at more detail with most of the dashboard components. 

At the right is the first example.  When reviewing the 12 Month Period Comparison, the end-user may want to get more detail for a specific period.  When the user right-clicks with their mouse on a specific cell or header in the grid, they are presented with a menu of options.  As shown at the right, the end-user can view a list of gifts for the specific time period or a summary dashboard for that time period.

The Gift List, shown at the left, is an example of a drill-down report available in the Raiser's Edge Financial Dashboard. It provides a list of gifts for the end-user to view.  Most dashboard components with the dashboard application allow drill-down to a list of gifts.  This can be for a specific campaign, fund, time period, or other specific filters.  This drill-down report also provides summary statistics at the bottom of the report.  These gifts can be sorted by clicking on the column headers.


Once on the gift list report, there is further drill-down capabilities into data for the Raiser's Edge dashboard.  When the user right-clicks on a gift row, a menu is presented that allows the user to go to the gift or the constituent the gift is recorded under.  What is cool about this is that these menu options will open the forms from The Raiser's Edge, giving the end-user access to built-in Raiser's Edge functionality.  These forms will only be accessible when the user selects to sign-in to The Raiser's Edge via the RE:API module.  When SQL Server authentication is chosen, these menu options are not available. There is a benefit to each authentication method, such as not using an expensive RE concurrent license when chosing the SQL Server authentication.

As seen at the left, drill-down capabilities are available on the charts and graphs in the dashboard as well. For example, the user can drill down into a campaign and see the campaign details in the default Raiser's Edge campaign form via the RE:API integration.  In addition, further dashboards and reports are available via the other menu options, including the previously discussed gift list option.  If you like what the dashboard presents but want further drill-down capabilities, we can customize that and add these additional drill-down features.
One of the options for the drill-down capabilities for campaigns is to see an Active Campaign Summary dashboard.  This report and dashboard shows various summary statistics including how much has been raised, what % that is of the total goal, how much is expected due (pledge installments recorded in RE), and how much of the goal is forecasted, or committed (when adding total raised plus total expected from pledge installments).
In addition, there is a visual breakdown of how much has been raised per month over the last 12 months to see which ones may be trending in a positive or negative direction.

This post begins to highlight the power of a dashboard application.  Drill-down reports and dashboards can be created to give more detail and potentially give more information targeted at a specific role or individual to allow them to be more productive in their responsibilities.  In addition, we get an introduction to the integration possibilities with the RE:API and the custom dashboard application by being able to bring up campaigns, funds, constituents, and gifts in the out-of-the-box Raiser's Edge application-based forms.

If you want to get more information about the Tucamino Solution's Raiser's Edge Financial Dashboard application, go to the product page on our website.  You can find more products listed on our website as well..  You can request a download of the product, and many more, from our website.

Check out the other posts in our series at:
The Raiser's Edge Financial Dashboard Part I - The Overview
The Raiser's Edge Financial Dashboard Part II - The Big Picture
The Raiser's Edge Financial Dashboard Part III - Drill-Down Analysis
The Raiser's Edge Financial Dashboard Part IV - True Integration with The Raiser's Edge
The Raiser's Edge Financial Dashboard Part V - How to Extend It Further

Friday, May 31, 2013

The Raiser's Edge Financial Dashboard Part II - The Big Picture

In our previous article we talked about the why of the Raiser's Edge Financial Dashboard, an interactive reporting tool designed for a wide range of Raiser's Edge organizations and their employees.  In our first more detailed peek into the Raiser's Edge Financial Dashboard reporting capabilities, we are going to focus on the "Big Picture" the dashboard presents. 

The Home Page, or Main Dashboard, pictured at the right is a collection of data tables/grids and graphs displaying information in such a way that an executive can get a clear idea as to how much money has been raised, where it has been allocated, as well as performance compared to last year or previous years.  In addition, it shows a forecast as to how much money will be coming in.  So lets look at each of the components of the main dashboard...


The first dashboard component is the YTD Summary.  This component in The Raiser's Edge Financial Dashboard gives a view as to how much actual cash has been raised this year. 

In addition, when considering what "This Year" means, we have accomodated both the Fiscal Year and Calendar Year.  In addition to total dollars raised, the average gift and the number of gifts is displayed.  Total amount raised is important, but another measure of performance is the average gift.  The lower the average gift, the more donors or actual donations are needed to meet budgets.

The second Raiser's Edge Financial Dashboard component is the 12 Month Period Comparison, or recent yearly performance comparisons.  This component is meant to show multiple 1 year periods of Total Amount raised, Average Gift, and Number of Gifts.  This allows an organization to see a trend when they can compare the last 12 months (as of the day of the report) when compared to the 12 month period ending a month ago, 6 months ago, and 1 year ago.   For example, if Today were 12/1/13, the Today column shows metrics for the period of 12/2/2012 to 12/1/2013.  The Last Month column would be the period of 11/2/2012 to 11/1/2013; 6 Months Ago would be 6/2/2012 to 6/1/2013, etc.  Again, this gives a quick snapshot of how the organization is trending (few donors and more money raised, more donors and less money raised, etc).

 For each 12 month period, there is a +/- column which shows how the current 12 month period (ending today) has done against the previous 12 month period.  If the value is in red then that is bad.  For example, in our picture to the right, when we compare the 12 month period for Today against the one for 6 Months Ago, the 12 month perioding ending today has only raised 89% as much as the period from 6 Months ago but the average gift is 143% of the 6 Months Ago time period. 


The next two components, shown at the left and right, show how the money has been allocated for that which has been raised this Fiscal Year.  The two pie charts show a breakdown of donations to Campaigns and Funds.  The FY Campaign Year-To-Date has the donations for the Campaigns for the current Fiscal Year.  The Fiscal Year is determined by the setting in the Raiser's Edge Configuration General Settings.  If you believe the Raiser's Edge Financial Dashboard is reporting incorrect information for Fiscal Year, then contact your RE Administrator to verify the Fiscal Year is setup correctly.

These charts may give someone an indication as to where particular funds or campaigns may need special attention to meet their goals for the current year.  When mousing over the Campaigns or Funds in the charts, the amount for the respective Campaign or Fund is displayed.  This is just one of the features and designs that exists in the Raiser's Edge Financial Dashboard to not crowd the dashboards and reports but allow quick access to details and drill-down capabilities to more information.

To carry on the Trend Analysis capabilities of the Raiser's Edge Financial Dashboard, a line graph was developed which shows the last 3 years of donations, per month. 

As shown on the graph to the left, each year is given its own line and when laid on the same graph, a trend may possibly emerge. For example, a trend may emerge showing that during the month of December each year you get a spike in donations due to your donors contributing before the end of year for tax purposes.  But the key is that a trend may emerge allowing you to work smarter and more efficiently during certain times of year.


Finally, when considering the importance of cash donations, one must look at those cash donations that have not been paid but should have been, or unpaid pledge installments.

The Pledge Installments Overdue Analysis component, shown at the right captures these past due pledge installments.  It also segments these pledge installments so that someone may be able to see a total amount, average installment, etc. for a period of time (the amount of time the pledge is overdue). 
Another important consideration for the Raiser's Edge Financial Dashboard is the amount of cash expected, or upcoming pledge installments due.

The Pledge Installments Forecast, shown at the right of the Raiser's Edge Financial Dashboard, shows visually how much money is due in the next 12 months, as recorded in The Raiser's Edge.  This helps to give some indication as to expected revenue coming in so workload can be planned based on this expected revenue.

Another beauty of this is the core of dashboard is already developed.  Perhaps it doesn't fit your use 100% but with a slight tweak you can get more use from it.  We can do that for you at a fraction of the cost of building out a dashboard application from scratch.  Just contact us at Tucamino Solutions to see how we might help you.

Check out the other posts in our series at:
The Raiser's Edge Financial Dashboard Part I - The Overview
The Raiser's Edge Financial Dashboard Part II - The Big Picture
The Raiser's Edge Financial Dashboard Part III - Drill-Down Analysis
The Raiser's Edge Financial Dashboard Part IV - True Integration with The Raiser's Edge
The Raiser's Edge Financial Dashboard Part V - How to Extend It Further

Sunday, May 26, 2013

The Raiser's Edge Financial Dashboard Part I - The Overview

As I have been thinking about what The Raiser's Edge is missing, one area jumps out more than others:  Reports, Business Intelligence, and Data Visualization.

As I talk to other users of the Raiser's Edge and view blog posts, questions posed in user groups and online forums, it strikes me how limited people are in how they can actually use data.  They have no idea how to take action on the data they have to do something that is going to help move their organization to action in a way that will IMPACT their organization. 

In order to impact their organization, an employee needs to be able to focus their time and attention on something that will make an impact.  That means different things to different people.  But in order for someone to do their job effectively they need to be able to see data in way that tells them a story, tells them what to do, and brings attention to areas that need it.

Circling back to The Raiser's Edge, the built in reports are really inadequate.  They are mostly textual static reports.  The "Custom Reports" feature is limited by the fact that Crystal Reports is a flawed reporting tool itself and is encumbered by having to deal with data that is limited by the export feature of The Raiser's Edge.  The dashboards are nice but after a while they get stale and they are pretty limited as well.  And it is sad, most organizations think this is what they have to work with.  I bet many have individuals on staff that "compile" reports in a labor intensive process to get something that is in a better format than what they have available to them.

So that got me thinking about developing an example of one way to tell a story about the financial health of an organization.  As I think about financial health, what I would want to know is:
1.  What is our revenue, or cash gifts, for this year?  This tells me raw numbers so I can see what the organization has generated in cash. 
2.  How is that revenue broken down (by campaign and by fund)?
3.  How are we doing over the last 12 months compared to other, recent 12 month periods?
4.  What is our expected revenue?  So this is what someone has told us they are going to give us in the future.  In RE lingo, this would be my Pledge Installments or possibly Recurring Gifts "Installments".
5.  What is my overdue revenue?  This can be thought of as the money someone pledged to us and did not pay.  They may not have paid because they lost their job, or perhaps they forgot, or God forbid, we forgot to remind them!!!

Raiser's Edge Financial Dashboard Main Dashboard Screen

All of the above focuses on CASH!!!  In my opinion, coming from the perspective of the amount of cash raised and cash expected is the bottom line for an organization in terms of sustainability and the ability to continue to fulfill a mission.  So I purposely did not add a "pledge" as revenue, or cash, for this year.  A pledge is great but it might not get fulfilled.  In addition, recording the pledge and the expected installments allows for forecasting of cash (another huge piece of information to tell an organization how their future financial health is looking).

OK, so what.  When you take the above, you get a picture of financial health (current status, current compared to recent, aka Trend Analysis, plus expected future money).   Again, so what?  Well, then if that Dashboard is interactive then the "reports" come alive.  Imagine being able to drill down into other dashboards or summary reports, see the details behind a segment of data (e.g. list of gifts over a period of time or for a campaign), then being able to drill down into a gift itself.  That can be pretty powerful! 

Raiser's Edge Financial Dashboard Year Summary

Not to mention, an Executive Director or VP of Development, or Board Member, can view these dashboards in a way that helps them make decisions, to align resources to what the organization needs, and not have to rely on static reports sent by email, followed up by more email "requests for information", etc.  The people that are typically responsible for making those reports can then spend their time on carrying out the actions that are going to benefit the organization.

The Raiser's Edge Financial Dashboard is also designed in such a way that it integrates with The Raiser's Edge.  A user may select to leverage the RE:API to log into The Raiser's Edge or choose to enter the SQL Server connection details.  This gives users and organizations flexibility on how they want to deploy the solution.  By using the RE:API additional functionality, described in Part IV of our series, users will get additional functionality.  Though it comes with a cost because a concurrent license is used to view the dashboard this way.

The next few articles in this series will focus on the details of the RE Financial Dashboard.  I hope you get the value out of them and want to try it out.

Check out the other articles, coming soon, in our series:
The Raiser's Edge Financial Dashboard Part II - The Big Picture
The Raiser's Edge Financial Dashboard Part III - Drill-Down Analysis
The Raiser's Edge Financial Dashboard Part IV - True Integration with The Raiser's Edge
The Raiser's Edge Financial Dashboard Part V - How to Extend It Further