Course Overview
Interns collect, clean, store, query and visualise the evidence that proves their concept is wanted and viable. Tools: Google Forms, Google Sheets/Excel, SQLite with DB Browser (or PostgreSQL), MongoDB, Python and pandas in Colab, Looker Studio or Power BI. The course runs for 4 weeks (12 sessions), with the last session used to showcase and evaluate your deliverable.
Course Curriculum & Modules
Course Deliverable
Validation Data Pack and Dashboard: survey instrument and cleaned dataset (30 or more responses), a relational database with at least 3 linked tables and ERD, 5 SQL queries answering validation questions, and a dashboard with a one-page insight summary and a recommendation (proceed, pivot or stop).
Data Engineering Department Pathway
Data Engineering focuses on relational SQL/NoSQL databases, automated ETL data pipelines, big data streaming (Spark/Kafka), cloud data warehouses, and enterprise data governance frameworks.
Computer & Hardware Requirements
Key Learning Outcomes & Benefits
- ✓Design a survey and collect at least 30 responses.
- ✓Clean data with spreadsheets and Python (pandas) and summarise key findings.
- ✓Design a relational database with an ERD and write SQL queries and MongoDB queries.
- ✓Build a dashboard and write an insight summary with a proceed, pivot or stop recommendation.
