Reports & Analytics

Generate and manage comprehensive ERM reports

156
Total Reports
24
This Month
8
Scheduled
1,243
Downloads
Stakeholder Reports
Specialized reports for all stakeholders
Board of Trustees 2 Reports Investment Committee 1 Report Audit Committee 1 Report Compliance & Legal 1 Report Operations & More 4 Reports
View All Stakeholder Reports
Risk Reports
Risk Register PDF, Excel Risk Dashboard PDF Risk Heat Map PDF, PNG Risk Trends PDF, Excel
Compliance Reports
Compliance Status PDF, Excel Audit Findings PDF Control Effectiveness PDF, Excel Regulatory Updates PDF
KRI Reports
KRI Dashboard PDF KRI Trends PDF, Excel Threshold Breaches PDF, Excel Executive Summary PDF
Recent Reports
Report Name Type Generated By Date Status Actions
No reports generated yet in this session

Reports & Analytics Guide

Comprehensive guide for generating, customizing, and distributing ERM reports

Quick Reference

Generating a Standard Report
  • Navigate to Reports & Analytics module
  • Select report category (Risk, Compliance, KRI, Stakeholder)
  • Click on desired report type from list
  • Report generation modal opens automatically
  • Select format (PDF for formatted report, Excel for data analysis, CSV for raw data)
  • Choose date range (defaults to last 30 days)
  • Select sections to include (Charts, Detailed Data, Comments)
  • Click "Generate Report" button
  • Wait 15-30 seconds for generation
  • Report downloads automatically to your Downloads folder
Customizing Report Parameters
  • Click "Generate Report" button in top actions section
  • Select report type from dropdown (organized by category)
  • Choose export format (PDF, Excel, CSV)
  • Set "Date Range From" (start date for filtering data)
  • Set "Date Range To" (end date for filtering data)
  • Check/uncheck "Charts and Visualizations" (visual charts in PDF)
  • Check/uncheck "Detailed Data" (granular data tables)
  • Check/uncheck "Comments and Notes" (user comments and annotations)
  • Click "Generate Report" to create customized report
Scheduling Recurring Reports
  • Click "Schedule" button in actions section
  • Select report type to schedule
  • Choose recurrence frequency (Daily, Weekly, Monthly, Quarterly)
  • Set specific day and time for generation (e.g., First Monday 9:00 AM)
  • Select recipients (email addresses for automatic distribution)
  • Choose format (PDF for stakeholder distribution recommended)
  • Enable/disable automatic generation
  • Save schedule configuration
  • View scheduled reports in "Scheduled" statistics card (shows count)
Viewing Report History
  • Scroll to "Recent Reports" section at bottom of page
  • View last 10 generated reports with full details
  • Check report name, type, generated by user, date/time
  • Review status (Downloaded, Scheduled, Failed)
  • Click trash icon to remove from history
  • History persists across sessions (stored locally)
  • Use "Refresh" button to reload report list
  • Filter history by date range or report type (coming soon)

Report Types Catalog

Category Report Name Description Available Formats
Risk Reports Risk Register Complete list of all identified risks with details (description, owner, likelihood, impact, treatment status) PDF, Excel, CSV
Top Risks Dashboard Executive summary of highest priority risks requiring immediate attention PDF
New Risks Report Recently identified risks within selected date range PDF, Excel
Overdue Risks Risks with overdue treatment actions or review dates PDF, Excel
Exception Reports Risks outside risk appetite thresholds or requiring executive approval PDF, Excel
Compliance Reports Compliance Status Overall compliance score and status for all regulatory requirements PDF, Excel
Audit Findings Internal and external audit findings with remediation status PDF
Control Effectiveness Effectiveness scores for preventive, detective, corrective, and directive controls PDF, Excel
Regulatory Updates Recent changes to regulations and compliance requirements affecting NAPSA PDF
KRI Reports KRI Dashboard Current values, thresholds, and status for all Key Risk Indicators PDF
KRI Trends Historical trend analysis for KRIs showing performance over time PDF, Excel
Threshold Breaches KRIs that have exceeded warning or critical thresholds PDF, Excel
Executive Summary High-level KRI performance summary for executive and board reporting PDF
Stakeholder Reports Board Dashboard Comprehensive executive dashboard for Board of Trustees (top risks, compliance, KRIs, incidents) PDF
Investment Committee Dashboard Investment risk dashboard showing portfolio risks, market risks, and compliance PDF
Audit Committee Report Detailed audit register with findings, recommendations, and management responses PDF
Cyber Security Dashboard IT security risks, vulnerabilities, incidents, and mitigation status PDF
Operations Dashboard Operational risks, process performance, and business continuity status PDF
Executive Summary Concise executive summary covering all ERM areas for senior management PDF

Export Formats Explained

PDF Format

Best For: Executive reports, board presentations, stakeholder distribution, formal documentation

