Syllabus

Learning Outline

  • 1

    Welcome to Utiva!

    • Let's get you started

    • SQL Installation Kit

    • Power BI Installation Kit

    • Python Installation Kit

  • 2

    Introduction to Spreadsheet

    • Learning Outcomes

    • Learning Slides : Excel

    • Introduction

    • Introduction to Spreadsheets

    • Save Workbooks, Access recent workbooks _ Pin workbooks

    • Excel Templates

    • Tabs, Ribbons _ Groups

    • Cells, Rows, Columns _ Ranges

    • Inputting _ Formatting Data

    • Creating Basic Excel Formulas

    • Relative _ Absolute Cell References

  • 3

    Structure of an Excel Function

    • Learning Outcomes

    • Structure of an Excel Function

    • SUM() Function

    • MIN() _ MAX() Functions

    • AVERAGE() Function

    • COUNT() Function

    • Adjacent Cell Errors

    • Autosum

  • 4

    Apply simple Formats

    • Learning Outcomes

    • Applying Simple Formats

    • Conditional Formatting

    • Named Ranges and Tables

  • 5

    The IF Command

    • Learning Outcome

    • Datasets

    • The IF() Function

    • Nested-IF()

    • IFS() Function

    • COUNTIF() Function

    • SUMIF() Function

    • IF ERROR() Function

  • 6

    LookUp, Index and Match

    • Learning Outcomes

    • Datasets

    • VLOOKUP() Function

    • HLOOKUP() Function

    • Submit your Assignment

    • INDEX() Function

    • MATCH() Function

    • INDEX() _ MATCH() Functions

  • 7

    Live Coaching session

    • Live Lesson

  • 8

    Basic Excel Charts A

    • Learning Outcomes

    • Datasets

    • Basic Excel Charts

    • Pivot Tables

    • Grouping Pivot Tables

    • Calculated Fields in Pivot Tables

    • Filtering Pivot Table Data

    • PivotCharts

    • Filtering with Slicers

  • 9

    Basic Excel Charts (B)

    • Learning Outcomes

    • Datasets

    • Dashboard - 1

    • Dashboards - 2

    • PowerPivot

    • Activating the PowerPivot Add-in

    • Data Models with PowerPivot

    • Creating PivotTables from Data Models

  • 10

    What - IF Analysis

    • Learning Outcomes

    • Datasets

    • What If Analysis - Goal Seek Tool

    • What If Analysis - Solver Tool

    • What If Analysis - Data Tools

    • What If Analysis - Scenario Manager

  • 11

    Data Cleansing

    • Learning Outcomes

    • Datasets

    • Data Cleaning in Excel

    • Importing Data from External Sources - Web Example

  • 12

    Excel Capstone Project

    • Capstone Project

    • Submit your Project

    • Feedback Survey

  • 13

    LinkedIn Optimization Session [Mid-Term]

    • LinkedIn Optimisation 1

    • LinkedIn Optimisation 2

    • LinkedIn Optimisation 3

    • LinkedIn Optimisation 4

    • LinkedIn Optimisation 5

    • LinkedIn Optimisation 6

    • LinkedIn Optimisation 7

    • LinkedIn Optimisation 8

    • LinkedIn Optimisation 9

    • LinkedIn Optimisation 10

    • LinkedIn Optimisation 11

    • LinkedIn Optimisation 12

    • LinkedIn Optimisation 13

  • 14

    Introduction to PostgreSQL

    • Introduction to PostgreSQL

  • 15

    Introduction to Databases

    • Learning Outcomes

    • Introduction to databases I

    • Introduction to Databases II

    • Introduction to Databases [Presentation]

    • Learning Outcomes

    • Introduction to databases III

    • Introduction to Databases [Presentation II]

  • 16

    Introduction to SQL

    • Learning Outcomes

    • Datasets

    • PostgreSQL Installation

    • The PostgreSQL GUI I

    • The PostgreSQL GUI II

    • The PostgreSQL GUI III

    • Importing CSV Files to pgAdmin I

    • Importing CSV Files to pgAdmin II

    • Submit your Assignment

  • 17

    Querying, Sorting, Filtering and Grouping Data

    • Learning Outcomes

    • Simple SELECT statements I

    • Simple SELECT statement II

    • Simple SELECT statement III

    • Filtering Query Results with WHERE Clause I

    • Filtering Query Results with WHERE Clause II

    • Filtering Query Results with WHERE Clause III

    • Aggregate Functions

  • 18

    Subqueries

    • Learning Outcomes

    • Subqueries in the SELECT Clause

    • Subqueries in the FROM Clause

    • Subqueries in the WHERE Clause

    • Subqueries ANY _ ALL Operators

    • Submit your Assignment

  • 19

    SQL Joins

    • Learning Outcomes

    • Basics of Joins

    • Inner Joins

    • Left Joins

    • Right Joins

    • Full Joins

    • Union and Union All

    • Datasets

  • 20

    Data Cleaning

    • Learning Outcome

    • Datasets

    • SQL Data Cleaning (String and CONCAT() Function)

    • REPLACE() Function

    • UPPER() _ LOWER() Functions

    • LENGTH() Function

    • LTRIM(), RTRIM() and BTRIM() Functions

    • SUBSTRING(), LEFT() and RIGHT() Functions

  • 21

    Date Functions, Views and Case Statement in SQL

    • Learning Outcomes

    • Date Function I

    • Date Function II

    • PostgreSQL Views

    • CASE Statements

  • 22

    Ooops! Please Complete your Payment.

    • Complete Your Payment!

  • 23

    Wrap Up

    • Datasets

    • SQL Shell

    • Wrap up _ Capstone Project

    • SQL Feedback Survey

    • Submit your Project

  • 24

    Introduction to Power Bi

    • Learning Slide

    • Datasets

    • Learning Outcome

    • Welcome to PowerBI

    • Introduction to PowerBI

  • 25

    Data Preparation and Transformation

    • Learning Slide

    • Learning Outcome

    • Data Preparation and Transformation

  • 26

    Data Model and Dax

    • Learning Slides

    • Learning Outcomes

    • Data Model and Dax

    • Submit your Assignment

  • 27

    Data Visualization

    • Learning Slide

    • Learning Outcomes

    • Data Visualisation [Creating Dashboard]

    • Submit your Assignment

  • 28

    Build Interactive Dashboards for Storytelling

    • Learning Outcomes

    • Learning Slide

    • Creating Interactive Dashboards

    • Submit your Assignment

  • 29

    Power BI Capstone Project

    • Power BI Capstone Project

    • Submit your Project

    • Feedback Survey

  • 30

    Data Science with Python: Basic Operations

    • Data Science with Python: Data Set

    • Intro

    • What is Python

    • Overview of the Jupyter Notebook

    • Basic operations in Python - Print() Function

    • Basic operations in Python - Basic Arithmetic Function

    • Basic operations in Python - Variables

    • Basic operations in Python - Project 1

    • Project 1 Solution

  • 31

    Data Science with Python: Basic Data Types

    • Basic data types - Strings.

    • Basic data types - Numeric data types.

    • Data Structures - Lists

    • Data Structures - Tuples

    • Data Structures - Dictionaries

    • Data types and Structures - Project 2

    • Project 2 Solution

  • 32

    Data Science with Python: Control Flow in Python

    • Control flow in Python - Overview

    • Control flow in Python - Conditional Statements.

    • Control Flow in Python - For Loops

    • Control Flow in Python - While Loops.

    • Control Flow in Python - Project 3

    • Project 3 Solution

  • 33

    Data Science with Python: Functions and Modules in Python

    • Functions and Modules in Python - Functions.

    • Functions and Modules in Python - Lambda Functions.

    • Functions and Modules in Python - Modules

    • Functions and Modules in Python - Project 4

    • Project 4 Solution.

  • 34

    Data Science with Python: Numphy

    • Numpy - Introduction to Numpy.

    • Numpy - Creating Arrays in Numpy.

    • Numpy - Indexing & Slicing Arrays.

    • Numpy - Copy & View in Numpy.

    • Numpy - Shape and reshaping Arrays.

    • Numpy - Basic Operations in Numpy Arrays.

    • Numpy - Data Analytics Operations in Numpy

    • Numpy - Project 5

    • Numpy - Project 5 Solution.

  • 35

    Data Science with Python: Pandas

    • Pandas - Introduction to Pandas.

    • Pandas - Reading in Files in Pandas.

    • Pandas - Looking at data in our dataframe.

    • Pandas - Accessing, Filtering and Sorting Data in Pandas.

    • Pandas - Indexing, loc & iloc in Pandas.

    • Pandas - Groupby and aggregate functions in Pandas.

    • Pandas - Merge, Join, and Concatenate in Pandas.

    • Pandas - Data Cleaning in Pandas 1.

    • Pandas - Data Cleaning in Pandas 2.

    • Pandas - Data Visualization in Pandas

    • Pandas - Project 6

    • Pandas - Project 6 Solution.

  • 36

    Data Science with Python: Matplotlib

    • Matplotlib - Introduction to Matplotlib.

    • Matplotlib - Basic plots in Matplotlib.

    • Matplotlib - Project 7

    • Project 7 Solution.

  • 37

    Data Science with Python: ML and Regression

    • Machine Learning - Introduction to Machine Learning.

    • Machine Learning - Supervised & Unsupervised Learning.

    • Machine Learning - Machine Learning Techniques.

    • Machine Learning - Introduction to Scikit-Learn.

    • Regression with Scikit-Learn - Introduction to Regression Models

    • Regression with Scikit-Learn - Building your First Linear Regression 1

    • Regression with Scikit-Learn - Building your First Linear Regression Model 2.

    • Regression with Scikit-Learn - Building your First Linear Regression Model 3.

    • Regression with Scikit-Learn - Building your First Linear Regression Model 4.

    • Regression with Scikit-Learn - Project 8

    • Project Solution.mp4

  • 38

    Data Science with Python: Classification

    • Classification with Scikit-Learn - Introduction to Classification Models.

    • Classification with Scikit-Learn - Building your First Classification Model 1

    • Classification with Scikit-Learn - Building your First Classification Model 2

    • Classification with Scikit-Learn - Building your First Classification Model 3

    • Classification with Scikit-Learn - Building your First Classification Model 4

    • Classification with Scikit-Learn - Project 9

    • Project 9 Solution

  • 39

    Data Science with Python: Clustering

    • Clustering with Scikit-Learn - Introduction to Clustering Models.

    • Clustering with Scikit-Learn - Building your first Clustering Model 1

    • Clustering with Scikit-Learn - Building your first Clustering Model 2

    • Clustering with Scikit-Learn - Project 10

    • Project 10 Solution.

    • Wrap-Up.mp4

  • 40

    Sharpening Your Soft Skills for Jobs

    • Welcome to the Jobberman x Utiva Employability Program

    • Sharpening Your Soft Skills

    • Welcome to the SkilledUp Life UK x Utiva Employability Program

    • Practice what you have learnt so far.

    • Student Feedback

  • 41

    Virtual Projects [Post-Training]

    • Welcome to your Virtual Projects Program!

    • Indicino Capstone Project

    • AGCC Capstone Project