Course Curriculum

  • 1

    Welcome to Utiva!

    • Let's get you started!

    • Introduction to Data Analytics

    • SQL Installation Kit

    • Power BI Installation Kit

    • Python Installation Kit
  • 2

    Let's Begin by Laying The Foundations

    • Become Familiar With The Excel Tool

    • The Analyst's Toolbox
  • 3

    Prepping The Data File

    • Explore Paste Special, Formatting, Functions and Formulas for Data Cleansing

    • Learning Slides : Data Analytics with Excel

    • Datasets

    • Live Class Recording

    • Quiz 1
  • 4

    Performing Data Analysis

    • Master MS Excel Conditional Formulas to Ensure Consistency and Accuracy Within a Dataset

    • Datasets

    • Live Class Recording

    • Quiz 2
  • 5

    Visualizing Your Data

    • Explore How To Use Pivot to Create Visual Reports of Data From a Spreadsheet

    • Datasets

    • Live Class Recording

    • Quiz 3
  • 6

    Comparing Business Scenarios

    • Explore the What-If Analysis Tool

    • Live Class Recording

    • Quiz 4
  • 7

    Work on Your Excel Capstone Project

    • Excel Capstone Project
  • 8

    LinkedIn Optimisation Session [ Mid-Term]

    • Mid-Term

    • LinkedIn Optimisation I

    • LinkedIn Optimisation II

    • LinkedIn Optimisation III
  • 9

    Excel Feedback Survey

    • Feedback Survey
  • 10

    Let's Continue by Learning Database Fundamentals

    • The Structured Query Language (SQL)

    • Manage and Analyze Data with SQL
  • 11

    Perform Advanced Data Analysis

    • Write complex SQL statements to query the database and gain critical insight on data

    • Live Class Recording

    • Quiz 5

    • Dataset
  • 12

    Organize Your Data Sets

    • Grouping Data and Computing Aggregates

    • Learning Slide - SQL for Data Analytics

    • Dataset

    • Live Class Recording

    • Quiz 6
  • 13

    Query and Sort Your Data

    • Explore SQL Joins and Advance Joins.

    • Live Class Recording

    • Assignment

  • 14

    Easily Clean Your Data

    • Explore Data Cleansing Techniques

    • Live Class Recording

    • Quiz 7
  • 15

    Work on Your SQL Capstone Project

    • SQL Capstone Project
  • 16

    Phase 1: Learn From Peers

    • Reinforce your learning

    • Live Class Recording

  • 17

    CV Review Session [Mid-Term]

    • Lets Work On Your CV

    • Live Class Recording
  • 18

    Let's Review Your Capstone Projects

    • Excel and SQL Capstone Project Review

    • Live Class Recording

  • 19

    SQL Feedback Survey

    • Feedback Survey
  • 20

    Explore the Data Visualization Foundations

    • Become Familiar with the Power BI Tool

    • Learning Slides
  • 21

    Formatting and Transforming Your Data

    • Using Power BI to Process, Format Data and Power BI Data Model

    • Learning Slides

    • Datasets

    • Live Class Recording
  • 22

    Visualizing and Communicating Data Insights

    • Manage Data Relationship, Understand Cardinality, Develop Time Intelligence and Introduce DAX Functions

    • Live Class Recording
  • 23

    Understanding Charts

    • Let's Explore the Presentation of Charts [Must Watch]

    • Understanding Charts, Shapes, Textboxes, Images, Slicers and Importing Custom Visuals

    • Live Class Recording
  • 24

    Create Interactive Dashboards

    • Create Interactive Dashboard, Explore Storytelling with Data and Learn Publishing to web

    • Live Class Recording
  • 25

    Work on Your Power BI Capstone Project

    • Power BI Capstone Project
  • 26

    Phase 2: Learn From Peers

    • Reinforce your learning

    • Live Class Recording

  • 27

    Let's Review Your Capstone Project

    • Power BI Capstone Project Review

    • Live Class Recording
  • 28

    PowerBi Feedback Survey

    • Feedback Survey
  • 29

    Sharpening Your Hard Skills for Jobs

    • LinkedIn & Portfolio Building Session I

    • Learning Slides

    • LinkedIn & Portfolio Building Session II

    • Learning Slides
  • 30

    Getting Started With Python

    • Getting Started With Python
  • 31

    Explore Programming & Python Fundamentals

    • Explore The Anaconda and Jupyter Environment

    • Live Class Recording

    • Discover Python Tuples & Dictionary

    • Live Class Recording

    • Assessment

    • Master List Comprehension, Lambda Expressions and Process Data Using Loops

    • Live Class Recording
  • 32

    Using Pandas for Data Analytics

    • Getting Started With Pandas

    • Learn Series and Database, Groupby and Merging, Data input & Output

    • Live Class Recording

    • Assessment
  • 33

    Phase 3: Learn From Peers

    • Reinforce Your Learning

    • Live Class Recording
  • 34

    Collect, Manipulate and Process Data

    • Getting Started With Data Processing

    • Live Class Recording
  • 35

    Transform Raw Data Into Features

    • Feature Engineering

    • Live Class Recording
  • 36

    Build Models Using Feature Selection

    • Feature Selection

    • Live Class Recording
  • 37

    Model Relationships Between Variables Using Linear & Multiple Regressions

    • Introduction to Linear Regression & Multiple Linear Regression

    • Live Class Recording
  • 38

    Phase 4: Learn From Peers

    • Reinforce Your Learning

    • Live Class Recording
  • 39

    Model Probability of Events UsIng Logistic Regression

    • Logistic Regression

    • Live Class Recording
  • 40

    Analyze Data for Classification Using Support Virtual Machines

    • Support Vector Machines Fundamentals

    • Live Class Recording
  • 41

    Make Solid Decisions Using Decision Trees

    • Decision Trees

    • Live Class Recording
  • 42

    Work on Your Python Capstone Project

    • Python Capstone Project
  • 43

    Phase 5: Learn From Peers

    • Reinforce your learning

    • Live Class Recording
  • 44

    Python Feedback Survey

    • Feedback Survey
  • 45

    VIRTUAL APPRENTICESHIP

    • Welcome to your Virtual Apprenticeship Program!

    • Building your Profile

    • Testing your Data Cleaning Knowledge

    • Testing your Data Querying Knowledge

    • Testing your Data Visualization Knowledge

    • Final Project
  • 46

    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 is have Learnt So far.
  • 47

    We Would Love Your Feedback!

    • Feedback Survey