Database Administrator

Course 01: Introduction to Data Analysis

Course 02: Data Center Training Essentials: General Introduction

Course 03: Data Analytics with Tableau

Course 04: Basic Google Data Studio

Course 05: Complete Google Analytics Course

Course 06: Python for Data Analysis

Course 07: Data Analysis in Excel Level 3 Course

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

Course 09: GDPR Data Protection Level 5

Course 10: Level 3 Cyber Security

Course 11: Encryption

PDF Certificate: Free (Previously it was £10 * 11 = £110)

Hard Copy Certificate: Free (For The Title Course)

Module 01: Introduction

Module 02: Agenda and Principles of Process Management

Module 03: The Voice of the Process

Module 04: Working as One Team for Improvement

Module 05: Exercise: The Voice of the Customer

Module 06: Tools for Data Analysis

Module 07: The Pareto Chart

Module 08: The Histogram

Module 09: The Run Chart

Module 10: Exercise: Presenting Performance Data

Module 11: Understanding Variation

Module 12: The Control Chart

Module 13: Control Chart Example

Module 14: Control Chart Special Cases

Module 15: Interpreting the Control Chart

Module 16: Control Chart Exercise

Module 17: Strategies to Deal with Variation

Module 18: Using Data to Drive Improvement

Module 19: A Structure for Performance Measurement

Module 20: Data Analysis Exercise

Module 21: Course Project

Module 22: Test your Understanding

Module 01: Data Center Introduction

Module 02: Data Center Reliability

Module 03: Data Center Equipment

Module 04: Data Center White Space

Module 05: Data Center Support Spaces

Module 06: Data Center Security, Safety, Networks and IT

Module 01: Introduction to the Course

Module 02: Project 1: Discount Mart (Sales and Profit Analytics)

Module 03: Project 2: Green Destinations (HR Analytics)

Module 04: Project 3: Superstore (Sales Agent Tracker)

Module 05: Northwind Trade (Shipping Analytics)

Module 06: Project 5: Tesla (Stock Price Analytics)

Module 07: Bonus: Introduction to Database Concepts

Module 08: Tableau Stories

Module 01: Introduction to GDS

Module 02: Data Visualization

Module 03: Geo-visualization

Module 04: A Socio-Economic Case Study

Module 01: Overview

Module 02: Navigation and Admin

Module 03: Creating a New Google Analytics Account

Module 04: Website Account Creation

Module 05: Connecting To WordPress Website

Module 06: Connecting To HTML Site

Module 07: Connect Custom Page and Site Builders

Module 08: Setting Up Annotations

Module 09: Setting Up Intelligence Events

Module 10: Set Up Custom Segments

Module 11: Export Data for Analysis

Module 12: Set Up Custom Reports

Module 13: Set Up Google Integrations

Module 14: Google Analytics Templates

Module 15: Real Time Reporting

Module 16: Setting Up Goals

Module 17: Third Party Integrations

Module 18: Audience Menu Overview

Module 19: Interests and Geography

Module 20: Conclusion

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 matplotlib

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 & Visualization

Python for Machine Learning (ML) - scikit-learn - Linear Regression Model

Python for Machine Learning - scikit-learn - Logistic Regression Model

Python for Machine Learning - scikit-learn - K Nearest Neighbors

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)

Modifying a Worksheet

Working with Lists

Analyzing Data

Visualizing Data with Charts

Using PivotTables and PivotCharts

Working with Multiple Worksheets and Workbooks

Using Lookup Functions and Formula Auditing

Automating Workbook Functionality

Creating Sparklines and Mapping Data

Forecasting Data

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 and Pivot Table

Advanced VBA Prepaid Expenses Amortisation Model

BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way

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

Thankyou

Module 01: GDPR Basics

Module 02: GDPR Explained

Module 03: Lawful Basis for Preparation

Module 04: Rights and Breaches

Module 05: Responsibilities and Obligations

FUNDAMENTALS OF NETWORKING

GETTING STARTED WITH CYBER SECURITY

LET'S BEGIN - THE FUNDAMENTALS OF CYBER SECURITY

DIVING DEEP INTO CYBER SECURITY

TYPES OF ACTORS, ATTACKS, MALWARE AND RESOURCES

FIREWALLS AND ANTIVIRUS

KEY SECURITY CONCEPTS

Section 01: Introduction

Section 02: Basics of Common Encryption

Section 03: Technical Aspects of Encryption

Section 04: AES Basic Tech Demo

Section 05: File and System Encryption

Section 06: Conclusion