Data, software & automation studio

If life gives you Yuzu,
chart it!

chart it!

Business intelligence, custom web apps, AI automation, and team training, for companies of every size. Senior specialists, hands-on from the first squeeze to the last drop.

🍋 Our Recipes

Four things we do really well

Each recipe stands on its own, and they blend well together: most clients start with one and add another as they grow.

01Yuzu · The Single Pour

Business Intelligence

Numbers everyone trusts.

From scattered spreadsheets to a governed data platform, a single semantic model, and dashboards that stay fast and correct.

What's in the glass

  • Data platforms & pipelines
  • Semantic models & executive dashboards
  • Performance rescue & model cleanup
  • Power BI
  • Fabric
  • SQL
See the recipe

02Orange · The First Press

Custom Web Apps

Software shaped around your work.

Client portals, internal tools, and industry CRMs, connected to the tools you already use. Built the way we built Dossierly.

What's in the glass

  • Client portals & internal tools
  • Integrations: payments, calendars, CRM, ERP, accounting
  • Production-ready, documented code
  • React
  • TypeScript
  • Supabase
See the recipe

03Lime · The Zest

AI & Automation

Routine work that runs on its own.

Intake, approvals, routing, and follow-ups, automated with AI where it helps and predictable logic where it doesn't.

What's in the glass

  • Workflow & document automation
  • AI agents with human approval
  • Monitoring, alerts & audit logs
  • Python
  • Azure OpenAI
  • Power Automate
See the recipe

04Grapefruit · The Accelerator

BI & AI Training

AI workflows your team keeps using.

Hands-on training for business intelligence and product development teams, on your own data and code, with playbooks your team keeps.

What's in the glass

  • AI workflows for BI teams
  • AI workflows for product development teams
  • Power BI, Fabric & Git foundations
  • Copilot
  • Cursor
  • GitHub
See the recipe
🍋 Right Fruit, Right Press

Who We Work With

From a single tree to a whole orchard: the same four recipes, sized to your organization. Pick your size to see what that usually looks like.

The young tree Small businesses & practices Owners and small teams ready to move beyond spreadsheets and email
The growing grove Growing companies Teams whose systems need to work together
The whole orchard Enterprises BI and IT teams that need senior hands and clean standards

Built by Yuzu · Live product

The CRM we designed, built, and run for Canadian immigration consultants and lawyers. Client portal, IRCC forms, booking, e-signature, and payments in one workspace, hosted in Canada.

It is also the best example of how we build for clients: real users, real payments, and real integrations with the tools a practice already uses.

  • Square
  • Stripe
  • Google Calendar
  • Outlook
  • Teams
  • Zoom
  • Sage
Dossierly firm dashboard showing files that need action and today's bookings
🍋 Squeezed from experience

Our track record, in numbers

What our team has built, shipped, and kept running over years in data, BI, and software.

Business Intelligence

3,200+

Dashboard users

People relying on reports our team has built.

Business Intelligence

50+

Semantic models

Governed Power BI models designed and shipped.

Business Intelligence

78 → 4 min

Fastest refresh cut

One model's refresh time after a Mirroring and Direct Lake redesign.

AI & Automation

36

Automations in production

Agents, flows, and pipeline jobs put live and kept running.

AI & Automation

2.6K

Contracts sent automatically

Sent for e-signature with no manual step, by workflows our team built.

Custom Web Apps

1

Live SaaS product

Dossierly, built and run by Yuzu.

🍋 Taste test

Test our automations

Real patterns we deliver for clients. Pick one, try it, or open the full demo.

STM Live Dashboard

A real-time transit BI demo for Montréal’s STM: live bus positions from GTFS-RT, service alerts from API i3, and métro trains estimated from scheduled headways — all sliceable in one view.

Same pattern we ship for ops teams: a secure proxy, governed refresh, and a dashboard that stays readable under load. The embed below is the compact version; open the full page for every slicer and the vehicle table.

  • Ingest: GTFS-RT + service alerts via a Supabase Edge Function
  • Enrich: load, speed, and freshness on every vehicle
  • Slice: filter by line, load, or map colour mode
  • Govern: API key stays server-side — never in the browser

Live preview

Live map preview · open the full dashboard for every slicer and the vehicle table.

🍋 Our Vision

Extracting Value

Raw data is just a crate of lemons. Our vision is simple: extract what matters, refine it until it's clear, and serve it in a glass you actually want to drink. That's ETL, the Yuzu way.

Extract

🍋

