What does Kadmoon do?

We are a Power BI and Microsoft Power Platform consultancy. We take scattered raw data to the dashboards your leadership actually opens, on a governed foundation of Microsoft Fabric, Azure Synapse, and Azure. That covers the data engineering underneath, the semantic model with one definition per KPI, the reports on top, and the Power Platform apps and automations around them. Everything is built in your tenant and owned by you.

Do you only work in the Microsoft ecosystem?

Yes, on purpose. We go deep in Power BI, Microsoft Fabric, Azure, Power Platform, and Dataverse rather than spreading thin across five stacks. That focus is why we can move fast, govern by default, and support what we ship. If your data lives in other systems, we connect to them, but the analytics and BI layer we build and run is Microsoft.

How much does a Power BI project cost?

It depends on scope: how many sources we connect, the state of the data underneath, how many dashboards and KPIs you need, and whether governance and a data platform are part of the work. A focused set of dashboards on clean data is a small fixed-scope project. A full data platform on Fabric with governance is larger. We scope it with acceptance criteria and milestone billing, so the price maps to something you can verify rather than an open estimate.

We already have Power BI but it is a mess. Can you help?

Yes, this is common and it is a lot of our work. We inventory the existing reports, find where KPIs disagree, and rebuild on a governed semantic layer so revenue, margin, and churn mean one thing everywhere. We add row-level security, workspace structure, and Purview where they are missing. You keep working the whole time; we fix the foundation underneath rather than starting over.

How does a project start?

With a one to two week discovery. We start from the decisions you need to make, not the data you happen to have, and map the business questions, the sources, the indicators, and the owner of each number. You leave discovery with a diagnosis and an architecture plan. First working dashboards are typically live by week two, then validated with each area every cycle.

What about tenant-to-tenant migration?

It is a signature practice for us. When you move to a new Microsoft tenant, after a merger, divestiture, or restructure, your Power BI reports, datasets, workspaces, and Power Platform environments do not come along by default. We inventory everything, remap dependencies, and cut over in phases so you do not lose years of BI and automation history or leave users without reports mid-move.

Which regions and company sizes do you serve?

We are based in Austin, Texas and work with clients across the United States. We deliver remotely with in-person sessions when a project calls for it. We work with mid-market companies and enterprise teams; the common thread is that data matters enough to govern it. We are a fit whether you need a first governed dashboard or a full Fabric platform with managed support.

Transport and Distribution

Freight cost and OTIF service-level BI

Freight cost and on-time in-full performance by carrier and region, so distribution decisions run on service level and cost, not anecdotes.

Power BIAzure SynapsePower QueryDAX

Freight cost: 6.8%; as a share of net revenue
OTIF: 92.4%; on time and complete
Vehicle utilization: 78.1%; weight and cube combined
Cost per delivery: $41.20; total freight over deliveries

Illustrative figures · fictitious client · under NDA

The challenge

A distribution network could not tell which carriers and regions were hurting service and cost, because tracking, freight, and orders lived in separate systems.

What we built

We consolidated carrier, freight, and order data on a governed model and built Power BI dashboards for OTIF and freight cost by carrier, lane, and region.

A consolidated model over carrier, freight, and order data.
OTIF and freight cost by carrier, lane, and region.
Drill-down to the delivery behind every number.

Outcomes

Service and cost problems traced to the carrier and region.
Freight cost visible against service level.
Distribution decisions on data, not anecdotes.

The dashboard we delivered

Freight Cost and Service Level · National Networkgold_transporte · TMS + ERPRefreshed 07/08 06:40Illustrative data

Report pages

Filters

Period

Last 30 days▼

Mode

Road▼

Carrier

All▼

Hierarchy

Region

Route

Delivery

Region · consolidated

Freight cost-0.9 p.p.

6.8%

as a share of net revenue

OTIF+4.1 p.p.

92.4%

on time and complete

Vehicle utilization+5.2 p.p.

78.1%

weight and cube combined

Cost per delivery-$3.80

$41.20

total freight over deliveries

Deliveries in period

184.2K

Returns

2.1%

Redelivery

3.6%

Average lead time

2.8 days

Freight cost as a share of revenue

Daily percentage, against the 6.5% target

ActualTarget

8.0%7.3%6.7%6.0%

0104071013161922252830

Freight cost by region

Click to open route by route

North has 6% of deliveries and 14% of cost: distance and low utilization on the return leg.

Deliveries in the slice

One row per issued bill of lading

8 of 160 rows

Delivery (BoL)

Route

Carrier

Freight

Weight

Lead time

Status

BoL 560229Southeast

SP metro · last mile

Rodoexpress

$3K

2,752 kg

1 d

On time

BoL 521272Southeast

SP metro · last mile

Meridiano Transportes

$4K

3,285 kg

3 d

On time

BoL 591724Northeast

PE · Recife and metro

Vetor Cargas

$10K

3,619 kg

7 d

Returned

BoL 580959Northeast

PE · Recife and metro

Cabral Distribuição

$5K

1,766 kg

5 d

Late

BoL 552822South

PR · Curitiba and coast

Meridiano Transportes

$3K

900 kg

5 d

Redelivery

BoL 561698South

PR · Curitiba and coast

Vetor Cargas

$2K

3,827 kg

7 d

On time

BoL 598355Midwest

DF · Brasília

Meridiano Transportes

$4K

346 kg

1 d

Returned

BoL 532032Midwest

DF · Brasília

Cabral Distribuição

$4K

598 kg

1 d

On time

Illustrative dashboard with the structure delivered on the project. Client names and figures are fictitious and under NDA.

Want a dashboard like this on your data?

Tell us your scenario and get a diagnosis and a proposal with an investment range within a few business days.

Start a project

More case studies

Business IntelligenceQlikView to Power BI migrationA full legacy BI estate moved to Power BI with inventory, dependency mapping, and a rebuild on a governed model, with no information blackout.RetailA single source of truth on Microsoft FabricSales, inventory, and margin from stores and e-commerce consolidated in OneLake and served to Power BI through Direct Lake.ManufacturingExecutive OEE and cost BIMES and ERP data crossed for OEE, loss, and cost per line and product, refreshed for the people on the shop floor.