Features: Professional formatting, charts and visualizations, page numbers, headers/footers, branding

Use Cases: Monthly board reports, compliance submissions, audit documentation, executive summaries

Advantages: Cannot be edited (audit trail), consistent formatting across devices, suitable for printing

Excel Format

Best For: Data analysis, filtering, pivot tables, custom calculations, chart creation

Features: Structured data in worksheets, formulas, filtering, sorting, conditional formatting

Use Cases: Risk trend analysis, compliance tracking, KRI performance analysis, custom reporting

Advantages: Flexible data manipulation, custom calculations, integration with other Excel tools, multiple worksheets

CSV Format

Best For: Raw data export, system integrations, data imports, automated processing

Features: Plain text comma-separated values, universally compatible, lightweight

Use Cases: Data warehouse exports, third-party system imports, bulk data processing, archival

Advantages: Simple format, no proprietary software required, easy to parse programmatically, smallest file size

Best Practices

DO: Best Practices
  • ✓ Schedule regular reports - Automate monthly board reports, quarterly compliance reports, weekly KRI summaries
  • ✓ Use appropriate format - PDF for stakeholders, Excel for analysis, CSV for system integrations
  • ✓ Set realistic date ranges - Last 30 days for operational reports, quarterly for trend analysis, annual for strategic
  • ✓ Include relevant sections only - Executives need summaries (exclude detailed data), analysts need detail (include all)
  • ✓ Review before distributing - Always review generated report for accuracy before sending to stakeholders
  • ✓ Version control reports - Name files with date and version (e.g., "Board_Report_2025-10_v1.pdf")
  • ✓ Archive historical reports - Store reports for 7 years minimum for compliance and audit purposes
  • ✓ Refresh data before generating - Click "Refresh" to ensure latest data included in report
DON'T: Common Pitfalls
  • ✗ Generate without reviewing parameters - Risk: Wrong date range, incorrect format, missing sections, unusable output
  • ✗ Use CSV for stakeholder reports - Risk: Stakeholders cannot easily view data, no formatting, unprofessional appearance
  • ✗ Include all sections for executives - Risk: Information overload, executives miss key insights, report not read
  • ✗ Set unrealistic date ranges - Risk: No data returned (too short), too much data (too long), irrelevant information
  • ✗ Share reports via insecure channels - Risk: Data breach, unauthorized access, compliance violations (use secure email/SharePoint)
  • ✗ Forget to schedule recurring reports - Risk: Missed deadlines, manual work burden, inconsistent stakeholder communication
  • ✗ Generate reports with stale data - Risk: Inaccurate information, poor decisions, loss of stakeholder trust
  • ✗ Delete report history prematurely - Risk: Cannot reproduce reports, compliance issues, lost audit trail

Common Workflows

Objective: Prepare comprehensive monthly report for Board of Trustees meeting.

Steps:

  1. Generate Board Dashboard: Click "Stakeholder Reports" → "Board Dashboard" → Select "PDF" format.
  2. Set Date Range: Set "From" to first day of previous month, "To" to last day of previous month.
  3. Include All Sections: Check Charts, Detailed Data, Comments (board needs complete picture).
  4. Generate Report: Click "Generate Report" and wait 30-45 seconds (comprehensive report).
  5. Review Output: Open downloaded PDF and verify all sections complete (Top Risks, Compliance, KRIs, Incidents).
  6. Add Executive Summary: Prepare 1-page executive summary document highlighting key insights and action items.
  7. Version Control: Rename file to "Board_Report_2025-10_v1.pdf" (include month and version).
  8. Distribute: Upload to secure board portal or send via encrypted email 3 days before meeting.
  9. Archive: Save copy to shared drive under "Board Reports/2025/October" for compliance record keeping.

Best Practices:

  • Schedule automatic generation 5 days before board meeting (allows review time)
  • Include trends comparing to previous 3 months (show progress)
  • Highlight any critical issues requiring board attention in cover memo
  • Prepare presentation slides summarizing key report findings

Objective: Analyze risk trends over quarter to identify patterns and emerging risks.

Steps:

  1. Generate Risk Register: Click "Risk Reports" → "Risk Register" → Select "Excel" format (for analysis).
  2. Set Quarterly Range: Set "From" to first day of quarter (e.g., Jan 1), "To" to last day (e.g., Mar 31).
  3. Generate and Download: Click "Generate Report" and open Excel file when downloaded.
  4. Create Pivot Tables: Analyze risks by category, department, severity, treatment status.
  5. Identify Trends: Look for increasing risks in specific categories, departments with most risks, overdue treatments.
  6. Generate Risk Trends Report: Click "Risk Reports" → "Risk Trends" → Select "PDF" format.
  7. Same Date Range: Use same quarterly date range for consistency.
  8. Combine Analysis: Use Excel data for detailed analysis, PDF report for visual trends and charts.
  9. Document Insights: Create PowerPoint summarizing key findings: top 3 emerging risks, risks trending down, action recommendations.
  10. Present to Risk Committee: Schedule Risk Committee meeting to review findings and approve action plans.

