Data Analyst Diploma

Diploma Outline
Today’s world is driven by data. More than ever, companies are striving to understand how to improve their operations by dissecting the data they collect to understand clients’ needs and industry trends.

As a Data Analyst, you could find yourself working within a wide range of organisations across a variety of sectors, but the common denominator is the need to glean insights from data. Data comes in a variety of forms and is stored in a variety of database management systems. And your first and foremost goal is to gather insights from the data. Often, you will be dealing with unstructured data stored in different types of data management systems. To achieve meaningful analytical results, several skills must be mastered.

In this diploma, you’ll gain practical analytical skills as you work through the courses. Not only will you find out more about how data is created and managed, but you’ll also look at the fundamentals of research methods and statistical analysis. You will also develop a strong foundation with the most powerful programming languages available for data manipulation, cleaning, and analysis.

Data Analyst Diploma

Your details

Training Centre

Hidden
Hidden
Hidden
Hidden
Hidden
Hidden

Course Info

Duration 200 hours flexi study or 8 weeks full-time (Full-time based on approx 20-30 hours a week)
Training Type Diploma
Study Type In centre, Online

Awards & Qualifications

Awarded 200 CPD points upon successful completion

Is this course right for me?

This training is ideal for those who are new to data analysis and also appropriate for those who may already be working in tech or data science and would like to specialise and become proficient with the tools and techniques of data analysis.

Awarded 200 CPD points upon successful completion
Duration 200 hours flexi study or 8 weeks full-time (Full-time based on approx 20-30 hours a week)

Course Content

Core Courses

Excel Expert
Our Excel Expert course will provide you with the knowledge and skills to use this popular spreadsheet programme to an advanced level. You’ll learn how to work efficiently with PivotTables and PivotCharts, automate processes with macros, create complex
visualisations of your data, establish connections between various data sources, and use Excel’s data analysis tools to make data-driven decisions.

Data Research & Statistical Techniques
This course has been designed to give learners a strong foundation in data research and statistics. Data analysts are challenged to extract meaningful insights from their data. To learn various strategies toward that goal, this course exposes you to the fundamental
research methodology and modelling concepts that are key to performing robust data analytics, visualisation, and data interpretation. This course also emphasises essential statistical methods.

Python for Data Analysts
Python is an all-purpose programming language. It’s used for a variety of applications, from web / software development, game development, to AI, machine learning, and data analysis. This course aims to tackle every corner of Python the Data Analyst must master.

SQL for Data Analysts
Structured Query Language (SQL) is a programming language used to extract and organise data stored in a relational database. This course aims to help you develop the skills to first identify the critical characteristics of database design and management and then be able to work with relational databases.

R Programming and Statistical Analysis
R is widely recognised as a powerful programming language and environment for data manipulation, statistical computing, and graphical display. It provides a variety of tools and techniques and is easily extensible. R is open-source and a vital tool for
data wrangling and analysis. R includes a robust data handling and storage facility, as well as an extensive, integrated collection of tools for data analysis and graphical display. In this course, you’ll learn the fundamentals of the R programming language using
Jupyter Notebooks and RStudio, while running descriptive and inferential analysis with different types of data structure.

Data Visualisation with Tableau
This course covers best practice for visualising data. Using the right charts and graphics helps tell the story that the data has revealed and identify patterns and trends within the data. In this course, you’ll explore essential types of analysis, visualisation, and graphic
tools useful for conveying meaning from your data.

Fundamentals of AI & Machine Learning
This course seeks to provide you with the essential concepts that will allow you to operate in a modern and sophisticated environment. The world of artificial intelligence (AI) includes many areas in computing, which makes it a complex field, combining computer science and robust datasets to enable problem-solving. AI leverages computers and machines to mimic the problem-solving and decision-making capabilities of the human brain.

Project Management for Data Analysts
This course aims to introduce you to the essential tools used in data-driven projects and collaborations. You’ll learn the concepts of Lean, Agile, and Scrum methodologies and their applications.

Course Overview

Aims and Objectives
With this diploma, you’ll acquire a solid foundation of knowledge and skill to become a junior Data Analyst. You’ll work with Python and R, two programming languages widely used in the field of data analysis. And you’ll develop valuable skills with SQL, used for querying databases, and Tableau, which is widely used for data visualisation.

