Data Analysis

Module focus

Explore how analysts frame questions and use evidence to support decisions.

Weekly topics

• Analyst responsibilities
• Business questions
• Analysis workflow
• Data ethics

Module focus

Recognise common data structures and assess source reliability.

Weekly topics

• Quantitative and qualitative data
• Structured and unstructured data
• Files and databases
• Data quality checks

Module focus

Prepare spreadsheet data for dependable analysis.

Weekly topics

• Missing values
• Duplicates
• Text and date cleanup
• Validation rules

Module focus

Use spreadsheet functions and summaries to answer practical questions.

Weekly topics

• Lookup functions
• Conditional formulas
• Pivot tables
• Charts and formatting

Module focus

Retrieve selected records from relational tables using core SQL syntax.

Weekly topics

• Tables and columns
• SELECT and WHERE
• Sorting and limiting
• Basic aggregate functions

Module focus

Combine tables and summarise data for more involved business questions.

Weekly topics

• JOIN operations
• GROUP BY and HAVING
• Subqueries and CTEs
• Window function basics

Module focus

Use Python libraries to inspect and transform datasets.

Weekly topics

• Python essentials
• Pandas DataFrames
• Filtering and grouping
• Missing data handling

Module focus

Investigate patterns and check assumptions before reporting findings.

Weekly topics

• Descriptive statistics
• Distributions and outliers
• Correlation cautions
• Exploratory questions

Module focus

Choose visual forms that communicate comparisons and trends accurately.

Weekly topics

• Chart selection
• Labels and scales
• Trend and category views
• Visual integrity

Module focus

Build interactive reports from connected data sources.

Weekly topics

• Data import
• Model relationships
• Measures and KPIs
• Filters and dashboard layout

Module focus

Explain what the analysis means and what action it supports.

Weekly topics

• Insight statements
• Audience framing
• Recommendations
• Limitations and caveats

Module focus

Deliver an end-to-end analysis and present the result as a portfolio case study.

Weekly topics

• Business dataset project
• Dashboard and report
• Presentation practice
• CV and interview preparation