Data & AI

Data your leadership trusts. Agents that talk with your data.

We bring ERP, CRM and spreadsheets into one source of truth, build the Power BI reports management uses every week, and connect AI agents that answer your questions, citing the source of every number.

Management report · 2026
Sales · Oct€545k▲ 9,7% vs Sep
Gross margin32.4%▲ 0,6 pp
J F M A M J J A S O N D
Sales (€k)Margin (%)Click a month

What was our best month this year?

October, with €545k in sales: 9.7% up on September and the highest month of the year.

Source: “Sales” semantic model · Power BI
See how it was calculated

Change = October sales ÷ September sales − 1 = 545 ÷ 497 − 1 = +9.7%

Who trusts us

Sound familiar?

The data exists. The problem is trusting it in time.

Month-end takes days

Someone reconciles ERP exports and spreadsheets by hand before every management meeting.

Every team has its own number

Sales, finance and operations bring different figures for the same thing.

Know-how lives in inboxes

Replies to customers and suppliers depend on who remembers the last similar case.

AI never left the demo

There was a ChatGPT pilot, but nothing made it into daily work.

What we do

From ERP to decision, on one route.

We connect any data source into a lakehouse on Microsoft Fabric, Databricks or Snowflake. From there come the management reports, questions to your data, the AI agents and the alerts that land in Teams.

ERP SAP, Dynamics or any other CRM and sales customers and quotes Excel and files SharePoint, folders, email APIs and databases banks, web, SQL DATA LAKEHOUSE One source of truth everything together, same rules Bronze· collected data as it arrives Silver· cleaned no errors, no duplicates Gold· ready for reports and AI Microsoft Fabric Databricks Snowflake Fabric · Databricks · Snowflake Power BI Reports and self-service AI agents Questions and tasks Teams and email Alerts and status updates

Our stack

We choose the platform for the need, not the brand.

  • Microsoft Fabric
  • Power BI
  • Databricks
  • Azure
  • Snowflake
  • Claude

Proof

Measured results, not promises.

Industrial manufacturer

An AI agent that drafts the technical support team’s replies

The technical support team answered service requests from around the world using memory and old emails. The goal was to answer every request within 24 hours.

AI agentsMicrosoft TeamsPower AutomateGitSQL
Before the pilot 62%
Pilot target 100%
3,483past requests organised as searchable cases
62% → 100%requests answered within 24 h: the baseline and the pilot’s target

Industrial manufacturer

Spare-part delivery dates

The parts team received around 30 emails a day from sales asking when a part would arrive. Many were repeats.

ERP integrationWeb appPython
Emails a day asking for dates ~30
With the portal: self-service 0 emails
~30/day“when will it arrive?” emails the portal now answers
1,273supplier receipts behind the lead-time estimate (median)
Dailyautomatic, read-only refresh from the ERP
BUSINESS SYSTEMERPalready in placeSales ordersopen customer linesPurchasesto suppliersReceiptsactual lead timesdirect linkWEB PLATFORMDelivery portalwhat it does, every day1Collectsdaily, on its own2Matchesline by line3Estimatesthe arrival dateSales teamchecks, no emailsReallocationsbetween ordersParts teamfewer questions
The platform in use: open lines, coverage by purchase order and expected date (customers and parts blurred)

Services company

Finance back office on Microsoft Fabric and Power BI

We use at NAVRA what we propose to clients. We connected the company bank account directly to Fabric to get categorised costs and income without exporting statements.

Microsoft FabricPower BIAzure Key VaultVAT forecasting
0 statementsexported by hand: transactions arrive on their own every day
3 layersbronze, silver and gold in the Fabric lakehouse
0 secretsin code: credentials live in Azure Key Vault
Banktransactions every dayRulescompany categoriesTax calendarVAT deadlinesLAKEHOUSEOrganised datathe bank, with no statement exportsBronze· collectedas they come from the bankSilver· cleaneddeduplicated, categorisedGold· readyfor reports and forecastsCostscategorised automaticallyDaily trackingbalance and costs todayVAT forecastwhat to pay this quarter