Career Path
There are many options available in this field. You could become a data science professional, pursuing jobs such as data analyst or database developer; or you could go into an analytics-related role, such as business analyst or data-driven manager. The opportunities
are countless!

Pre-Requisites
Successful candidates will be proficient with Microsoft Excel and have a solid background in mathematics (e.g., algebra) and strong critical-thinking and problem-solving skills. Previous exposure to coding is a plus.

Event Series Excel Intermediate

Excel Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. What you will learn: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...

Event Series Time Management

Time Management

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This workshop is ideal for anyone who wishes to improve their self-managing techniques, achieve more in their working day and gain more balance in their lives. Spending 1-day learning how to manage your time – will save you hours! What you will learn: To take an objective look at how you spend your time at...

Adobe Photoshop

For individuals who are new to Photoshop or have only used Photoshop for limited tasks. During the course you will learn the fundamentals of the Adobe Photoshop Creative Cloud from our certified Adobe Instructor. Classes are small group sessions guaranteeing time for practical training and questions and feedback from our tutor. What you will learn:...

Event Series Influencing Skills

Influencing Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

The aim of this course is to learn how to develop and apply the skills of influential communication. What you will learn: To understand how we are influenced. How to tailor your communications for different people and situations. To communicate confidently and with purpose. How to put across complex ideas in simple, understandable ways. How...

Event Series Report Writing

Report Writing

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This 1-day workshop will help you choose the correct style and tone for a report and clearly define your purpose. It will revisit the key principles of grammar, punctuation and spelling and is aimed at anyone involved in writing on behalf of their employer, and those for whom reports are or will be integral to...

Event Series Excel Intermediate

Excel Intermediate

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. What you will learn: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...

Personal Development Workshops – Assertiveness

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Assertiveness This workshop is about helping you recognize your own type of behavior and how you come across to others. It will help you to identify situations in which you would like to be less aggressive or less passive and learn how to be assertive in these situations. The course will show you how to...

Event Series Power BI Intermediate

Power BI Intermediate

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight. What you will learn: Design a data model. Introduction to...

Event Series Excel Advanced

Excel Advanced

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. What you will learn: Macros – Editing and deleting macros, recording macros, customizing ribbon. Review Data...

Event Series Communication Skills

Communication Skills

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This practical workshop is ideal for those who need to build effective working relationships or depend on effective communication in critical situations. It will also benefit those who would like to develop their own skills and confidence in communication generally. What you will learn: Practical verbal and non-verbal communication The importance of rapport and how...

Microsoft Project Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who have never used Project. The course is designed to cover all aspects of Project at an Introduction level; to provide you with a good overall grasp of the application – it’s different areas, features and how these can be adapted within a working environment. What you will learn: Project Environment – Starting...

Event Series Meetings and Minutes

Meetings and Minutes

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

For anyone who organizes and takes minutes at meetings and those who would like to do this role to a professional standard. What you will learn: The difference between formal and informal meetings. How to set out an agenda. Tips and techniques for note taking. The role of the minute taker What minutes are and...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

2 events,

Microsoft Project Complete – 2-day course

Event Series

Project Management Principles

Event Series

1 event,

- Event Series

Better Business Writing

2 events,

- Event Series

Management Skills

0 events,

0 events,

0 events,

0 events,

3 events,

Adobe Photoshop

Event Series
- Event Series

Time Management

- Event Series

Excel Intermediate

2 events,

- Event Series

Influencing Skills

- Event Series

Report Writing

2 events,

- Event Series

Excel Intermediate

0 events,

0 events,

0 events,

1 event,

- Event Series

Power BI Intermediate

2 events,

- Event Series

Communication Skills

- Event Series

Excel Advanced

2 events,

- Event Series

Microsoft Project Introduction

- Event Series

Meetings and Minutes

2 events,

- Event Series

Time Management

- Event Series

PowerPoint Introduction

1 event,

- Event Series

Word Introduction

0 events,

0 events,

0 events,

2 events,

Executive PA – 2-day workshop

Event Series
- Event Series

Power BI Introduction

2 events,

1 event,

- Event Series

Telephone Techniques

0 events,

0 events,

0 events,

0 events,

4 events,

Train the Trainer – 3- day workshop

Event Series

Adobe Illustrator

Event Series

Train the Trainer – 3- day workshop

Event Series
- Event Series

Excel Introduction

1 event,

- Event Series

Excel Intermediate

0 events,

0 events,