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

    • Introduction to Formatting [Must Watch]

    • Submit your Assignment

  • 25

    Data Preparation and Transformation

    • Learning Slide

    • Learning Outcome

    • Data Preparation and Transformation

    • Submit your Assignment

  • 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 Slide

    • Learning Outcomes

    • Creating Interactive Dashboards

    • Submit your Assignment

  • 29

    Power BI Capstone Project

    • Power BI Capstone Project

    • Submit your Project

    • Feedback Survey

  • 30

    Introduction to Anaconda

    • Setting Course Expectation

    • Introduction to Anaconda _ Jupiter Notebook

    • Variables in Python

    • Operators in Python

  • 31

    Data Types in Python

    • Introduction to Data Types in Python

    • String Data Type II

    • List Data Type 1

    • Lists Data Type 2

    • Tuple Data Types

    • Dictionary Data Type

  • 32

    Conditions, Methods, Functions in Python

    • Sets Data Type

    • Conditions in Python

    • Methods in Python

    • Functions in Python

    • Improving Your Python Code 1

    • Improving Your Python Code 2

  • 33

    Data Proccessing

    • Introduction to Data Processing

    • Introduction to Data Processing II

    • Indexing and Selection

  • 34

    Data Analytics with Numpy

    • Data Analytics with Numpy 1

    • Data Analytics with Numpy 2

    • Data Analytics with Numpy 3

    • Basic Image Processing with Numpy

  • 35

    Data Analytics with Pandas

    • Introduction to Data Analytics with Pandas

    • Pandas Series 2

    • Pandas DataFrame 1

    • Pandas DataFrames 2

  • 36

    Working with Data

    • Working with Missing Data

    • Merge, Join, Group _ Concat

    • Pandas Operation

    • Data Vizualization with Python

  • 37

    Feature Engineering

    • Welcome to Feature Engineering

    • Equal Width Discretization 2

    • User-defined Interval Discretization

    • Discretization With Decision Trees

    • Outliers Engineering with IQR Rule

  • 38

    Feature Scaling & Engineering

    • Outliers with mean-and std

    • Capping Outliers at Zero

    • Feature Scaling

    • Engineering Date-Time

    • Engineering Date-Time 2

  • 39

    Future Selection, Logistic Regression and Support Vector Machines

    • Feature Selection

    • Regression

    • Regression_Multi

    • Logistic Regression

    • Support Vector Machines

  • 40

    Decision Tree

    • Decision Tree - Classification

    • Decision Tree - Regression

  • 41

    Wine Quality Prediction

    • Wine Quality Prediction 1

    • Wine Quality Prediction 2

  • 42

    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

  • 43

    Virtual Projects [Post-Training]

    • Welcome to your Virtual Projects Program!

    • Indicino Capstone Project

    • AGCC Capstone Project