Data Science
Combine programming, statistics and visualisation to turn raw data into insight and predictions.
Data Analysis training
Collect, clean and analyse data with spreadsheets and Python so you can answer business questions.
Course overview
Learn to turn raw data into clear answers. The course covers cleaning data, analysing it with spreadsheets and Python, and presenting findings that people can act on.
Requirements
- A computer
- Comfort with basic maths
- No prior data experience needed
What you will learn
- Clean and prepare messy data
- Analyse data using spreadsheets and Python
- Create clear charts
- Present findings to non-technical audiences
Practical projects
- A sales analysis report
- A dashboard built from a real dataset
Skills you will gain
- Excel
- Python with pandas
- Data cleaning
- Data visualisation
- Reporting
Career and application opportunities
- Data analyst
- Business or reporting analyst
- Analytical roles in many organisations
Curriculum
1Introduction to data analysis
- What data analysis is
- Types of data
- The analysis process
- Asking good questions
2Spreadsheets for analysis
- Formulas and functions
- Sorting, filtering and lookup
- Pivot tables
- Charts in Excel
3Cleaning and preparing data
- Finding errors and duplicates
- Handling missing values
- Standardising formats
- Combining datasets
4Python for analysis
- Python basics for data
- Working with pandas
- Grouping and summarising
- Plotting with matplotlib
5Communicating results
- Choosing the right chart
- Telling a story with data
- Building a report
- Capstone project
Related courses
Database Management
Learn to design, build, secure and maintain databases that applications depend on.
Machine Learning
Train and evaluate models that learn from data, using Python and standard machine learning libraries.