Hi, I'm Gagan Shergill

Business Intelligence Analyst | Data Engineer | Visualization Specialist

View My Work Get In Touch

About Me

I'm Gagan Shergill, a Business Intelligence Analyst with 3 years of experience in data modeling, dashboard development, and workflow automation. I build analytics solutions that improve operational efficiency and decision-making.

At Wonderbrands, I develop enterprise Power BI dashboards and semantic models, streamline reporting across IT, Supply Chain, and Quality, and deliver secure, role-based insights for leadership.

My focus areas include Power BI, DAX, SQL, Python, and scalable data pipelines that enable fast, reliable, and actionable analytics.

Gagan Shergill

Skills & Technologies

Power BI & DAX

Advanced DAX, semantic models, RLS, performance optimization

Data Modeling

SQL, Power Query M, SSAS, Microsoft Fabric

Python & PySpark

ETL, automation, analytics, notebooks

Cloud & Platforms

Azure Data Factory, Databricks, Synapse, Delta Lake

Automation

Power Automate, Power Apps, VBA

Visualization

Power BI, Tableau, Matplotlib, Seaborn

Data Storage

MS SQL Server, Azure Storage, Delta Live Table, S3

Certifications

DP-600, PL-300, Databricks Data Engineer Associate

Featured Projects

Geo-location Analysis

Exploratory Geo-location Analysis

Identified ideal Waterloo Region neighborhoods for students using Python, clustering, preprocessing, and visualization.

Python K-Means Jupyter
Real-Time Movie Analytics

Real-Time Movie Analytics Pipeline

Built a Lambda Architecture pipeline with Spark, Kafka, Hive, and Druid for real-time insights.

Spark Kafka Airflow
Supply Chain Visibility

Shelf-Life Visibility BI

Improved compliance from 62% to 96% by transitioning Excel capture to BI reporting.

Power BI DAX Power Automate

Get In Touch

Open to BI and data engineering roles. If you'd like to collaborate or discuss opportunities, feel free to reach out.

Location

Toronto, ON, Canada

Status

Available for opportunities