Squeeze the lemons

We pull raw data from every source: databases, APIs, spreadsheets, and legacy systems. Every lemon goes into the press. Nothing useful left behind.

Transform

⚗️

Filter, blend & sweeten

Pulp out, sugar in. We clean, filter, join and reshape the raw juice, fixing types, removing duplicates, and adding the business logic that gives it the right flavour.

Load

🥤

Serve it in the perfect glass

The finished juice is poured into a polished glass, a governed warehouse and dashboards your team can drink from. Clear, fresh, and ready for decisions.

🔁
♻️ Always Fresh

ETL is refreshing. Automated, it's a fountain that never runs dry.

Squeezing by hand is fine once. But the real magic is a machine that does it for you, pipelines that refresh themselves on schedule, every morning, while you sleep. No manual squeezing. Just value on tap.

🍋 Pick your pour

Two ways to work together

Work directly with the specialists doing the work, on the terms that fit your project.

By the hour

Senior hands when you need them: advisory, reviews, fixes, and ongoing improvements. Flexible, with no long commitment.

  • Ongoing support for your BI or apps
  • Extra capacity for your team
  • Expert reviews and second opinions

Not sure which fits? We'll recommend one on the first call.

Book a 30-minute call
🍋 The Head Squeezer

Our Team

Senior specialists who believe every dashboard deserves a little zest.

Adrien Yvin, founder of Yuzu.solutions

Adrien Yvin

Founder · Data Platform Architect

Seven years in data, from ETL pipelines at an energy utility to machine-learning pricing models inside a $4B packaging company. Most recently led a BI squad at Cascades, architecting Microsoft Fabric solutions that turn raw transactional data into boardroom-ready decisions.

Now full time on Yuzu.solutions: BI, custom web apps like Dossierly, AI automation, and training, with the same precision and care.

🎓

BBA, Business Intelligence · HEC Montréal · Cum Laude

7
Years in Data
1
Live SaaS product
3
Languages

Experience

  1. 2026 – now

    Founder, full time

    Yuzu.solutions · Dossierly

  2. 2024 – 2026

    Expert BI Analyst & Squad Leader

    Cascades

  3. 2021 – 2023

    Business Intelligence Analyst

    Keurig Dr Pepper Canada

  4. 2021

    BI Consultant

    Énergir

Core Stack

Power BI Microsoft Fabric SQL DAX Python React TypeScript Supabase Snowflake BigQuery REST APIs & webhooks AI agents
🍋 Fresh answers

Common questions

The short version of what most people ask on a first call.

Still have a question?

Ask it directly. You'll get an answer from the person who would do the work.

Our services

What does Yuzu.solutions do?

Four things: Business Intelligence, Custom Web Apps and their integrations, AI & Automation, and BI & AI Training. We also build and run our own product, Dossierly.

Do you work with small businesses or only enterprises?

Both, and everything in between. A small practice might need a first dashboard or a client portal; an enterprise might need Fabric governance or a performance rescue. The services are the same; the scope fits your size. See examples by company size.

Can you work alongside our existing team?

Yes. We can add senior capacity to your BI or development team, review their work, or train them so they can keep things running on their own afterwards.

What technologies do you use?

Power BI, Microsoft Fabric, SQL, DAX, Snowflake, and BigQuery for BI; React, TypeScript, and Supabase for web apps; Python, REST APIs, Power Automate, and OpenAI / Azure OpenAI for automation; Copilot, Cursor, and GitHub for AI workflows.

Working together

How do we get started?

Book a 30-minute call. We talk about your data, your tools, and what you want to change, then recommend hourly support or a package, with the scope agreed before any work starts.

How do you charge?

Two ways: by the hour for flexible, ongoing work, or as a package with a fixed scope and deliverables agreed up front. We'll recommend the right fit on the first call.

Do you work in French and Spanish?

Yes. We work in French, English, and Spanish, and training can be delivered in any of the three.

Where are you based, and where do you work?

In Montréal, Québec. Most of our clients are in North America, and we work remotely with teams around the world.

About us

What is Dossierly?

Dossierly is the CRM we built for Canadian immigration consultants and lawyers: client portal, IRCC form filling, booking, e-signature, and payments, with data hosted in Canada. It's live at dossierly.ca.

What makes you different from traditional consultants?

We spend most of an engagement building: pipelines, models, apps, and automations, not meetings and slide decks. You work directly with the specialists doing the work, and the strategy comes out of that work.

Latest from Insights

View all insights →