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.

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.

📦
Postgres FastAPI Forecasting

Retail Inventory Control Tower

A full-stack inventory platform over 24 months of simulated multi-site retail, run around one north star: GMROI and its drivers against data-derived targets. Promotion-aware forecasts back-tested against a seasonal baseline, statistical reorder points, a service-level trade-off simulator and a working-capital view, all served read-only from a Postgres star schema with price history and 11 data-quality gates. Monitored, WCAG 2.1 AA, $0 to run.

Nov 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 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.