Welcome to Avinash's Website

Turning data into
decisions that matter

Data Analytics & Insights Manager, Retail Strategy
Ex-Fabric Super User · Fabric Workloads Proficiency · Agentic Development · Azure Services Implementation

View my work Get in touch

Revenue YTD vs Prior Year Power BI

Prior Year Current Year

+18.4%

YoY Growth

$2.4M

Total Revenue

94.2%

Target Hit

About me

Data analyst who
speaks business

I'm Avinash Dudani — a Data Analyst at Canadian Forces Morale and Welfare Services with a passion for turning messy datasets into clear, actionable intelligence.

I'm also a Microsoft Fabric Community Superuser, YouTube content creator at @Empower_Data, and a freelance BI consultant on Fiverr and TopMate.

My focus areas span end-to-end BI delivery — from data modelling in Power BI and DAX optimisation, to cloud pipelines on Azure and Python-driven analytics.

GitHub YouTube TopMate

Experience

Data Analyst

CFMWS – CANEX · Ottawa, Canada

Jul 2022 – Present

Architected Microsoft Fabric & Azure analytical workloads across a multi-store retail portfolio, enabling executive-level strategic recommendations.
Led marketing analytics initiatives that improved YoY incremental sales by 7%.

Procurement Consultant

KLB Group · Montreal, Canada

Sep 2021 – Jun 2022

Built Power BI dashboards tracking ~$3B in Assets Under Management using SQL, supporting high-stakes investment decisions.
Automated ~10 hrs/month of manual workflows using Python, freeing analyst capacity for higher-value analysis.

Inventory Control Coordinator

Good Food Market · Montreal, Canada

Dec 2020 – Aug 2021

Designed Power BI solutions improving on-hand inventory accuracy by 5% and reducing overhead by 3% through QoQ turnover analysis.
Translated supply chain data into actionable process improvements with measurable cross-functional impact.

Tech Stack

DAX

Power Query (M)

Microsoft Fabric

Azure

Python

Relational Database Management

Portfolio

Selected projects

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

📊

Power BI DAX Sales

Adventure Works Sales Analysis

End-to-end Power BI dashboard analysing Adventure Works sales data. Features dynamic YTD/fiscal metrics, Calculation Groups, Field Parameters, and drill-through pages to surface performance insights at product and territory level.

📐

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.

🔬

Python scikit-learn Statistics

Multiple Linear Regression

Implemented a multiple linear regression model from scratch using Python and scikit-learn to predict outcomes from multi-variable datasets. Covers feature engineering, assumption testing (VIF, residuals), and model evaluation metrics.

⚡

Power Automate Excel RPA

Excel Automation with PAD

Built a desktop automation flow with Power Automate Desktop to eliminate repetitive Excel data-entry tasks. Reduced manual processing time significantly by leveraging UI flows, loops, and conditional logic — no code required.