Demonstration · Illustrative data · BI Consulting Services
Stewardship & Financial Statements Board

Apostolic Church of God×BI Consulting Services

Income statement, balance sheet and fund stewardship in one Power BI view — built on the church's SQL Server ledger, refreshed nightly, and readable by the Finance Committee without a spreadsheet.

Demo concept
Prepared for Earl
September 2026 · 6320 S. Dorchester Ave, Woodlawn, Chicago

Giving by month

Tithes & offerings plus designated giving, with the same months a year earlier for comparison. Easter and December carry the year; July and August are the valley.

Selected periodSame months, prior yearBudget
1

What this board answers

Three questions the Finance Committee asks every month, answered from the filtered data.

2

Income statement

3

Ministry window

Each pane is a ministry or department, sized by its share of spend in the selected period and coloured by the fund that pays for it. Hover a pane.

GeneralBuildingMissionsBenevolence
4

Budget vs actual by ministry

Actual spend against the approved budget for the period. Bars past the marker are over budget.

ActualBudget
5

Fund balances

Closing balance of each fund at period end. Restricted funds can only be spent on their designated purpose.

6

Attendance-adjusted giving

Weekly giving per in-person attendee across the two Sunday services (9:10 and 11:40). Separates "fewer people" from "people giving less".

Giving per attendee / weekAvg weekly attendance
7

Ask the data

A natural-language layer on the same model. Answers cite the panel they come from.

Question
Which ministries are over budget this quarter?Show restricted vs unrestricted cashCompare Easter giving to last year
8
Demonstration · Illustrative data · BI Consulting Services
Also from BI Consulting Services

Private AI on your own server

The "ask the data" ideas on this board are designed to run on a GPU server inside your own network — an open-weight model over your own documents, cited answers, no per-seat licence, nothing leaving the building. The short deck below explains how it works. Scroll through, or download it as a PDF.

Private AI Servers — slide 1 of 14
Private AI Servers — slide 2 of 14
Private AI Servers — slide 3 of 14
Private AI Servers — slide 4 of 14
Private AI Servers — slide 5 of 14
Private AI Servers — slide 6 of 14
Private AI Servers — slide 7 of 14
Private AI Servers — slide 8 of 14
Private AI Servers — slide 9 of 14
Private AI Servers — slide 10 of 14
Private AI Servers — slide 11 of 14
Private AI Servers — slide 12 of 14
Private AI Servers — slide 13 of 14
Private AI Servers — slide 14 of 14

Questions? Book 30 minutes: calendly.com/powerbiconsultingservices/30min