NAVRA internal project

Vasco, the assistant that works with us every day

We are two partners, and the company’s context was scattered across emails, meetings, Notion and SharePoint. After every meeting, one of us spent around 30 minutes writing down what was decided and preparing the next steps.

AI agentsAgent skillsMicrosoft TeamsGitKnowledge base
~30 mina partner used to spend after every meeting recording decisions and preparing next steps
15 minevery 15 minutes on working days, Vasco looks for meetings that have ended and handles them
0 emailssent to clients by the assistant: it only creates drafts, which the partner reviews and sends

E-commerce

Sales and returns dashboards for management

Returns processing relied on manual reports and several sources that did not reconcile.

Power BIData modellingERP, CRM, Excel & API data
Processing time before 100
After 44
−56%in processing time
4 sourcesERP, CRM, Excel and APIs in one model
NAVRA Power BI report

See all case studies →

Who you will work with

The team behind NAVRA.

José Calheiros

José Calheiros

Builds data platforms on Databricks and Microsoft Fabric, and the Power BI reports management relies on. Previously at DevScope, a Microsoft partner.

€2B+in revenueled refunds and returns BI at Autodoc

Gonçalo Sousa

Gonçalo Sousa

Ran the digital department at an international industrial manufacturer, building the after-sales and operations dashboards and, with AI, the planning tools.

20+manufacturing and logistics companies supported as an ERP consultant

Meet the team →

How we work

A short route, with marked stops.

  1. 01

    Diagnostic

    Sources, reports and processes reviewed. You get a prioritised plan with effort and budget.

  2. 02

    First delivery in weeks

    Small modules, so the team uses results early.

  3. 03

    Adjust with use

    We measure what the team actually uses and correct course with every delivery.

  4. 04

    Team autonomy

    Documentation and training so your team owns the solution.

Certifications and partnerships

  • PL-300Power BI Data Analyst Associate
  • DP-600Fabric Analytics Engineer Associate
  • DP-500Azure Enterprise Data Analyst Associate
  • DP-900Azure Data Fundamentals
  • AZ-900Azure Fundamentals
  • DatabricksData Analyst Associate
  • SnowflakeSnowflake Fundamentals

FAQ

What people ask before we start.

What is self-service reporting and how do we set it up?

It means business teams build their own analysis without requesting a new report each time. It needs a certified Power BI data model with metrics defined once, access by department, and short training. We build the model and teach the team to use it.

What is conversational analytics?

Asking your data questions in plain language ("why did margin drop in April?") and getting the figure, the chart and the source. We use Copilot in Power BI, Microsoft Fabric data agents, or Claude connected to the semantic model. Answer quality depends on a well-built model, so that is where we start.

What is a “single source of truth”?

It means all your company data in one place, clean and with the same rules, so sales, finance and operations see the same number. Technically it is called a data warehouse or lakehouse. We build it on Microsoft Fabric, Databricks or Snowflake, depending on what you already use.

Why a small team like NAVRA?

Because the two partners do the work themselves: they are in the meetings and in the technical work, from diagnostic to delivery. We are a Microsoft partner, hold Microsoft and Databricks certifications and, when a project needs more people, we work with partners we know.

Do we need Microsoft Fabric or Databricks?

Not always. Many companies start with Power BI on top of the ERP and a few spreadsheets. The diagnostic tells you whether a single source of truth pays off and which platform fits what you already have.

Is our data safe when we use AI?

The data stays yours, and model providers cannot use it to train models. When needed, we run the models in your own cloud account, in an EU region. We explain the options before we start.

How long until the first delivery?

We work in small modules so there are results in the first weeks.

Do you work with companies outside Portugal?

Yes. We work in English and Portuguese, in the same time zone as London.

Next step

Start with a 30-minute call.

Tell us where time goes on data and reporting. On the call we will say plainly whether and how we can help. If it makes sense, the next step is a diagnostic with a prioritised plan, effort and budget.

You talk directly to José or Gonçalo.
Book a 30-minute call →