Xinyuan (Skyla) Zhao
Data Analytics · BI · Applied AI
Toronto, Canada
I design Power BI reporting, SQL data workflows, and practical automation that help teams understand performance, resolve data issues, and move faster.
Selected impact
~70% fewer manual status checks
20+ hrs saved monthly
~200K accounts covered
Scroll to follow the story
02 / Selected projects
Two focused examples of how I approach BI systems and applied AI.
Operations & Billing Analytics
A fictional utility case study using synthetic data to demonstrate SQL transformation, dimensional modeling, DAX, and Power BI-ready marts.
Power BI · SQL · DAX · Python
Interview Prep Coach
A reusable bilingual workflow for role analysis, evidence mapping, STAR stories, mock interviews, and structured debriefs.
Agent design · Human review · Bilingual UX
No fabricated experience: missing evidence is identified and clarified.
SmartCine
Designed relational data structures and analytical queries for reservations and cinema operations, with my contribution focused on database design and data analysis.
MySQL · Python · Relational modeling · Data analysis
View repository ↗03 / Capabilities
Technical execution grounded in operational context.
Power BI · DAX · Tableau · Excel
SQL · Python · Databricks · ETL · Data modeling
Power Query · Power Automate · Validation · Reconciliation
Structured workflows · Tool use · Human review
How I work
01 / Experience
A progression from analytical foundations to ownership of operational reporting.
Wyse Meter Solutions Inc. · Toronto
Built operational Power BI reporting across 100+ billing cycles and approximately 200,000 accounts; integrated Cognos and Databricks data; defined DAX measures and exception reporting; automated validation and document workflows.
Power BI · SQL · DAX · Databricks · Power Automate
Wyse Meter Solutions Inc. · Toronto
Analyzed meter and consumption data across 20+ billing cycles, reconciled operational records, and reduced manual meter-reading validation effort by 30%.
SQL · Excel · Power Query · Python
Unity Health Toronto · Toronto
Prepared, cleaned, and preprocessed clinical research data for analysis and reporting.
Data cleaning · Preprocessing · Research data
Northeastern University · Boston
Supported students with SQL, database design, query optimization, triggers, and stored procedures.
SQL · Database design · Query optimization
Global AI · New York
Built a Python scraper and structured stock-market datasets; developed and compared forecasting approaches using SQL, Pandas, ARIMA, SVM, and Holt-Winters.
Python · SQL · Pandas · ETL · Time-series forecasting
Majorel China · Shanghai
Integrated sales and conversion data with SQL and Excel, then built Tableau reporting for pricing, promotions, sales trends, and customer conversion.
SQL · Excel · Tableau
04 / About
I am a Toronto-based data analyst working at the intersection of operational reporting, data quality, automation, and applied AI.
My strength is connecting detailed technical work to the decision someone needs to make: defining the metric, tracing the source, handling exceptions, and communicating the result clearly.
05 / Contact
Interested in data analytics, business intelligence, analytics engineering, or applied AI opportunities in Toronto and across Canada.