Industry guide · Business Intelligence Dashboards

Distribution Planning and Hosting Capacity: Why Your Feeder Map Is Already Wrong the Week After You Publish It

Distribution Planning Hosting Capacity software visual showing sun, gauge, and mapped location.
The short answer

If your hosting capacity analysis is a study a planner reruns by hand once or twice a year and publishes as a static map, a focused build covering an automated calculation pipeline over your own unbalanced model with AMI-derived load shapes and a refreshable published map runs $90,000 to $180,000 and ships in 14 to 20 weeks in our delivery experience. A full platform adding queue-aware capacity, scenario planning for EV and storage, screening integration with interconnection review and capital plan feeds runs $220,000 to $550,000 phased over 8 to 14 months. If you have under about 100 feeders and a DER queue you can read in one sitting, do not build. Run CYME or Synergi Electric studies and publish a spreadsheet. The build case begins when the refresh cycle cannot keep up with the queue.

Why hosting capacity stops being a study and becomes an operating obligation

A distribution planner has 900 feeders and a directive to publish integration capacity by feeder and, on some systems, by node. The way it gets done is a person exporting models out of CYME or Synergi Electric, running a sweep, exporting results, cleaning them in Excel, sending a shapefile to the GIS group and waiting for a map to appear on the website. Elapsed time from model snapshot to published map: three to six months. In that window, forty interconnection applications landed, a dozen projects energized, and the load forecast was revised. The map on your website describes a system that no longer exists, and developers are making siting decisions with it.

That is the shape of the problem regardless of jurisdiction. California utilities produce Integration Capacity Analysis results under the CPUC's distribution planning proceedings. New York utilities publish hosting capacity maps under orders coming out of the state's grid modernization work. Other states have followed with their own versions. In every case the commission asked for something the utility's tooling was never designed to produce: not a study, a maintained data product with a refresh cadence.

The tools are good at what they do. Eaton CYME, DNV Synergi Electric and Milsoft WindMil solve unbalanced distribution power flow properly. Integral Analytics LoadSEER does forecast allocation. EPRI's OpenDSS is free, capable and drives much of the published academic work in this area. None of them ship a pipeline that reads your GIS every week, allocates AMI load to nodes, runs a capacity sweep across every feeder, reconciles the queue and publishes a filtered public map with the right data withheld. That gap is filled by a planner and a spreadsheet, and the planner is the bottleneck.

Problem 1: your model is not clean enough for a node-level answer

Feeder-level hosting capacity is forgiving. Node-level hosting capacity is not, and node level is what developers and increasingly commissions want. To get a defensible per-node number you need phasing that is actually correct, secondary that is actually modeled rather than lumped, transformer connections and impedances that are populated, regulator and capacitor control settings that match the field, and load allocated to service points rather than smeared across the feeder by connected kVA.

Most distribution models fail at least two of those. Secondary is the usual one: many utilities model to the transformer and stop, which means the calculation cannot see the voltage rise a residential system actually causes on its own service. Phasing is the other, because the geometric network never forced it and nobody audited it. Publishing a node-level number off a model with those weaknesses produces confident numbers that are wrong in a direction developers will discover and dispute.

What a custom build does: run the model quality check as a permanent part of the pipeline rather than as a one-time cleanup. Every refresh produces a per-feeder data quality score with the specific defects listed, and feeders below threshold publish at coarser granularity with an honest caveat rather than publishing a precise wrong number. That single design decision protects your credibility with the developer community and gives your GIS group a prioritized remediation list that is generated rather than argued about.

Problem 2: the calculation is a pipeline, and running it by hand is the actual cost

The physics is settled. You are looking for the injection level at which something binds: ANSI C84.1 Range A voltage limits, thermal ratings on conductor and transformers, protection concerns including reverse power through a regulator, fault current contribution and sympathetic tripping, and on some systems flicker and power quality. That is a sweep, iterated per node, ideally across time using load shapes rather than a single peak and minimum condition, because minimum daytime load is where photovoltaic hosting capacity actually binds and peak is where EV load binds.

Doing it with real load shapes means running thousands of hours per node per feeder, which is compute you cannot do by hand and should not do on a workstation. It also means AMI data has to be processed into representative shapes by customer class and season, which is a data engineering job, not a planning job.

