About Me
I'm Yijia Yuan, a Business Analyst with a passion for transforming data into strategic insights. With experience spanning hospitality, international development, and consulting, I help organizations make informed decisions through rigorous analysis and clear communication.
How Can I Help You?
I offer a range of analytical and strategic services to support data-driven decision-making
Data Analysis & Visualization
Transform complex datasets into actionable insights using Python, Tableau, and Power BI
Strategic Planning
Develop data-driven strategies aligned with business objectives and market opportunities
Performance Optimization
Identify operational inefficiencies and recommend process improvements backed by data
Database Management
Design and optimize SQL databases for efficient data storage and retrieval
Business Intelligence
Build comprehensive BI dashboards and reporting systems for stakeholder decision-making
AI & Innovation
Leverage AI and machine learning to unlock new business opportunities and efficiencies
Education
Master of Commerce (Business Analytics)
University of Sydney
Australia
- •Specialized in predictive analytics, machine learning, and data visualization
- •Coursework: Statistical Modeling, Business Intelligence, Data Mining, Optimization
- •Capstone project: Predictive demand forecasting for hospitality industry
MSc International Business
Queen Mary University of London
UK
- •Focus on global business strategy and financial analysis
- •Coursework: Corporate Finance, International Marketing, Strategic Management
- •Dissertation: Valuation analysis of Swatch Group using DCF and comparable company methods
BSc Accounting and Finance
Swansea University
UK
- •Strong foundation in financial accounting, management accounting, and corporate finance
- •Awarded Management Project Certificate for outstanding research work
- •Coursework: Financial Reporting, Investment Analysis, Risk Management
Technical Skills
Analysis
- Python
- R
- SQL
- Excel
Visualization
- Tableau
- Power BI
- Matplotlib
- Seaborn
Business
- Strategy
- Forecasting
- KPI Design
Tools
- Git
- Jupyter
- VS Code
- JIRA
Certifications
Agentic AI
DeepLearning.AI
December 2025
School Healing Project
UNICEF
2024
Let's Work Together
I'm currently seeking Business Analyst opportunities in Sydney. If you're looking for someone who combines analytical rigor with strategic thinking, let's connect.