Competency and certificate programme
Data analysts clean raw data, transform it and turn it into meaningful insight that supports business decisions. The programme develops reporting, database management and analytical problem-solving together.
Participants practise analysis and reporting with Excel, Access, SQL and Python across real data scenarios.
- Duration
- 45 hours
- Format
- Live online
- Attendance
- 70%
01
What the programme covers
- Deciding which platform to prepare a given report with
- Working on large data sets with Microsoft Access and SQL
- Developing solutions to database performance problems
- Producing result reports with SQL queries
- Automating repeated business processes with VBA
- Generating more than one analytical approach to a problem
02
Course content
01 · Foundations of data analytics
- Introduction to data analytics
- The data analyst's career path
- Entering the profession and core concepts
02 · Excel and statistical analysis
- Excel basics and formulas
- Analysis functions
- Data visualisation and interpretation
03 · Databases and SQL
- Types of database
- SQL fundamentals
- JOIN operations
- Working with different data types
- Query optimisation
- Section project on a real data set
04 · Data analysis with Python
- Pandas and NumPy
- Matplotlib and Seaborn
- Data cleaning
- Model selection and machine learning
- Time series
- Big data and distributed computing
- Applied block project
03
Participation and assessment
- The programme is open to everyone.
- Attendance at the full programme is required.
- Competency is assessed through an exam and workshop sessions.
- Recordings are available for those who cannot join a live class.