What a custom build does: treat the whole thing as a scheduled pipeline. Model extract from GIS on a cadence, AMI shape generation, allocation to service points, capacity sweep distributed across cloud or on-premise compute, results into a store, map publication. A weekly refresh becomes normal instead of heroic. The planner's job changes from running the calculation to reviewing exceptions, which is what you actually hired a planner for. OpenDSS is worth serious consideration as the engine inside this pipeline precisely because it scripts cleanly and has no per-run license friction, with your commercial tool retained for the detailed studies where it is the standard.

Problem 3: the interconnection queue moves faster than any refresh

Published hosting capacity has to answer a question with two parts: what can the feeder take, and what has already been claimed. Projects sit in queue for months. Some withdraw. Some energize. Some get approved at a reduced size. If your map shows capacity net of energized projects only, you are inviting applications into space that is already spoken for and creating disputes you will resolve at your own cost. If it shows capacity net of everything in queue including speculative positions, you are understating and slowing legitimate development.

Neither planning tool nor GIS holds the queue. It lives in the interconnection group's system, sometimes a proper application, often a workbook. The reconciliation between the queue and the model is manual and periodic, and that is where the double counting happens: a project appears both as a queue position and as a modeled generator after energization, and gets subtracted twice.

What a custom build does: make queue state a first-class input with explicit lifecycle, so published capacity can be expressed as available, queued and energized separately. Reconciliation runs automatically by matching queue positions to modeled DER on service point identity, and mismatches go to a review queue rather than into the published number. The interconnection reviewer and the planner then look at the same figures, which removes an argument that currently happens monthly at most utilities.

Problem 4: publishing is a security question you cannot delegate to the web team

A hosting capacity map is a public description of where your grid is constrained. That is exactly the information a utility is otherwise careful about, and critical energy infrastructure information handling is not something to improvise. At the same time, a map that is aggregated into uselessness fails the regulatory purpose and irritates the developers it was meant to serve.

The usual compromise is done by hand: someone decides what layers go out, generalizes geometry, drops attributes, and produces a static export. Because it is manual, it is done rarely, which is precisely why the map is stale. Security and freshness end up in direct conflict because the filtering is a human step.

What a custom build does: encode the publication rules once, as code, and make them part of the pipeline. Attribute-level redaction, geometry generalization to the agreed level, aggregation thresholds, and a diff report so your security reviewer approves what changed rather than reapproving the entire map every cycle. The approval step stays human. The work stops being human, and that is what makes weekly publication possible.

What this costs and how long it takes

Across the 2,000-plus projects Digital Heroes has delivered, the shape here is consistent. A first release covering automated model extraction, AMI load shape processing, a distributed capacity sweep, a results store and a refreshable published map with encoded publication rules runs $90,000 to $180,000 and ships in 14 to 20 weeks. A full platform adding queue reconciliation, scenario planning for EV and storage adoption, screening integration with the interconnection review process, and outputs that feed the distribution capital plan runs $220,000 to $550,000 phased over 8 to 14 months.

What drives it up: node-level rather than feeder-level publication, because the model quality burden rises sharply. Time series analysis with full annual load shapes rather than snapshot conditions, which multiplies compute and storage. Multiple operating companies with different model tools. And the commission's specific format requirements, which are prescriptive in some jurisdictions and add real work to get exactly right.

What keeps it down: start with feeder level and a monthly refresh on your most active 100 feeders by queue volume. That covers the majority of developer interest and proves the pipeline before you commit to node level everywhere.

Build versus buy, and when buying is right

Buy the power flow engine. CYME, Synergi Electric and WindMil are established and your planners already know one of them, and OpenDSS is a legitimate free option for the automated pipeline specifically. Consulting studies are also the right answer at small scale: if you have under roughly 100 feeders and a DER queue you can read in a single sitting, commission a study, publish a spreadsheet, and revisit when the queue grows.

Build when two or more of these are true. A commission has ordered you to publish and maintain hosting capacity results on a defined cadence you are currently missing. Your DER queue moves faster than your refresh cycle, which for most utilities means more than about 20 applications a month. You are being asked for node-level rather than feeder-level results. Your interconnection group and your planning group are working from different numbers. Or EV load is now driving the same conversation from the other direction and you need one pipeline that answers both injection and load questions.

Our position: vendor tools produce studies, and a study is a photograph. What the commission actually ordered, and what developers actually need, is a maintained data product. Those are different engineering problems and the second one is not on any vendor's roadmap for your specific system.

How to choose a developer for hosting capacity work

