I am a dedicated Power BI Analyst with 5+ years of experience delivering data-driven insights, dashboards, and scalable analytics solutions. I specialize in Power BI (DAX, Power Query) and building governed data models, ETL/ELT pipelines, and AI-driven analytics that empower executives to make informed decisions. I collaborate with cross-functional teams, translate complex data into clear narratives, and drive data governance and ethical AI standards. I enjoy turning technical details into actionable business outcomes and continuously optimizing data processes for quality, speed, and security.

MOHIT SHAH

I am a dedicated Power BI Analyst with 5+ years of experience delivering data-driven insights, dashboards, and scalable analytics solutions. I specialize in Power BI (DAX, Power Query) and building governed data models, ETL/ELT pipelines, and AI-driven analytics that empower executives to make informed decisions. I collaborate with cross-functional teams, translate complex data into clear narratives, and drive data governance and ethical AI standards. I enjoy turning technical details into actionable business outcomes and continuously optimizing data processes for quality, speed, and security.

Available to hire

I am a dedicated Power BI Analyst with 5+ years of experience delivering data-driven insights, dashboards, and scalable analytics solutions. I specialize in Power BI (DAX, Power Query) and building governed data models, ETL/ELT pipelines, and AI-driven analytics that empower executives to make informed decisions.

I collaborate with cross-functional teams, translate complex data into clear narratives, and drive data governance and ethical AI standards. I enjoy turning technical details into actionable business outcomes and continuously optimizing data processes for quality, speed, and security.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate

Language

English
Fluent

Work Experience

Data Consultant / BI Analyst at Mercor & Prepzee (Freelance)
January 1, 2025 - Present
Freelance data consultant delivering Power BI data visualization and modeling; implemented AI analytics workflows to automate validation and reporting; integrated Azure SQL DB, Synapse Analytics, Data Factory, Cosmos DB, Event Grid, Service Bus, and PostgreSQL into centralized pipelines; produced executive dashboards translating analytics into actionable insights for technical and non-technical stakeholders.
Data Analyst / Power BI Analyst at Electricity Canada
January 1, 2023 - December 31, 2024
Developed 25+ Power BI dashboards leveraging DAX and Power Query; built ETL pipelines in Microsoft Fabric and Azure Synapse Analytics to consolidate multi-system datasets into a governed enterprise data warehouse; optimized SQL queries and automated dataflows to improve data quality and reduce processing time; collaborated with 35+ stakeholders to gather requirements, resolve data quality issues, and enforce governance; created executive dashboards with storytelling to drive business decisions.
Business Analyst at Canada Foundation for Innovation
March 1, 2022 - January 31, 2023
Conducted user acceptance testing (UAT) and resolved 10+ discrepancies using JIRA; translated business requirements into clear technical specifications, functional requirements, and system workflows for financial and award management systems; collaborated with cross-functional teams to optimize reporting workflows, improving data accuracy, auditability, and operational efficiency.
Business Analyst (Part-time → Full time) at Delphi Technology
February 1, 2020 - March 31, 2022
Gathered and documented business requirements for software development, translating them into user stories, use cases, and prototypes; analyzed users’ data to monitor KPIs, operational trends, and service delivery; partnered with stakeholders to identify bottlenecks and implement process improvements to enhance workflow efficiency.
Volunteer Data Analyst at Glocal Foundation of Canada
August 1, 2025 - Present
Transformed operational and financial datasets using Power Query, improving data quality, consistency, and reporting readiness; developed interactive Power BI dashboards with optimized DAX measures and incremental refresh to enable stakeholders to monitor key metrics effectively.
Machine Learning Project – Fake News Detection at University of Ottawa
January 1, 2021 - May 1, 2021
Developed text classification models (TF-IDF, Logistic Regression, Naive Bayes, SVM) achieving 90%+ accuracy; performed data cleaning, feature engineering, and transformation using pandas; created visualizations of datasets and model performance with Matplotlib and Seaborn to support applied research findings.
Data Consultant / BI Analyst at Mercor / Prepzee (Freelance)
January 1, 2025 - Present
Developed data visualization and data modeling using Power BI (DAX, Power Query) to increase KPI visibility. Implemented artificial intelligence analytics workflows, automating validation and reporting processes and reducing manual effort. Integrated Azure SQL DB, Synapse Analytics, Data Factory, Cosmos DB, Event Grid, Service Bus, and PostgreSQL into centralized pipelines to maintain data integrity, quality, and security compliance. Produced executive dashboards and presentations that translated analytics into clear, actionable insights for technical and non-technical stakeholders.

Education

Master of Systems Science & Engineering at University of Ottawa
January 11, 2030 - June 1, 2021
Master of Systems Science & Engineering at University of Ottawa
January 11, 2030 - June 1, 2021

Qualifications

Microsoft Certified: Azure Data Engineer Associate (DP-203)
January 1, 2026 - December 25, 2025
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
January 1, 2026 - December 25, 2025
Microsoft Data Fundamentals (DP-900)
October 1, 2025 - December 25, 2025
Databricks Fundamentals
October 1, 2025 - December 25, 2025
Microsoft Certified: Azure Data Engineer Associate (DP-203)
January 1, 2026 - December 25, 2025
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
January 1, 2026 - December 25, 2025
Microsoft Data Fundamentals (DP-900)
October 1, 2025 - December 25, 2025
Databricks Fundamentals
October 1, 2025 - December 25, 2025

Industry Experience

Energy & Utilities, Professional Services, Software & Internet, Government, Education, Media & Entertainment