Key Metrics to Analyze:

  • Number of new risks identified vs. closed (net risk exposure change)
  • Risk severity distribution changes (are high risks increasing?)
  • Treatment completion rate (on-time vs. overdue)
  • Risk concentration by department (which areas need focus?)
  • Compliance risk trends (regulatory changes impact)

Objective: Prepare compliance report for regulatory submission (e.g., Bank of Zambia, PIA).

Steps:

  1. Review Regulatory Requirements: Check regulator's specific requirements (format, sections, date range, frequency).
  2. Generate Compliance Status Report: Click "Compliance Reports" → "Compliance Status" → Select "PDF" format.
  3. Set Required Date Range: Use date range specified by regulator (usually quarterly or annual).
  4. Include All Required Sections: Check all boxes (Charts, Detailed Data, Comments) for comprehensive submission.
  5. Generate Report: Click "Generate Report" and review downloaded PDF.
  6. Verify Completeness: Check all regulatory requirements covered: compliance score, control effectiveness, audit findings, remediation status.
  7. Add Supporting Documents: Attach evidence documents: control testing results, audit reports, management responses, action plans.
  8. Executive Sign-Off: Obtain CEO and Risk Officer signatures on transmittal letter.
  9. Submit via Required Channel: Upload to regulator's portal or submit via registered mail (keep proof of submission).
  10. Archive Submission: Save complete submission package (report + attachments + transmittal) for 7 years minimum.

Compliance Submission Checklist:

  • ☑ Compliance score meets regulatory minimum (usually ≥ 95%)
  • ☑ All high-risk compliance issues documented with remediation plans
  • ☑ Control effectiveness scores provided for each control type
  • ☑ Audit findings include management responses and action plans
  • ☑ Report covers required time period exactly (no gaps or overlaps)
  • ☑ Executive sign-off obtained on transmittal letter
  • ☑ Supporting evidence documents attached
  • ☑ Submission deadline met (submit 3-5 days early for review)

Objective: Configure automated generation and distribution of recurring reports.

Steps:

  1. Click "Schedule" Button: In actions section, click "Schedule" to open scheduling modal.
  2. Select Report Type: Choose report to automate (e.g., "Board Dashboard" for monthly board reports).
  3. Set Recurrence Frequency: Select "Monthly" for board reports, "Weekly" for operational reports, "Quarterly" for strategic.
  4. Choose Specific Timing: Set specific day (e.g., "First Monday of month") and time (e.g., "9:00 AM") for generation.
  5. Select Format: Choose "PDF" for stakeholder distribution (formatted, cannot be edited).
  6. Configure Date Range: Set to "Previous month" for monthly reports, "Previous week" for weekly, "Previous quarter" for quarterly.
  7. Add Recipients: Enter email addresses of recipients (separate with commas). Example: "board@napsa.co.zm, ceo@napsa.co.zm, risk@napsa.co.zm".
  8. Customize Email: Optionally add custom subject line and message body for email notification.
  9. Enable Schedule: Check "Enable automatic generation" to activate schedule.
  10. Save Configuration: Click "Save Schedule" to activate automated reporting.
  11. Verify in Dashboard: Check "Scheduled" statistics card shows increased count (e.g., from 8 to 9).
  12. Test Schedule: Wait for next scheduled run or manually trigger test generation.

Recommended Schedules:

  • Board Dashboard: Monthly, First Monday 9:00 AM, PDF, Recipients: Board + CEO + Risk Officer
  • Risk Register: Weekly, Friday 17:00, Excel, Recipients: Risk Management Team
  • Compliance Status: Monthly, 25th day 10:00 AM, PDF, Recipients: Compliance Team + CEO
  • KRI Dashboard: Weekly, Monday 8:00 AM, PDF, Recipients: Risk Owners + Management
  • Top Risks: Monthly, First Monday 8:00 AM, PDF, Recipients: Executive Team

Support & Assistance

IT Support

For: Report generation failures, download issues, format errors, scheduling problems, technical errors

Contact: support@napsa.co.zm

Phone: +260-211-123456

Hours: 24/7 (critical issues), Mon-Fri 8:00-17:00 (standard)

Response Time: Critical within 1 hour, standard within 4 hours

Risk Management

For: Report content questions, data interpretation, missing risks, compliance requirements, stakeholder reporting

Contact: risk@napsa.co.zm

Phone: +260-211-123457

Hours: Mon-Fri, 8:00-17:00

Response Time: Same day for urgent, 1-2 days for standard

Business Analysts

For: Custom report requests, new report types, data analysis, Excel formulas, data visualization, dashboard design

Contact: analytics@napsa.co.zm

Phone: +260-211-123460

Hours: Mon-Fri, 8:00-17:00

Response Time: 2-3 business days for custom requests