Ask them how they will allocate AMI load to service points and what they do about customers with no interval data. If they treat load allocation as a solved detail, their numbers will be wrong in a way that only shows up when a developer disputes them.

Ask what happens to a feeder whose model has unknown phasing or unmodeled secondary. The answer you want is that it publishes at coarser granularity with a stated caveat and lands on a remediation list. The answer that should worry you is that the pipeline runs anyway and publishes a precise number.

Ask how the published map handles projects in queue versus energized. If they have not asked you about the interconnection system before answering, they have not thought about the double counting problem that causes most of the disputes.

Ask who owns the code and get it in writing before kickoff, including the pipeline definitions and the results store in an open format. At Digital Heroes the client owns the code from the first commit. Then run a small trial: give them ten feeders with known answers from a past study and see whether their pipeline reproduces them. Ten feeders takes a fortnight and tells you more than any proposal.

Research & sources

The evidence behind this guide

Independent findings on why this investment pays off. Every link goes to the primary source.

  1. Only 22% of firms are 'future ready' having significantly transformed digitally; these companies show average revenue growth 17.3 percentage points and net margins 14.0 percentage points above their industry average. Source: MIT Center for Information Systems Research (MIT Sloan) (2022) →
  2. Deloitte reports that modern ERP implementations aim to deliver reduced manual effort, greater transparency, a single source of truth, and increased productivity, but many organizations do not capture the full expected benefits (a significantly lower ROI) without disciplined strategy, change management, and data readiness. Source: Deloitte (2024) →
  3. Bersin by Deloitte research found organizations that use HR technology and employee-centric design to build a flexible, empowering workplace are more than 5 times more effective at improving employee engagement and retention than their peers, and 2.5 times more likely to reach 'high-impact' status by leveraging HR for digital transformation. Source: Bersin by Deloitte (2017) →
  4. In the Flexera 2025 State of ITAM report, respondents reported roughly 33% of SaaS spend is wasted, underscoring how paying for off-the-shelf seats and tiers that go unused erodes the supposed cost advantage of generic SaaS. Source: Flexera (2025) →
Prasun Anand · CEO & Founder · New York

Prasun founded Digital Heroes in 2017 and leads it from New York. His work sits where commercial decisions meet delivery: which projects to take on, how teams are shaped across five offices, and where a build is likely to go wrong. Readers get the view from the side that owns the outcome.

View profile · Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.

FAQ

Frequently asked questions

