01
Power BI
BI & Dashboards
Custom Power BI dashboards that turn raw data into clear, actionable views for executives, managers, and operational teams.
Inquire
Lantern & Ledger Consulting — Bloomington, MN
Illuminate the
story behind
your numbers.
Power BI dashboards, business intelligence, and decision-support analytics for small and mid-sized organizations ready to move beyond basic reporting.
Power BI
Primary Toolchain
SQL
Data Modeling
BI + Ops
Domain Expertise
SMB
Client Focus
Capabilities
A complete analytics practice.
Eight focused service lines — engineered to help leaders understand what is happening in their business, why it is happening, and what to do about it next.
01/08
02
Recurring
Reporting Automation
Automate recurring reports, KPI tracking, and performance monitoring — save hours while improving consistency and accuracy.
Inquire
03
Deep-Dive
Data Analysis
Targeted analysis to surface trends, opportunities, risks, and the underlying drivers behind your performance.
Inquire
04
Measurement
KPI Development
Design meaningful metrics that align with business objectives — measure what matters, not what's easy to count.
Inquire
05
Communication
Data Storytelling
Translate complex findings into clear narratives that move decisions forward for both technical and non-technical audiences.
Inquire
06
Operations
Process Analytics
Analyze workflows, bottlenecks, and performance trends to identify opportunities for efficiency and improved outcomes.
Inquire
07
Decision Aid
Forecasting Support
Analytical models and planning tools to evaluate scenarios, weigh trade-offs, and inform strategic decisions.
Inquire
08
Tailored
Custom Engagements
Bespoke analytical solutions built around your unique data sources, challenges, and business goals.
Inquire
The Practice
Every business has a story hidden in its data.
Lantern & Ledger Consulting helps small and mid-sized organizations move beyond basic reporting — through dashboards, reporting automation, KPI design, and decision-support analytics that translate raw numbers into clear understanding.
The name reflects the philosophy. The lantern represents illumination and discovery; the ledger represents the numbers themselves. Together: information turned into understanding.
Power BI
Primary Platform
SQL
Data Modeling
Ops + BI
Background
SMB
Client Focus
A note from Rowan
“I started Lantern & Ledger because data should be understandable, accessible, and useful. The most valuable analytics aren’t the most complicated — they’re the ones that help people confidently take action. Every number represents a real process, customer, or decision, and that perspective shapes every project.”
— Rowan Olson, Founder
On Clarity
The goal is to turn data into information, and information into insight.
Carly Fiorina
Selected Work
Case studies in clarity.
Representative engagements drawn from analytics, BI, and operations work. Many projects involve confidential business data; what’s shared here emphasizes methodology and outcome rather than client specifics.
View public work on GitHubExecutive Reporting
Logistics Performance Dashboard
Consolidated multi-warehouse KPIs — on-time delivery, dock-to-stock, and labor productivity — into a single Power BI executive view.
12+
data sources
4 hr
weekly time saved
Operational Analytics
Supply Chain Exception Monitor
Real-time exception dashboard surfacing late shipments, inventory imbalances, and carrier underperformance with drill-through detail.
< 15m
issue surfacing
3
carrier scorecards
Forecasting
Demand Planning Model
Seasonal forecasting model with scenario comparison, blending historical demand with promotional and operational adjustments.
±6%
MAPE improvement
18 mo
horizon
KPI Design
Operations Scorecard System
End-to-end KPI framework aligning team-level metrics with executive scorecards — measuring what actually moves performance.
22
KPIs defined
3 tiers
of reporting
Reporting Automation
Automated Weekly Insights
Replaced a manual workbook process with an automated SQL + Power BI pipeline delivering weekly narratives and exception summaries.
6 hr → 0
manual prep
100%
on-time delivery
Process Improvement
Network Flow Analysis
Analytical deep-dive identifying inefficiencies in inter-facility flow, with quantified opportunities for lane consolidation.
7
lanes optimized
6.2%
cost reduction
Have a similar challenge? Engagements are scoped around the specific outcome you’re trying to reach.
Discuss a projectCommon Questions
Questions, answered.
What prospective clients ask most often before starting an engagement. If your question isn’t here, reach out directly — every conversation begins with listening.
Still curious?
Initial conversations are no-cost and focused on understanding your data and decisions — not selling services.
Start a conversationLantern & Ledger Consulting provides business intelligence, dashboard development, reporting automation, KPI design, data analysis, forecasting support, and data storytelling services.
Guiding Principle
Without data, you’re just another person with an opinion.
W. Edwards Deming
Begin a Conversation
Tell us about
your data.
Share a little about your organization and what you’re trying to understand. Rowan will reach out within one business day to set up an initial conversation — no cost, no obligation.