CACodex Analytica

Service · 01 of 03

Senior delivery on Power BI,
Qlik Sense, and Fabric.

Star-schema models, ms-budgeted DAX, RLS, and audit-ready handover packs, shipped by a senior engineer with an AI fleet behind them, not a team of juniors and a producer.

ms-budgetedDAX performance baseline
100%Senior on every keystroke
2.4 wksAvg time to first deploy
kpi wall · livelive

MRR

$412,803 0.0%

Active Tenants

3,842 0.0%

NPS

67 0.0%

Avg fill days

11.4 0.0%

What we deliver

4 sub-disciplines.
Pick one or all.

schema · star modellive
01 ·

Star-schema data models

Properly modelled fact + dimension tables that scale to billions of rows and don't drift across teams.

  • Fact / dimension separation reviewed by a senior
  • Surrogate keys, slowly-changing dimensions, conformed marts
  • Aggregation tables and incremental refresh tuned to your workload
  • Lineage diagrams and metric definitions documented
dax · power bilive
active-tenants.daxmodel.bim
02 ·

DAX & set analysis tuning

Performance-first measures that meet a millisecond budget, instrumented in DAX Studio with before/after numbers.

  • Measure rewrites with execution plans verified
  • Storage Engine vs Formula Engine balance optimised
  • Calculation groups, time intelligence, RLS-aware patterns
  • Documented metric catalogue your team can extend
deploy · prod-au-001live
03 ·

Deployment, RLS, and refresh

End-to-end deployment to your tenancy with row-level security, gateways, and refresh schedules audit-logged.

  • Reproducible deploys via Power BI / Qlik CLI pipelines
  • Row-level security tested against real personas
  • Gateway, dataflow, and refresh schedule wired
  • Source-code escrow snapshot for retainer clients
agent · session cx-9F2Alive
04 ·

Existing-asset audit

Five-day deep look at one report or model. You leave with a ranked action plan and an honest answer.

  • Performance, security, UX, and lineage assessed
  • Quick-wins separated from structural rebuilds
  • Written report + 60-min readout call
  • Audit fee credited 100% if you sign a project within 30 days

Methodology

How a BI engagement runs.

Same rigour, every project. You see Friday demos, you own the code, you leave with an audit-ready handover pack.

  1. 01Stage

    Diagnose

    Discovery call, walkthrough, and a fixed-price written scope within five days. No engagement without a fixed price.

    to written scope

    5 days

  2. 02Stage

    Design

    Star schema and metric catalogue locked in writing. Wireframes for every surface. Stakeholder sign-off before any dashboard exists.

    metrics catalogued

    12+

  3. 03Stage

    Deliver

    Friday demos with a Loom recording. DAX timed in DAX Studio. Deploys reproducible. RLS verified against personas.

    DAX budget

    ms

  4. 04Stage

    Document

    Lineage, runbook, refresh schedule, RLS configuration, source-code escrow snapshot, 30-day priority support window.

    handover pack

    28pp

Tech stack

The tools we’ve shipped to production.

We don’t pretend to be neutral. We pick stacks we’ve put on a SOC-audited tenant.

Platforms

  • Power BI Premium
  • Power BI Pro
  • Microsoft Fabric
  • Qlik Cloud
  • Qlik Enterprise

Languages

  • DAX
  • M / Power Query
  • Set analysis
  • Qlik load script

Tooling

  • DAX Studio
  • Tabular Editor 3
  • Vertipaq Analyzer
  • Bravo for Power BI

Source control

  • Git
  • Power BI projects (.pbip)
  • Power BI CLI
  • Qlik CLI

Sample deliverable

What you actually receive.

A finance dashboard for a 5,000-tenant property portfolio. Every measure documented, every refresh logged, every persona's RLS verified.

  • Star schema with 1 fact + 8 conformed dimensions
  • 142 measures, ms-budgeted and audit-traced
  • RLS for 12 personas, verified end-to-end
  • Lineage + runbook + refresh schedule (.pdf, 28 pp)
kpi wall · livelive

MRR

$412,803 0.0%

Active Tenants

3,842 0.0%

NPS

67 0.0%

Avg fill days

11.4 0.0%

Questions we get

Before you sign.

Anything else? Send a question to admin@codexanalytica.com.

    #01Power BI Pro, Premium, or Fabric?

    Whatever you have. We design models that work on Pro and unlock Premium / Fabric features when available: Direct Lake, Lakehouse queries, notebook integration, semantic-link, and Copilot.

    #02Can you optimise existing reports?

    Yes. Performance audits with DAX Studio + Tabular Editor are one of our most-requested services. We typically find 40–80% improvement on first pass; many measures land in single-digit milliseconds.

    #03How do you handle row-level security?

    Roles defined as DAX filter expressions, tested against real persona accounts during build. We document every role and the test data it was verified against. Auditable from day one.

    #04Will you sign our DPA / vendor questionnaire?

    Yes. We sign your DPA before any data is shared, and questionnaires up to roughly 50 questions are included. Larger ones are scoped as a paid pre-engagement audit.

    #05Who owns the .pbip / .qvf files?

    You do. Full IP transfer on payment. We retain rights to reuse generic patterns and our internal tooling. Anything that's your own logic, branding, or business is yours, no carve-outs.

BI Consulting

Send your scope. We'll send a fixed price.

Five-day turnaround. Discovery call this week.

Let's talk

Ready to ship something real?

A 30-minute discovery call to scope your project. We'll tell you honestly whether we're the right fit, and if we are, we'll have a proposal within a week.

  • Reply within 1 business day
  • Fixed-price or weekly retainer
  • Ship in weeks, not quarters
Available
Q2 2026
Based in
Melbourne, AU
Response
< 1 business day
Book a free consultation