SIWES Physical
Data Analysis
Overview
Master Excel, SQL, Python, and Power BI to clean, analyse, and visualise data. Learn to use AI tools to supercharge your analysis workflow. Ideal for Statistics, Business, and CS students.
Duration
3 months
Format
SIWES Physical
What you'll learn
- Write complex SQL queries — joins, window functions, CTEs, and subqueries
- Analyse and transform datasets with Python Pandas — groupby, merge, and pivot operations
- Use AI tools (ChatGPT, Claude) to automate formula writing, SQL debugging, and insight generation
- Master Excel for business reporting — pivot tables, VLOOKUP, INDEX/MATCH, and Power Query
- Build interactive Power BI dashboards with DAX measures and drill-through functionality
- Apply A/B testing and hypothesis testing to real business problems
- Deliver a full data analysis project with a stakeholder-ready presentation