BICS Simplify Your Data
Johns Hopkins University Prepared for Development & Alumni Relations
Advisory engagement · Executive financial reporting · Prepared for Adam Edwards · August 2026

From a working model to an executive-quality reporting solution.

You've done the hard part — the model, the relationships and most of the DAX are already in place. This is about the last mile: turning solid data into budget-to-actuals and P&L reporting an executive team reads in seconds, trusts completely, and can question in plain language. A working sample of that, below.

B vs A
Budget to actuals
P&L
Executive summary
DAX
Review & optimize
UX
Storytelling & nav
AI
Ask-the-report Q&A
Advisor
Not a rebuild
BI Consulting Services · Microsoft Partner Power BI · DAX · Semantic modeling · Copilot powerbiconsultingservices.com
Before we show you anything

You don't need a rebuild — you need a trusted advisor for the last mile.

We read your note closely. The foundation is built; the goal is executive polish, better decisions, and a report leadership actually enjoys using. Here's what we heard, and how we'd help.

What we heard from Adam

"A trusted advisor to help transform the data into a polished, executive-quality reporting solution — primarily budget-to-actuals and P&L."

The data model is established, relationships are built, much of the DAX is written. So this isn't build-from-scratch — it's the craft layer on top: what to show an executive, how to lay it out, how to make the numbers tell a story, and how to keep it fast and trustworthy. That's precisely the work we love and the work most teams never get to.

Our posture: advisor first. We work alongside you and your existing model — recommending, refining, and where you want it, implementing. You keep ownership the whole way.
The nine things you asked for
  • Best visualizations for executive reporting
  • Usability & navigation
  • Data model review + refresh best practices
  • DAX measure review & optimization
  • Better KPI presentation techniques
  • Dashboard storytelling & user experience
  • Simplify / improve the report
  • Troubleshoot occasional Power BI issues
  • Possibly implement AI query into the report
On the screen today

Executive P&L summary

Revenue, expense and net at a glance — with the story of how you got there, not just the totals.

On the screen today

Budget vs actuals

Every department against plan, favorable and unfavorable variance surfaced, YTD pacing clear.

On the screen today

Variance, forecast & AI

What's driving the variance, where the year lands, and a plain-language "ask the report" panel.

The advisory method

We review what you've built, then elevate it — through six lenses.

A trusted advisor doesn't start by rebuilding. We assess the model, the DAX and the report as they are, then make focused, prioritized recommendations — and implement the ones you want. Everything stays in your tenant, on your model.

From working model to executive-gradeWhat we bring to each layer of what you've already built
What you have today Established data model Relationships built Most DAX written A solid foundation The six advisory lenses ◆ Executive visualization choices ◆ Usability & navigation ◆ Data model & refresh best practice ◆ DAX review & optimization ◆ KPI presentation & storytelling ◆ Simplify + AI query (Copilot) Prioritized: quick wins first, deeper changes staged Executive-grade report Read in seconds Trusted & fast Answers in plain English What leadership actually uses You keep ownership, your model, your tenant
Design & UX

Executive-first presentation

  • The right chart for each executive question
  • Variance shown so favorable/unfavorable is instant
  • Navigation that guides, not overwhelms
  • A deliberate story: headline → driver → detail
Model & DAX

Faster, cleaner, trustworthy

  • DAX review for correctness and performance
  • Measure patterns that are easy to extend
  • Refresh strategy and best-practice guardrails
  • Model tidy-ups that speed the whole report
AI & enablement

Ask the report

  • Copilot / Q&A tuned to your measures & synonyms
  • "Where are we over budget?" answered in plain English
  • Guardrails so answers stay correct
  • We advise, or implement — your call
Sample report · page 1 of 3

Executive P&L Summary

Revenue, expense and net at a glance, each against plan — the one screen a VP or dean reads first. The filters below are live; change them and all three pages follow.

