Legal Analytics Consulting: Business Data for Law Firms and Legal Departments
Law firms want to know which matters and fee arrangements actually make money. Legal departments want to know what outside counsel costs, and why. The data sits in the billing and e-billing systems; the answers rarely do.
Legal analytics consulting at Lightray Solutions means analysis and data visualization of a legal organization's own business data: matter budgets and profitability, fee arrangements, staffing and intake for law firms, and outside-counsel spend for in-house legal departments. Edward Pinela, MBA, builds it in Power BI from the billing, time and e-billing records you already keep.
A note on the term: legal analytics also names litigation research products that analyze court dockets to report on judges, courts, opposing counsel and case timelines; Villanova Law's guide to litigation analytics tools describes that category. This page is not about those products. It is about your firm's or department's own financial and operational data.
Each engagement gets a fixed price in writing once a short discovery has mapped the firm's systems. The first step is a free 30-minute strategy call, requested through the form or by phone.
What can a law firm learn from matter-level analytics?
Whether matters make money and whether they stay on budget. Matter profitability compares fees collected with the cost of the timekeepers and expenses that went into them. Budget-to-actual tracking compares hours and fees so far with the estimate or the client's budget, by phase, so overruns are visible before the invoice goes out.
The firm-wide financial dashboard, covering utilization, realization, collections, lockup and effective rates, is a separate build described on law firm financial reporting dashboard. Matter analytics goes a level down: one matter, one client or one practice group, and the staffing and scope decisions the responsible lawyer makes along the way.
How do you analyze alternative fee arrangements and staffing leverage?
By looking at closed matters of the same type, phase by phase. Hours by phase and by timekeeper level show what a typical matter actually takes, which is the evidence behind a flat or capped fee. Staffing leverage, the ratio of associate and paralegal hours to partner hours, then explains why two similar matters earned very different margins.
An alternative fee arrangement (AFA) is any fee not based purely on hourly rates: flat, capped, phased, success-based or a blend. For each AFA template, the reporting shows the range of hours past matters needed, the share that went over, and which phase usually caused it. Phase coding is what makes this possible, and firms that already apply UTBMS task codes for clients' e-billing have most of it in place.
| Question | Law firm view | Legal department view | Data source |
|---|---|---|---|
| Are we on budget? | Hours and fees to date against the matter estimate, by phase | Invoiced spend against the approved budget, by matter and firm | Time and billing system; LEDES invoice lines |
| What does the work actually cost? | Matter margin after timekeeper cost and expenses | Blended rate per task across firms | Billing system and cost rates; UTBMS-coded invoice lines |
| Is staffing right? | Associate and paralegal hours per partner hour | Share of hours billed by senior timekeepers | Timekeeper level on each time entry |
| Do our fee arrangements work? | Margin by fee arrangement and matter type | Spend under flat or capped fees compared with hourly | Matter records with a fee arrangement field |
| Where does the work come from? | Intake source, conversion and origination credit | Matters opened per business unit | Intake form or CRM; matter opening records |
What about intake and origination?
Intake analytics follows a matter from first contact to engagement: where inquiries come from, how many are declined or conflicted out, how long the decision takes and which sources produce the matters that pay. Origination credit, recorded per matter, shows which lawyers bring in work and how that work performs after it arrives.
The data usually sits in an intake form or CRM and in the practice management system, joined on the matter number once a matter opens. Conflict-check details stay out of the model; only the outcome, cleared or declined, is needed. How origination credit is split among lawyers is firm policy, and the reporting applies whatever rule the firm sets.
How do legal departments analyze outside-counsel spend?
From the e-billing data firms already submit. LEDES, the Legal Electronic Data Exchange Standard, defines the invoice files that e-billing systems exchange, with one line per fee or expense carrying the timekeeper, hours, rate, amount and UTBMS task and activity codes. Loaded into Power BI, those lines become spend by firm, matter, phase and timekeeper, against budget.
LEDES.org describes LEDES 1998B, a pipe-delimited text format with 24 fields, as the most widely used e-billing standard in the US, and XML versions also exist. UTBMS, the Uniform Task Based Management System, supplies the codes that say what the work was. With both, a department can compare blended rates across firms for the same task, see which matters run over budget, and spot senior timekeepers billing routine work.
The files are usually exported from the department's e-billing platform rather than collected from each firm, so the model reads that export on a schedule.
What does it cost, and how is confidential data handled?
Projects are quoted at a fixed price after discovery, scaled by the number of sources and by whether the client is a firm or a legal department. Confidentiality comes first in discovery: the model takes billing figures, not documents or client files, and row-level security limits each lawyer or in-house counsel to the matters they are entitled to see.
Business analytics is not legal or ethics advice; questions about confidentiality duties or billing rules stay with your firm's counsel or your general counsel. If you are also weighing AI assistants for legal work, see Microsoft Copilot for law firms.
Later changes can run on Power BI Flex Support, from $2,500 for 20 hours. Because the reporting is built in Power BI, the Power BI guarantee applies: if you're unhappy working with us at any point in the first 4 hours, your money is returned. All work is remote, and Edward brings 20+ years and 200+ projects; Google reviewers rate Lightray 4.9, and the BBB rates it A+.
Further reading: LEDES Oversight Committee: LEDES 98B format.
Want to see which matters really pay?
Book a free 30-minute call with Edward Pinela, MBA. You get an honest read on what to fix first — and if we are not the right fit, you will hear that on the call.
Frequently asked questions
Is this the same as judge or court analytics?
No. Those products analyze public court data about judges, courts and opposing counsel. This service analyzes your own billing, time, intake and e-billing data. The two can sit side by side, but Lightray does not build or resell litigation research tools.
Which practice management and e-billing systems can you work with?
Any system that can export its data or offers an API. Discovery confirms the route for yours. For legal departments, the LEDES export from the e-billing platform is usually the simplest source.
How long does a project take?
The written quote includes a timeline once discovery has shown how many sources and roles are involved. Consistent phase or task coding speeds things up; where coding is patchy, the first reports focus on the matters where it is reliable.
Do you need to come to our offices?
No. All work is remote, over video and screen share, inside your firm's or company's Microsoft tenant. That also keeps the data where your existing IT and security policies already apply.
What do you need from us?
Read access or exports from the time and billing system or the e-billing platform, timekeeper levels and cost rates if margin is in scope, a list of fee arrangements, and a partner, firm administrator or legal operations lead who can decide definitions.
You Won’t Get Handed Off to Junior Staff.
At most consulting firms, the senior person who sold you shows up for the kickoff — then you get handed to a team of juniors learning on your dime. That’s not how we work.
When you hire Lightray Solutions, you work directly with Edward Pinela, MBA — a principal consultant with 20+ years of experience across Power BI, web development, SEO, and CRM systems. Edward architects every engagement personally, stays involved through delivery, and answers his own phone.
Read Edward’s Full Bio“Mid-market companies deserve senior-level expertise without paying enterprise-agency prices. That’s the gap Lightray fills.”
Simple. Transparent. Proven.
No black-box processes. No endless discovery phases. A straightforward three-step approach designed to deliver measurable results fast.
Discovery Call
Free 30-minute strategy session where we assess your data landscape, website, marketing — and where AI would genuinely pay off versus where it's hype.
Free · No ObligationCustom Roadmap
You receive a tailored plan with clear deliverables, realistic timelines, and expected ROI. You approve every detail before we start.
Fixed Scope · Clear PricingMeasurable Results
We execute, measure, and optimize. You get dashboards, regular check-ins, and full visibility — so you always know the impact.
Data-Driven · TransparentGet a clear plan in one free call.
Tell us what you are trying to fix. Your request goes to Edward Pinela, MBA — the principal consultant who would do the work — and you hear back within 4 business hours.
Prefer to call? +1 (714) 872-9606