SF logo Foster BI Services
Portfolio

Production reports, rebuilt as samples

All reports on GitHub →
Sample data These are sample reports. Each keeps the original design, model and DAX, but all data is synthetic and not real. The client has been rebranded as the fictional Midwest Workforce Partnership (MWP).
Performance Snapshot page

MWP US Project Scorecard

An executive portfolio scorecard that rates every active workforce-services project on performance, finance, staffing and compliance risk, then rolls the results up by vice president and region.

Worth a look: configurable scoring thresholds and weights, data from five systems, reusable DAX functions.

85 tables 526 measures 6 UDFs
Program Overview page

Workforce Pathway

Product analytics for a mobile career-coaching app used by workforce programs. It follows members from enrollment through engagement, learning content, job readiness and self-assessments, alongside coach caseloads.

Worth a look: about 40 KPI cards drawn in DAX as HTML and SVG from 11 shared functions.

62 tables 232 measures 11 UDFs
Summary page

PL Childcare

A child care subsidy payments report for a state workforce board. It reconciles provider payments between two systems, tracks spending against the fiscal-year budget and audits mismatches by region and county.

Worth a look: two-system reconciliation, row-level security by region, HTML Content KPI cards.

18 tables 71 measures 5 RLS roles
Grant Enrollment page

DVR LJC Collaboration

A grant-collaboration report between a state vocational rehabilitation agency and its local job centers. It tracks enrollments, services, exits to employment, and partner surveys across regions.

Worth a look: one ApplyPeriod function switches about 17 measures between cumulative and monthly values.

21 tables 207 measures 5 UDFs
Program Overview page

Cedar Hollow IWP

An operations report for a county interim housing program. It covers activations, demographics, room nights, staffing, financials, call-centre activity and data-quality checks across systems.

Worth a look: cross-system data-quality reporting that flags duplicates, name mismatches and missing records.

29 tables 131 measures 21 relationships