BICS Development & Alumni Relations — Financial Reporting · page 1 · Executive P&L Refreshed nightlyFY2026 · illustrative
Statement of activity — actual vs budget
Line itemActualBudgetVarianceVar %
Expense by categoryWhere the money goes
Revenue, expense & netTrailing 12 months vs plan
RevenueExpenseNetPlan
Revenue by sourceOperating
Net & marginSurplus health
Executive-design note: variance is color-coded the instant you look — green favorable, red unfavorable — and the P&L reads top-down like a statement leadership already knows. That's a presentation choice, and it's the kind of thing we'd tune across your whole report.
Sample report · page 2 of 3

Budget vs Actuals

Every department against plan, with favorable and unfavorable variance surfaced immediately and year-to-date pacing made obvious.

BICS Development & Alumni Relations — Financial Reporting · page 2 · Budget vs Actuals Refreshed nightlyFY2026 · illustrative
Department budget performanceClick a column to sort
DepartmentBudget ActualVariance Var %YTD used Status
Variance by departmentFavorable ▸ / ◂ unfavorable
Diverging from center: green is under budget (favorable), red is over. The eye finds the problem before reading a single number.
YTD pacingCumulative actual vs budget · fiscal year to date
ActualBudgetForecast
Spend by categoryActual
Budget utilizationHow much is committed
Illustrative throughout. Departments, budgets, actuals and variances on this page were created by BICS for this presentation. They reflect a plausible advancement-division structure; no figure came from your model. Your real measures drop straight in.
Sample report · page 3 of 3

Variance, Forecast & AI Insights

What's driving the variance, where the year lands if nothing changes — and the "ask the report" panel that answers leadership's questions in plain language.

BICS Development & Alumni Relations — Financial Reporting · page 3 · Variance, Forecast & AI Refreshed nightlyCopilot Q&AFY2026 · illustrative
What's driving the varianceTop contributors vs budget · this period
A waterfall of the biggest favorable and unfavorable movers — the "why" behind the headline number, without exporting to Excel.
Ask the reportCopilot / Q&A · plain-language answers
Forecast to year-endActual to date + projection vs budget
ActualForecastBudget
Full-year outlookWhere the numbers land
On the AI ask: "possibly implementing AI query" is very doable — Copilot answers reliably when the semantic model and measure names are clean, which ties back to the DAX and model review. We'd tune synonyms so "are we over budget anywhere?" returns the right departments, with guardrails so it never guesses.
The advisor behind the advice

A 30-person Microsoft data team in Charlotte — and Power BI is our home turf.

Executive reporting, DAX and semantic modeling are the core of what we do every day. When you bring in a trusted advisor, you want senior judgment backed by a bench deep enough to answer any question your model throws — that's us.

Power BI & DAX

Where we live

  • Executive report design & storytelling
  • DAX review, optimization & performance tuning
  • Semantic modeling, RLS & refresh strategy
  • Copilot / Q&A enablement
Azure SQL & data engineering

Under the report

  • Modeling, query optimization & tuning
  • Refresh, backup, monitoring & T-SQL
  • Integration via Logic Apps & Azure Functions
  • Best-practice guardrails for reliable data
Custom application development

When more is needed

  • Full-stack — ReactJS & Python
  • APIs, integration & automation
  • Cloud-native DevOps: CI/CD, Git, Agile
  • Low-code where it fits
AI & analytics

Ask-the-data

  • Copilot & natural-language Q&A
  • ML with Azure Machine Learning
  • Analytics tooling end to end
  • QA & testing built into delivery
We know higher ed

We support universities and advancement-adjacent teams, so fiscal-year calendars, fund accounting, budget-to-actuals and the realities of executive reporting for deans and VPs are familiar ground. You won't spend the engagement teaching us your world.

North Carolina State University Winston-Salem State University Bryan University
Credentials
  • ~30 people, based in Charlotte, NC
  • Microsoft Partner · Power BI, Fabric, Azure
  • MBE Certified · delivering since 2018
  • 100K+ subscribers on our Microsoft data channel
Advisory engagement style

Quick wins first, deeper improvements staged — and you always own it.

An advisory engagement should pay for itself early. We start with a review, land the fast improvements, then work through the deeper items with you on a cadence that fits your calendar.

Step one

