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.
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.
NO TRACE
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.
NO FUNNEL
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.
NO OVERVIEW
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.
UNCHECKED
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.
EXPIRED
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.
NO CLARITY
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.
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?
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.
From the blog
Learn DAX before you hire
Three articles that show the rigor behind the dashboards.