Power BI dashboard + website for insurance brokers

Your portfolio,protected by data.

A dashboard that shows what expires, what earns and who to call today, and a website that brings quote requests instead of window-shoppers. For brokers tired of deciding in the dark.

Move your mouse: the umbrella follows.

The policy pile

Six papers piling up on your desk.

Tuesday, 8:40 AM. The auto-insurance client just signed with another broker: the policy expired last week and nobody warned you. Scroll and watch each issue get its stamp.

01
Acquisition · Website

Clients can't find you

“My website is an idle business card. Leads land on WhatsApp and I don't even know where they came from.”What we build

A fast website with quotes by line, pages built for Google (by line and city) and a WhatsApp button that already reports where the contact came from.

02
Quote · Dashboard

Quotes that never become policies

“I send dozens of quotes a month and don't know how many turn into policies, or why not.”What we build

A quote → proposal → issued funnel by channel, line and broker, with the reason for every loss.

03
Issuance · Dashboard

Ten portals, no overview

“Every insurer has its own portal. I keep opening tabs just to build one report.”What we build

One consolidated portfolio: premium, line, insurer and channel on a single screen, refreshed without copy and paste.

04
Commission · Dashboard

Commission nobody checks

“The statement arrives as a PDF and I only find the gap months later.”What we build

From premium written to the commission the brokerage keeps, by insurer and line, with expected-versus-received checks.

05
Renewal · Dashboard

Lost renewals

“I find out the policy expired when the client has already signed elsewhere.”What we build

An expiry radar, commission up for renewal and at risk, and a list of who to call today.

06
Profitability · Dashboard

Sells a lot, can't tell what pays

“Which line earns the most per dollar sold? Which insurer do I depend on too much?”What we build

A volume × commission quadrant by line, insurer concentration and cross-sell: who has auto but no home cover yet.

Do the math

What is a slightly better renewal rate worth?

Enter your brokerage's numbers. The calculation runs in your browser, nothing is sent, and the result is an estimate to start a conversation, not a promise.

Simple estimate: policies × points gained × average premium × commission. Ignores seasonality and cancellations.

stayleaveextra with improvement
Policies lost per year
Commission lost with them, per year
If renewal improves, you keep
and preserve in commission per year
See this with my real data →
See it working

A brokerage dashboard, open for you to play with.

This is Carteira Viva, a dashboard we built as a demonstration. Filter by year, region and channel, move through the side menu and open it full screen. The data is fictional; the design, the questions and the care in reading are what we deliver.

Hover and tilt

Questions the dashboard answers

  • OverviewHow much did we write and how much commission is left, against last year?
  • LinesWhich line earns the most per dollar sold?
  • InsurersWhich insurers do we depend on?
  • ClientsWho has one product and still lacks the other?
  • RenewalHow many policies stay, and in which lines and channels do we lose them?
  • ActionsWhat should we do on Monday?
Open full screen ↗
What the dashboard delivers

Numbers that become decisions.

5,000policies in the demo (fictional data)
13screens, from overview to actions
8alerts that point to what to do
7insurance lines in the dashboard
Client 0001instead of name and email in the demo
Two fronts, one goal

A dashboard that shows. A website that brings.

Dashboard for brokers

Custom Power BI
  • Premium, commission, renewal and portfolio by line, insurer and channel
  • Expiry radar and commission at risk
  • Cross-sell: who has X and lacks Y
  • Alerts with a recommendation, not just numbers
  • A view for management and a view for each broker
Premium—
Commission—
Renewal—
⚠ 3 policies expire in 30 days
Illustrative example

Brokerage website

Fast, clear, measurable
  • Quote requests by line (auto, home, life, business) delivered to your WhatsApp or email
  • Pages by line and by city, built for Google
  • Trust up front: regulator registration, partner insurers, privacy
  • Tracking of how many quotes came from each channel
  • Versions in Portuguese, English and Spanish

Insurance quote

LineAuto
Name••••••
Get my quote
Sent to the brokerage's WhatsApp ✓
Illustrative example
Insurance data is sensitive data

Designed for privacy law from the first sketch.

Only what's needed

The dashboard works with the minimum: in the demo a client shows up as “Client 0001”, with no name or email.

Less data, less risk.

Everyone sees their own

We can set up access profiles so each broker sees only their own portfolio.

Profile-based access, no exposure.

Stated criteria

Every metric has a written definition and threshold, and what the data cannot calculate is said on the dashboard.

Nothing hidden behind a number.

Tap or hover

How we work

From problem to live dashboard

Diagnosis

We talk about the questions you can't answer today and where the data comes from.

Design

We define metrics, alerts and look before writing the first line.

Build

We connect, model and publish. You validate every step.

Evolution

We watch usage and adjust what the team really looks at.

FAQ

Frequently asked questions

Do I have to replace my brokerage management system?

No. We work with whatever your system, the insurers' portals and your spreadsheets can export. We confirm sources in the diagnosis.

Does it work with several insurers at once?

Yes. What changes from one insurer to another is the report format; we standardize everything in the data model so you can see the whole portfolio.

Does the website price the policy instantly?

The website collects the quote details and sends them to you. Automatic pricing depends on integrating each insurer's quote engine, which we assess case by case.

Is my clients' data safe?

We use minimum access, per-user profiles when needed and respect data-protection law. The data stays yours.

Do I already need Power BI?

No. We work out with you the publishing format and licensing that fit the size of your brokerage.

How long does it take?

It depends on scope and source quality. In the diagnosis we agree on timelines and deliverables in writing before we start.

Next step

Stop finding out too late that a policy walked away.

Tell us which question your brokerage still can't answer. We'll return with a clear path, no commitment.

Chat on WhatsApp →

The umbrella closes. The portfolio stays protected.