Avinash Dudani

Welcome to Avinash's Website

Open to new opportunities — Senior / Manager, Data Analytics & BI

Turning data into
decisions that matter

I build teams that tell stories with data, turning retail strategy, forecasting and P&L questions into governed, self-serve Microsoft Fabric solutions that leaders actually act on.

Remote, or Hybrid. Open to roles in Canada or relocation to the rest of the world. Canadian citizen, currently based in Ottawa.

6x Microsoft Certified - DP-700, DP-600, PL-300, AZ-104, DP-900, AZ-900 - plus 2x Fabric Super User and CAPM

Projects & case studies

A mix of dashboards, analytics, and automation work — click any card to learn more.

⛓️
dbt DuckDB Star Schema

Retail Analytics Platform

A medallion pipeline over 1.07M retail transactions — bronze, silver and gold layers in dbt, a five-table star schema, and 50 data tests in CI. Every cleaning decision is quarantined and auditable rather than silently applied.

Sep 2026
🧭
Governance Operating Model SLA

The BI Operating Model

How to run an internal BI function — single-door intake, a weighted prioritisation scorecard that publishes what falls below the line, five delivery stages with exit criteria, tiered SLAs, revocable certification and adoption metrics that treat retirement as a feature.

Sep 2026
📦
React Inventory Agentic

Retail Inventory Management App

On/off-shelf inventory capacity splits, location capacity heatmaps, re-order triggers, and journal-entry overviews — with purchase-order tracking and agentic order-flow evaluation.

June 2026
🗂️
React BI Service Governance

BI Service Demo

A landing page for an internal BI service function — report inventory with per-report dashboard previews, ad-hoc demand intake, a five-stage delivery pipeline with roadmap Gantt, SLA refresh schedules, stakeholder feedback forms and quarterly governance recaps.

Sep 2026
📊
Power BI Forecasting Segmentation

Order & Customer Analysis

Forecasting, trend analysis, and customer-segmentation dashboards built in Power BI on the Adventure Works dataset — with YTD vs prior-year KPI comparisons, drill-down time series, and Pareto analysis to identify best sellers.

Feb 2022
📐
DAX Calculation Groups Power BI

Dynamic Fiscal & YTD Metrics

A deep-dive on building flexible time-intelligence using Calculation Groups and Field Parameters — enabling users to switch between fiscal calendar, YTD, rolling 12-month, and prior-year comparisons from a single slicer.

Technique write-up
🔬
Python scikit-learn Statistics

Multiple Linear Regression in Python

Supervised regression model built with pandas, scikit-learn, matplotlib and seaborn to predict profit from multiple features — covering exploratory analysis, model fitting, and evaluation.

Mar 2022
Power Automate SQL Server Excel

Excel Automation with SQL Server & PAD

Streamlined Excel reporting with Power Automate Desktop and SQL Server, applying defined business logic to query and write data — removing repetitive manual handling from the reporting cycle.

Jan 2022

Autonomous Analytics leader impacting businesses through fact and outcome based storytelling

I'm Avinash Dudani — a strategic Data Analytics Manager who turns retail strategy, forecasting and P&L questions into governed, self-serve analytics. I partner with executives to translate long-term vision into a prioritised roadmap, then lead the teams that deliver it.

I work across the Microsoft Fabric and Power BI stack, and increasingly build agentic decision-support solutions with Copilot Studio and the Power Platform — so insight triggers action instead of waiting to be noticed. 6× Microsoft Certified and a 2× Fabric Super User, I share what I learn at @Empower_Data.

Hiring for an analytics leader, or need a partner to make your data estate decision-ready? I take on consulting engagements and 1:1 advisory alongside my day role.

Start a conversation →
Experience
3
analysts managed
200+
business users served internationally
75+
Power BI dashboards & Fabric apps
87%
average user-satisfaction score
8
strategic projects owned annually
40+
ad hoc business requests a year
CFMWS – CANEX
Ottawa, Canada
Jul 2022 – Present
  1. Manager – Data Analytics & Insights Nov 2025 – Present
  2. Data Analyst Jul 2022 – Nov 2025
Procurement Consultant
KLB Group  ·  Montreal, Canada
Sep 2021 – Jun 2022
  • Tracked and analysed ~$3B in Assets Under Management to guide strategic purchasing decisions.
  • Built a procurement decision-support dashboard that cut procure-to-pay cycle times by 5%.
Early experience
Inventory Coordinator · GoodFood Market 2020 – 2021
Quality Assurance Intern · DENSO International 2016
Tech Stack
DAX
Power Query (M)
Microsoft Fabric
T-SQL & Dimensional Modelling
Power Platform & Copilot Studio
Python & PySpark
Core Competencies
Retail Strategy Forecasting P&L Management Change Management Data Governance Ingestion Orchestration Quality Assurance Dimensional Modelling Visualization
Education
🎓
M.Eng, Industrial Engineering
Concordia University · Montreal, Canada
🎓
B.Eng, Mechanical Engineering
Vellore Institute of Technology · India

Professional development

6× Microsoft Certified and a 2× Fabric Community Super User. Click any badge to verify it on the issuing platform.

View services provided

Fixed-scope engagements rather than open-ended hourly work — so you know what lands, and when. Every package is quoted per project.

📞 60 minutes

Advisory Call

  • A single problem talked through end to end
  • Model, DAX or architecture review on the call
  • Written summary of what to do next
Book a call →
🔍 About 1 week

Report Health Check

  • Audit of an existing model and report
  • Performance, DAX and star-schema review
  • Prioritised fix list with effort estimates
  • Walkthrough session with your team
Request a quote →
☁️ 4–6 weeks

Fabric Foundation

  • Lakehouse and medallion architecture
  • Data Factory pipelines and scheduled refresh
  • Certified semantic model built for reuse
  • One or two reports plus a governance baseline
Request a quote →

Let's work together

Have a project in mind? I'm open to freelance engagements, consulting calls, and collaboration.