Assess

A structured review of your model, DAX and report against best practice — with a prioritized findings list, quick wins flagged separately from bigger items.

Step two

Recommend

Concrete recommendations for visuals, layout, KPI presentation and storytelling — shown on your actual report, not in the abstract.

Step three

Optimize

DAX and model tune-ups for correctness and speed, plus a refresh strategy that holds up — implemented with you or handed over as guidance.

Step four

Elevate & enable AI

Executive polish across the report and, where you want it, Copilot / Q&A tuned to your measures so leadership can ask questions directly.

Ongoing

Advisor on call

Troubleshooting and a trusted advisor to call when a Power BI issue or new reporting need comes up — as much or as little as you need.

Commitment

Advisor, not overhaul

We respect what you've built. The goal is to elevate your work, not replace it — you keep ownership of the model and the report throughout.

Commitment

Show, don't tell

Recommendations are demonstrated on your real report so you can see the before-and-after, then decide what to keep.

Commitment

Transparent & flexible

Advisory hours you control, clear estimates, and no pressure to buy more than the moment calls for.

Track record & commercials

Trusted with executive reporting — priced for advisory work.

Helping teams turn a solid model into reporting leadership relies on is exactly the work we're known for.

Our client · highlighted
★★★★★

"Power BI enabled us to move beyond static reporting from SQL Server. Automation and interactive dashboards streamlined data delivery and gave stakeholders immediate access to actionable insights."

Jason Corbett Kennedy Wilson — real estate investment & management
Our client · highlighted
★★★★★

"They helped us build strong data foundations and Power BI dashboards, giving our team clarity, confidence, and better decision-making."

Addy Kusi Goodwin Living
Universities we support
North Carolina State University Winston-Salem State University Bryan University

Plus clients across senior living, nonprofit, real estate, industrial and distribution — executive reporting is a constant across all of them.

How an advisory engagement works

Most advisors start with a scoped review, then draw on flexible hours for the improvements you prioritize. You're never locked into a big build.

Where we'd start

Dashboard assessment

A fixed-scope review of your model, DAX and report — you get a prioritized findings list and a recommended roadmap. No big commitment to see real value.

Flexible advisory

Hour bundles

1 hr
$600
3 hrs
$1,500
5 hrs
$1,750
10 hrs
$3,000

Ideal for advisory: use hours for review, recommendations, DAX work or troubleshooting as you need them.

Prefer an ongoing advisor?

A monthly retainer keeps a trusted advisor on call — enhancements, new views, refresh health and a standing block of development hours every month.

Option 1
$1,800 /mo
  • Monthly planning call
  • Monitoring & maintenance
  • 4 dev hours / month
  • Expert & email support
Option 2
$2,800 /mo
  • Everything in Option 1
  • 1 license included
  • 7 dev hours / month
  • Monitor 3 reports/apps/flows
Option 3
$3,800 /mo
  • Everything in 1 & 2
  • 2 licenses included
  • 12 dev hours / month
  • Monitor 4–5 reports/apps/flows

Six-month minimum on managed retainers · 10% off post-project development · hours don't roll over (we plan the month together) · training available (Lite $1,650 / Advanced $3,000 per person).

Next step

Walk us through your current report — we'll point you from there.

Thirty minutes screen-sharing your existing dashboard. You'll walk away with candid, specific direction — the top handful of improvements we'd make and how we'd sequence them — whether or not we ever do the work together.

In the session

You share the report live; we react in real time and note quick wins vs deeper items.

Right after

A short written findings list with prioritized recommendations and a fixed assessment scope.

Then

We work the improvements on the hours and cadence that suit you — executive polish first.

LocationCharlotte, North Carolina
The one-line promise

You've built the engine. We make it executive-ready — clearer, faster, and answerable in plain language. We simplify your data, you lead with it.

Illustrative data notice. All departments, budgets, actuals, revenue, expense and forecast figures in this deck were created by BICS for this presentation and are illustrative only. They reflect a plausible advancement-division financial structure; no figure originated in Johns Hopkins' systems or model.
Use to move between slides