Avinash Dudani

Welcome to Avinash's Website

Open to consulting engagements & new opportunities

Turning data into
decisions that matter

Data Analytics & Insights Manager — 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.

200+
business users served internationally
75+
Power BI dashboards & Fabric apps
87%
average user satisfaction score
Microsoft Certified · 2× Fabric Super User
Revenue YTD vs Prior Year Sample
Prior Year Current Year
+18.4%
YoY Growth
$2.4M
Total Revenue
94.2%
Target Hit

*For Illustrative Purposes Only

Analytics leader who
speaks business

I'm Avinash Dudani — a strategic Data Analytics Manager who builds teams that tell stories with data. I deliver sustainable, scalable analytical solutions that enable data-driven decision-making, improve the P&L, and strengthen customer engagement.

I manage analytical portfolios end to end using agile frameworks — partnering with executives and stakeholders to translate long-term vision into a prioritised roadmap, then optimising the processes and projects that deliver it. My work spans retail strategy, forecasting, P&L management and change management, underpinned by data governance, ingestion, orchestration, quality assurance and dimensional modelling.

Technically, I work across the Microsoft Fabric and Power BI stack — DAX, Power Query (M), T-SQL, Python and PySpark, Data Factory — and increasingly build agentic, decision-support solutions with Copilot Studio, Power Automate and the wider Power Platform, so insight triggers action instead of waiting to be noticed.

5× 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
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

Selected projects

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

📊
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

Professional development

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

What I can do for you

📊

Power BI Development

Full-stack BI — data model design, DAX measures, interactive reports, and deployment to Power BI Service.

☁️

Microsoft Fabric & Azure

End-to-end Fabric solutions — ingestion, orchestration and dimensional modelling with Data Factory, lakehouses and PySpark.

🐍

Python Analytics

Data wrangling, statistical modelling, and visualisation with pandas, scikit-learn, and matplotlib.

⚙️

Agentic Automation

Decision-support apps and agentic workflows with Copilot Studio, Power Automate and SharePoint — turning insight into action.

Let's work together

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