Cirolearn
← All internships
Data Analysis Internship — learning tools

Data Analysis Internship

Learn to clean, analyse, interpret and visualise data, then communicate useful business insights through reports and dashboards.

Curriculum

  1. 01Data Analysis Fundamentals
    • Types of data.
    • The data analysis lifecycle.
    • Business questions and analytical objectives.
    • Data quality and ethics.
  2. 02Spreadsheet Analysis
    • Formulas and functions.
    • Sorting and filtering.
    • Lookup functions.
    • Pivot tables.
    • Summary reporting.
  3. 03Data Cleaning
    • Missing values and duplicates.
    • Data validation.
    • Standardisation.
    • Cleaning workflows.
    • Documentation.
  4. 04Statistics for Analysts
    • Mean, median and mode.
    • Percentages and rates.
    • Variation and distributions.
    • Trends and outliers.
    • Responsible interpretation.
  5. 05SQL Fundamentals
    • Tables and relationships.
    • SELECT, WHERE and ORDER BY.
    • Aggregations and GROUP BY.
    • Joins.
    • Reporting queries.
  6. 06Data Visualisation
    • Chart selection.
    • Dashboard design.
    • Communicating patterns.
    • Avoiding misleading charts.
    • Presenting findings.
  7. 07Python for Data Analysis
    • Python fundamentals.
    • Tabular data.
    • Introduction to pandas.
    • Filtering and summarising data.
    • Reproducible analysis.
  8. 08Data Analysis Capstone
    • Analyse a dataset.
    • Build a dashboard.
    • Write findings and recommendations.
    • Produce an executive summary.
    • Present a final analytical project.