How much does it cost to build a hosting capacity analysis system for a utility?
A first release with automated model extraction, AMI load shape processing, a distributed capacity sweep and a refreshable published map runs $90,000 to $180,000 and ships in 14 to 20 weeks in Digital Heroes delivery experience. A full platform adding queue reconciliation, EV and storage scenarios and capital plan feeds runs $220,000 to $550,000 over 8 to 14 months. Node-level publication and full time series analysis are the two choices that move the number the most.
Can we automate hosting capacity without replacing CYME or Synergi Electric?
Yes. Keep the commercial tool for detailed studies where it is the standard your planners and consultants use, and drive the automated sweep with a scriptable engine. EPRI's OpenDSS is widely used for exactly this because it automates cleanly and carries no per-run license friction. The pipeline around the engine is what you are building: model extraction, load allocation, distributed compute, results store and publication.
Why do our hosting capacity numbers get disputed by solar developers?
Usually because the model behind them cannot support the granularity of the published answer. Unmodeled secondary means the calculation cannot see the voltage rise a residential system causes on its own service, and unverified phasing skews unbalanced results. The honest fix is publishing at the granularity your model actually supports, with a stated caveat on weak feeders, rather than publishing a precise number that will not hold up.
How often should a hosting capacity map be refreshed?
As often as your queue moves, which for an active system means monthly at minimum and weekly where development pressure is high. The reason most utilities publish annually is that the process is manual, not because annual is defensible. Once the calculation is a scheduled pipeline with encoded publication rules, refresh frequency becomes a scheduling decision rather than a staffing decision.
How do we publish a hosting capacity map without exposing sensitive grid information?
Encode the publication rules as code rather than performing them by hand: attribute-level redaction, geometry generalization to an agreed level, and aggregation thresholds, all applied automatically with a diff report for your security reviewer to approve each cycle. The approval stays human, the filtering does not. Manual filtering is the specific reason security and freshness end up in conflict.
Should hosting capacity be published at feeder level or node level?
Feeder level is achievable on most utility models today and answers the majority of siting questions. Node level is what developers prefer and some commissions now expect, but it exposes every weakness in your model, particularly unmodeled secondary and uncertain phasing. A reasonable path is feeder level everywhere plus node level on the feeders whose model quality supports it, with the gap published as a remediation backlog.
How do we keep the interconnection queue and the hosting capacity map in sync?
Make queue state an explicit input with a lifecycle, and publish available, queued and energized capacity as separate figures rather than one net number. Reconciliation should match queue positions to modeled DER on service point identity automatically, sending mismatches to a review queue instead of into the published result. Double counting a project once it energizes is the most common source of quiet error.
Does EV load charging analysis use the same system as solar hosting capacity?
It should, because it is the same model, the same load shapes and the same binding constraints approached from the opposite direction. Photovoltaic capacity typically binds at minimum daytime load on voltage, while EV charging binds at peak on thermal limits and transformer loading. Building two separate pipelines for the two questions is a common and expensive mistake.
Do we need this if we are a small utility with a slow DER queue?
No. Under roughly 100 feeders with a queue you can read in one sitting, commission a consulting study, publish a spreadsheet and revisit when volume grows. The build case starts when a commission has set a refresh cadence you are missing, when applications exceed about 20 a month, or when your interconnection and planning groups are quoting different numbers to the same developer.
If we move off Power BI or Tableau later, do we lose our historical data and reports?
Your raw data is safe because it lives in your source systems or warehouse, not inside Power BI or Tableau. What you lose is the logic layered on top: DAX measures, calculated fields, and report layouts all have to be rebuilt, and that rebuild is the real switching cost. Protect yourself now by keeping transformations in dbt or in warehouse views instead of inside the BI tool, so a future migration only replaces the screens.
What are the most common mistakes companies make on dashboard projects?
The four we see most: designing charts before modeling the data, cramming 30 metrics onto one screen so nothing stands out, letting every team define revenue slightly differently, and skipping data quality checks so the dashboard confidently displays wrong numbers. The wrong-numbers failure is the fatal one, because a dashboard loses trust once and never fully earns it back. Spend the first weeks on metric definitions and data quality, not on colors.
We already pay for Microsoft 365. When does building custom actually beat Power BI?
Keep Power BI for internal reporting; at $14 per user per month for Pro it is hard to beat for employee-facing analytics. Custom wins in three cases: you are showing dashboards to customers, since embedded Power BI is priced on capacity and gets expensive fast, you need a fully white-labeled experience inside your own product, or your team keeps fighting the tool to support a specific workflow. Most companies we build for keep Power BI internally even after launching a custom customer-facing dashboard.
How long does it take to build a custom web or mobile app from scratch?
Plan on 8 to 16 weeks for a focused first version and 4 to 9 months for a larger platform, which is the typical spread across Digital Heroes builds. The first 2 to 3 weeks go to discovery and design before any production code ships. The two things that stretch timelines most are integrations with legacy systems and slow feedback from your side, not developer speed.
When does Looker make more sense than a custom dashboard?
Looker earns its place when multiple teams keep producing conflicting numbers and you need one governed definition of every metric, because LookML enforces definitions centrally. Its pricing is quote-based, and the quotes clients bring to Digital Heroes typically start in the tens of thousands of dollars per year. Under roughly 50 users with straightforward reporting needs, that spend is hard to justify against Power BI or a scoped custom build.
Should I embed Power BI or Tableau in my SaaS product, or build custom charts?
Embed first if you need analytics inside your product within weeks, but treat it as a bridge rather than the destination. Embedded licensing meters your customer traffic, so your analytics cost grows with your user count, and the look and feel never fully matches your product. In Digital Heroes projects, SaaS teams usually switch to custom charts built in React with a library like ECharts or Recharts once analytics becomes a selling point instead of a checkbox.
What questions should I ask a development agency on the first call?
Ask who exactly will build it, what happens when scope changes mid-project, what their maintenance terms are after launch, and what they will need from you every week. Then ask them to describe a project that went wrong and what they changed afterward; teams that have shipped at real volume have war stories, and teams claiming a perfect record are hiding something. The scope-change answer matters most: a disciplined shop describes a written change-order process, not a vague promise to be flexible.
What does it cost to keep custom software running after launch?
Budget 15-20% of the original build cost per year, which on a $100,000 system means $15,000 to $20,000 for security patches, dependency updates, bug fixes, and small improvements as real usage reveals what the spec missed. Cloud hosting for a typical business application adds $50 to $300 a month on top. Skipping maintenance does not save the money; in Digital Heroes rescue work, unmaintained systems typically need a far more expensive rebuild within about three years.
Will a custom dashboard stay fast once our data hits millions of rows?
Yes, if it aggregates before it displays; no dashboard should scan millions of raw rows on every page load. The standard techniques are pre-aggregated summary tables, incremental refresh, and caching, which keep typical page loads under 2 seconds even on datasets in the hundreds of millions of rows. Ask your vendor how the dashboard behaves at 10 times your current data volume; a good one gives a specific answer about aggregation, not just a bigger server.
How does a custom dashboard handle compliance requirements like SOC 2, HIPAA, or GDPR?
A custom build gives you direct control over the controls auditors ask about: single sign-on, role-based access, audit logs, encryption, data residency, and deletion workflows. For HIPAA specifically, you can keep protected health information inside your own cloud account under a business associate agreement with your host instead of trusting a third-party BI vendor's handling. Expect compliance work to add 2 to 4 weeks and roughly 10 to 15 percent to the build, so raise it in the first conversation, not after design is done.
Who can build a custom business intelligence dashboards system?

