Linero TechFOR EMPLOYERS

Data Analyst

The programme prepares future data analysts to turn business questions into clear insights that support informed decisions. Through practical projects, students learn to collect, analyse and present data using Python, SQL and Power BI.

Education overview

Companies need reliable answers from data held in spreadsheets, databases and external systems. This programme develops the practical ability to prepare that data, investigate a business question and explain the result to colleagues who need to act on it.

Relevant roles

Junior data analyst, reporting analyst and roles supporting data preparation, analysis and business reporting.

Learning outcomes

  • Translate a business question into an analysis plan, relevant measures and required data sources.
  • Write readable Python code and organise an analysis into reusable functions and notebooks.
  • Retrieve and combine data from CSV files, SQL databases and APIs.
  • Use Pandas to inspect, clean, filter, join and aggregate datasets, checking for missing values and inconsistencies.
  • Create clear charts with Pandas and Matplotlib and explain findings, assumptions and limitations.
  • Build interactive Power BI reports using Power Query, a clear data model and DAX measures.
  • Deliver a reproducible analysis using Jupyter, Git and GitHub, and collaborate on improvements.

Core technologies

Python · Pandas · SQL · Matplotlib · Power BI · Jupyter · Git/GitHub

Expected level of independence

Graduates should be able to complete a bounded analysis task within a team: clarify the question, prepare data, investigate patterns and present evidence with review. They should recognise unreliable inputs and seek guidance when the data cannot support a conclusion.

Curriculum and structure

Programming fundamentals with Python

Main content

Build a foundation in programming and logical problem-solving. Work with variables, data types, conditions, loops, functions and basic object-oriented concepts. Practise breaking a problem into small, testable steps.

Learning outcomes

  • Write, run and debug readable Python programs.
  • Use control flow, functions and suitable data structures to solve a defined task.
  • Explain how basic classes and objects organise related data and behaviour.
Working with data in Python

Main content

Move from individual programming exercises to structured datasets. Load common data formats, inspect records and types, identify quality problems and organise preparation into repeatable steps.

Learning outcomes

  • Load and inspect a dataset and describe its structure and types.
  • Detect missing values, inconsistent formats and duplicate records.
  • Separate raw inputs, preparation steps and outputs so the analysis can be rerun.
Data analysis with Pandas

Main content

Use Pandas DataFrames to explore and transform data. Practise filtering, sorting, selecting columns, handling missing values, merging datasets and grouping records into meaningful summaries.

Learning outcomes

  • Filter and transform data to answer a specified analytical question.
  • Combine related datasets and verify that joins do not lose or multiply records unexpectedly.
  • Calculate grouped counts, totals and averages and check how the result was produced.
  • Build a readable analysis workflow that can be maintained and reviewed.
Data visualisation and communication

Main content

Create visual explanations with Pandas and Matplotlib. Connect each chart to a question, choose an appropriate representation and improve readability through labels, units, titles and layout. Combine charts with concise written interpretation.

Learning outcomes

  • Create suitable line, bar, distribution or relationship charts from prepared data.
  • Make charts understandable with clear labels, scales, units and titles.
  • Explain observed patterns and distinguish evidence from assumptions.
  • Present findings and limitations to a non-technical audience.
Databases, files and APIs

Main content

Retrieve data from CSV files, relational databases and external APIs. Use SQL to select, filter, join and summarise records, then bring the results into a Python analysis. Document source assumptions and verify that the requested data was retrieved.

Learning outcomes

  • Write SQL queries that retrieve and combine the records needed for an analysis.
  • Import CSV data and convert API responses into usable tabular data.
  • Combine sources while checking identifiers, formats and completeness.
  • Document where the data came from and how it was retrieved.
Power BI and business reporting

Main content

Use Power BI to turn prepared data into interactive business reports. Work with Power Query, relationships between tables, DAX measures and visualisations that help colleagues explore a business question.

Learning outcomes

  • Import and transform data using Power Query.
  • Build a data model with appropriate relationships and DAX measures.
  • Create interactive reports with relevant visualisations and filters.
  • Validate report figures against source data and explain the results to stakeholders.
Project-based data analytics

Main content

Apply the analytical workflow to real datasets from different domains: define a question, prepare the evidence, analyse it and communicate the result. Projects run throughout the education and increase in complexity as skills develop.

Learning outcomes

  • Plan an analysis around a business question and explicit success criteria.
  • Complete an end-to-end workflow with documented data preparation and quality checks.
  • Revise an analysis after feedback and explain the effect of the changes.
Jupyter, Git and collaborative workflows

Main content

Use Jupyter for exploration and reporting, Git for version control and GitHub for sharing and reviewing project work. These practices are introduced early and used across assignments and projects, rather than being left until the end.

Learning outcomes

  • Organise notebooks so code, explanations and results can be followed by another analyst.
  • Track changes with Git and share a project through GitHub.
  • Document dependencies, inputs and execution steps for a reproducible handover.
  • Collaborate on changes and respond constructively to review feedback.
Workplace-based learning (LIA)

Main content

Apply the analytical workflow in a supervised workplace: prepare real datasets, contribute to analysis or reporting and collaborate with analysts, developers and business stakeholders. Tasks are chosen to match the learning goals and the host organisation’s needs.

Learning outcomes

  • Complete an agreed data-preparation, analysis or reporting task under supervision.
  • Use the team’s working methods and communicate progress and questions.
  • Document the work, incorporate feedback and explain the practical result.

Entry requirements and target audience

Beginners and career changers who want to work with data, enjoy logical problem-solving and want to support business decisions. The progression starts with programming foundations and builds towards junior analytical work.

Entry requirements

  • English proficiency sufficient to follow teaching, read technical documentation and communicate analytical findings.
  • High-school-level mathematics as a foundation for calculations, measures and quantitative reasoning.
  • No previous programming or data-analysis experience is required; Python is introduced from the beginning.

Expected starting knowledge

Students should be comfortable working with files and using a computer. Familiarity with percentages, averages, simple formulas and charts is useful.

How students apply their knowledge

Teaching and study format

Instructor-led sessions introduce each topic, followed by guided exercises, coding challenges and increasingly independent projects. Students work with real datasets, receive actionable feedback and practise explaining their work to others. Jupyter, Git and GitHub are used across the education.

How learning is demonstrated

  • Readable Python code and a Jupyter analysis that can be rerun from documented inputs.
  • SQL queries and API or file imports that retrieve the required data correctly.
  • Pandas transformations with checks for missing data, duplicates, joins and aggregation errors.
  • Matplotlib visualisations with appropriate chart types, labels, units and clear written interpretation.
  • A Power BI report with documented data preparation, checked relationships and measures, and useful report interactions.
  • A version-controlled project and a concise presentation linking findings to the original question.

Would you like to endorse this education?

Do these skills match what your company needs? Your perspective helps us make the education relevant to real work.

You are not required to

  • Teach or prepare course materials.
  • Hire students.
  • Host interns.
  • Attend recurring meetings.

How you can support us

  • Share your current and anticipated skills needs.
  • Give brief feedback on the curriculum and learning outcomes.
  • Endorse the education’s relevance based on your own assessment.

Providing your initial feedback takes no more than 1 hour.

Give feedback and endorse this education