Data Analyst (Data Analytics) Diploma - CPD Certified

Acquire a big-picture understanding of the data analyst role

Fundamentals of data analysis (data analysis), including process management, tools for data analysis, various charts

Ability to conduct thorough research and turn raw data into presentable information

Perform many data operations in Python's famous "pandas" library, including grouping, pivoting, joining and more!

Learn about NLP, Machine Learning (ML), data visualisation using Matplotlib, Seaborn and much more

Knowledge of all the essential SQL commands and become proficient in SQL tools like GROUP BY, JOINS, and Subqueries

Become competent in using sorting and filtering commands in SQL

Learn general cloud computing concepts and gain a solid understanding of the fundamental systems on which the cloud is based

Learn how to use the R programming language for data science, machine learning, and data visualisation

Learn data analytics with Tableau, business intelligence and data mining masterclass, basic Google Data studio

Course 01: Introduction to Data Analysis

Course 02: Python for Data Analysis

Course 03: SQL Programming Masterclass

Course 04: Data Science & Machine Learning with R

Course 05: Data Analytics with Tableau

Course 06: Basic Google Data Studio

Course 07: Business Intelligence and Data Mining Masterclass

Course 08: Business Analysis Level 3

Course 09: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

Course 10: Cloud Computing / CompTIA Cloud+ (CV0-002)

Course 11: GDPR Data Protection Level 5

Course 12: ChatGPT Crash Course

Introduction

Agenda and Principles of Process Management

The Voice of the Process

Working as One Team for Improvement

Exercise: The Voice of the Customer

Tools for Data Analysis

The Pareto Chart

The Histogram

The Run Chart

Exercise: Presenting Performance Data

Understanding Variation

The Control Chart

Control Chart Example

Control Chart Special Cases

Interpreting the Control Chart

Control Chart Exercise

Strategies to Deal with Variation

Using Data to Drive Improvement

A Structure for Performance Measurement

Exercise

Course Project

Test your Understanding

Welcome, Course Introduction & overview, and

Environment set-up

Python Essentials

Python for Data Analysis using NumPy

Python for Data Analysis using Pandas

Python for Data Visualization using mat plotlib

Python for Data Visualization using Seaborn

Python for Data Visualization using pandas

Python for interactive & geographical plotting using Plotly

and Cufflinks

Capstone Project - Python for Data Analysis &

Visualisation

Python for Machine Learning (ML) - sci-kit-learn - Linear

Regression Model

Python for Machine Learning - scikit-learn - Logistic

Regression Model

Python for Machine Learning - scikit-learn - K Nearest

Neighbours

Python for Machine Learning - scikit-learn - Decision Tree

and Random Forests

Python for Machine Learning - scikit-learn -Support Vector

Machines (SVMs)

Python for Machine Learning - scikit-learn - K Means

Clustering

Python for Machine Learning - scikit-learn - Principal

Component Analysis (PCA)

Recommender Systems with Python - (Additional Topic)

Python for Natural Language Processing (NLP) - NLTK -

(Additional Topic)

Introduction

Setting up Course Tools

Browsing & Filtering Data

Filter Data with AND, OR, NOT Operators

Math Operations

String Concatenation

Tidy Up Your Results: Sorting, Alias Names, Limit

Records

NULL, DISTINCT & CASE Statements

Functions in SQL: Multiple-Row Functions

Functions in SQL: Single-Row Functions

Nested Queries

Casting & Data Conversion

Combination Relationships

Joins in SQL

Data Manipulation (DML)

SQL Data Definition Language (DDL)

Data Science and Machine Learning Course Intro

Data Types and Structures in R

Data Types and Structures in R

Intermediate R

Data Manipulation in R

Data Visualisation in R

Creating Reports with R Markdown

Building WebApps with R Shiny

Introduction to Machine Learning

Starting A Career in Data Science

Introduction to the Course

Project 1: Discount Mart (Sales and Profit Analytics)

Project 2: Green Destinations (HR Analytics)

Project 3: Superstore (Sales Agent Tracker)

Northwind Trade (Shipping Analytics)

Project 5: Tesla (Stock Price Analytics)

Bonus: Introduction to Database Concepts

Tableau Stories

Introduction to GDS

Data Visualisation

Geo-visualisation

A Socio-Economic Case Study

What is Business Intelligence?

Starting Case in understanding BI needs in diff phases

of business

Decision-Making Process and Need for IT Systems

Problem Structure and Decision Support System

Introduction to BI Applications

Dashboard presentation systems

Different Types of Charts used in 131 Dashboards

Good Dashboard and BSC

Examples of Bad Dashboards

Process of KPI Development

Overview of Data Warehouse

More explanation of the data warehouse and steps in

processing

Data Warehouse Architecture -Tiers

Data Warehouse - components

Approach to developing data structure and Models of

database

Basics of Data Mining - Meaning

Basics of Data Mining - Stages of DM

Data Mining Technique - Classification

Data mining - Clustering

Data Mining - Association Rules

Data Mining Applications - Banking

Data Mining Applications - CRM

Data Mining Applications - other industries

Introduction to Business Analysis

Business Processes

Business Analysis Planning and Monitoring

Strategic Analysis and Product Scope

Solution Evaluation

Investigation Techniques

Ratio Analysis

Stakeholder Analysis & Management

Process Improvement with Gap Analysis

Documenting & Managing Requirements

Career Prospect as a Business Analyst in the UK

Introduction

Prepaid Expenses Models: Resources Download

Accounting for Prepaid Expenses

Excel Formulas Detailed: Introduction to three Excel

Models

Formula-Based Prepaid Expenses Model

Calculate Prepaid Expenses Amortisation from Exact

Start Date

Prepaid Expenses Summary with Power Query & Pivot

Table

Advanced VBA Prepaid Expenses Amortisation Model

BONUS: Dynamic Dashboard for Divisional Profit &

Loss statements: Easy Way

Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic

What You Need to Know

Introducing the Cloud

System Requirements for Cloud Deployments

Cloud Storage

Cloud Compute

Cloud Networking

Cloud Security

Migrating to the Cloud

Maintaining Cloud Solutions

Troubleshooting Cloud Solutions

GDPR Basics

GDPR Explained

Lawful Basis for Preparation

Rights and Breaches

Sign up for an OpenAI Account

What can ChatGPT do for you?

ChatGPT for Business

ChatGPT for Teaching

ChatGPT for Research

Limitations of ChatGPT

Additional Videos

Aspiring data analysts

Business analyst professionals who want to improve their skills

Anyone who desires to develop their data analysis skills

Data Analyst: £30,000 - £50,000

Senior Data Analyst: £50,000 - £70,000

Data Scientist: £70,000 - £100,000

Business Intelligence Manager: £60,000 - £80,000

Machine Learning Engineer: £60,000 - £90,000

Digital certificate - Included

PDF certificate - Free (Previously, it was £6*12 = £72)

Hard Copy certificate - Included

Hard Copy Certificate - Free (For The Title Course: Previously, it was £10)

Other Hard Copy certificates are available for £10 each