Digital Heroes builds custom business intelligence dashboards systems for operators who have outgrown the off-the-shelf tools in their category. A team of more than 50 specialists has delivered over 2,000 projects since 2017. Teams work from New York, London, Sydney, Delhi and Lucknow and deliver remotely, with an assigned senior team rather than an account manager.

Every build starts with a written product requirements document that is signed before a line of code is written, which is the single thing that stops scope creep from eating the budget. Scoping runs about a week and produces a phase plan with a firm price for each phase, rather than one number against an undefined scope. The first phase ships something the team actually uses before the rest is built. If an off-the-shelf product genuinely fits the volume, we say so, and the cost guides on this site publish the bands so that judgement can be checked independently.

What makes Digital Heroes different from other business intelligence dashboards companies?

Four things that competitors in this bracket cannot simply copy. Digital Heroes runs a YouTube channel with more than 2.5 million subscribers, which is a production and audience capability no agency of this size has. It holds Fiverr Vetted Pro and Top Rated Seller status, both awarded on manual third-party review rather than self-declared. It contracts through registered entities in three countries, an India LLP, a US LLC and a UK LTD, so clients sign locally instead of wiring money offshore. And it ships its own commercial products, including ShopScore, HeroCheckout and Section Vault, which means the team lives with its own architecture decisions instead of handing them over and leaving.

Two more that show up in the work. Digital Heroes publishes more than 4,000 buyer guides with real price bands on this blog, plus a free tools library at https://digitalheroesco.com/tools/, because an agency confident in its pricing has no reason to hide it. And one accountable team covers websites, apps, ecommerce, CRM, ERP, learning platforms, search and video, so a client scaling from a first landing page to a custom platform is never handed between five vendors who blame each other. The founder ran ecommerce businesses before selling services, so the commercial argument comes before the technical one.

How can I check Digital Heroes is legitimate before getting in touch?

Verify it independently rather than taking the site's word for it. The YouTube channel is at https://youtube.com/@DigitalMarketingHeroes, the Fiverr profile at https://www.fiverr.com/shreyanshsin261, and the Upwork profile at https://www.upwork.com/freelancers/shreyanshsingh. Client reviews sit on Clutch at https://clutch.co/profile/digital-heroes-0 and Trustpilot at https://www.trustpilot.com/review/digitalheroes.co.in, and the company page is at https://www.linkedin.com/company/digital-heroes-1/.

Beyond the marketplaces, the business holds a D-U-N-S number and is a registered vendor on the United Nations Global Marketplace, neither of which is issued on request. Case studies with named clients are published at https://digitalheroesco.com/case-studies/. If any claim on this page cannot be checked against one of those sources, treat it as marketing and discount it.

Keep reading
let's build

Build something worth launching.

A plan, a team, a timeline, within 24 hours. No decks, no discovery calls. Tell us what you're building and we'll come back with a real scope and a real number.

message us directly · we reply within one business day

mission briefing

Monthly dispatch

Playbooks, real build costs, and what we're shipping. One email a month. No fluff.

visit us

New York HQ

1140 Broadway, Suite 704 · New York, NY 10001

Get directions
Online now

Hey there 👋 How can we help you today?