Module 10: Integration, Automation & Best Practices
Final Exam
Capstone Project
4 of 4

Part 7: Analytics, System Audits & Executive Board Reporting

Task 7.1: Dashboard KPI Analysis

  1. Navigate to the main Fund Raising Dashboard.
  2. Review real-time Key Performance Indicators (KPIs) in numerical summary widgets:
    • Donations This Year: Displays year-to-date total cash gifts and pledge payments (55,233.99), total donation count (72), average donation (767.13), and new donors (55).
    • Donations This Month: Displays month-to-date total (26,345.00), total count (11), average donation (2,395.00), and new donors (11).
    • InKinds This Year: Tracks cumulative non-cash contributions.
    • Pledge Summary: Displays total outstanding, unpaid pledge balances across all pledge accounts.
  3. Inspect graphical analytical widgets:
  1. Appeals Pie Chart: Displays giving distribution across active appeals.
  2. Gifts Pie Chart: Evaluates giving breakdown by specific gift designations.
  3. Donations by Month Line Graph: Plots monthly revenue trends across the year.
  4. Modify visual display settings under My Account > Preferences:
  1. Change Pie Chart Appeal/Gift Order between Amount (dollar value) and Name (alphabetical).
  2. Adjust Fund Raising Basis between Calendar Year and Fiscal Year.

Task 7.2: Comprehensive Financial & Campaign Reporting

Navigate to Reports > Fund Raising Reports and generate executive summary reports (outputting to PDF or Excel format):

  1. Multi-Year Trend Analysis: Evaluate monthly giving trajectories and year-over-year performance variances.
  2. Campaign / Appeal Summary Reports: Measure total raised against defined campaign budget targets, evaluating fundraising efficiency and ROI.
  3. Pledge Subsidiary Ledger: Verify outstanding pledge receivables, aging balances, and individual payment histories (Reports > Pledge Subsidiary).

Task 7.3: System Security & Audit Log Review

  1. Navigate to Administration > Company Information > Audit Logs.
  2. Conduct a security and operational compliance audit.
  3. Filter audit entries by date range and operational category to inspect logged user activity, including profile updates, preference changes, transactional edits, and system login/logout timestamps.

Validation Checkpoint 7

Data Reconciliation Note: Baseline vs. Active Postings Prior to executing Phase 4 transactions, the system dashboard displays a baseline Pledge Summary balance of $0.00 (as shown in pre-exercise context widgets). Following Phase 4 processing, the net active Pledge Receivables balance reconciles to exactly $3,800.00 ($5,000.00 initial pledge minus $1,200.00 pledge payment minus $500.00 write-off).

Fund DesignationTotal Revenue Calculated ($)Top Performing AppealActive Pledge Receivables ($)System Audit Error Status
01 – General Operating$26,345.00Annual Gala 2024$0.00Zero Unreconciled Errors
02 – Building Fund$28,888.99Capital Campaign$3,800.00 (Net Postings)Zero Unreconciled Errors
Combined Totals$55,233.99Annual Gala 2024$3,800.00System Audited & Clean