Syllabus

Learning Outline

  • 1

    Welcome to Utiva!

    • Let's get you started!

    • Introduction to Data Analytics

    • SQL Installation Kit

    • Power BI Installation Kit
  • 2

    Let's Begin by Laying The Foundations [Pre-Class]

    • Become Familiar With The Excel Tool [Must-Watch]

    • The Analyst's Toolbox [Must-Watch]
  • 3

    Class 1- Prepping The Data File

    • Data Cleansing, Preparation & Management

    • Learning Slides : Data Analytics with Excel

    • Datasets

    • Class Recording

    • Assessment I

    • Assignment I
  • 4

    Class 2- Analyzing and Categorizing Your Data

    • Master MS Excel Conditional Formulas

    • Datasets

    • Assessment II

    • Class Recording

    • Take Home
  • 5

    Class 3- Learn From Your Peers

    • Reinforce Your Learning

    • Class Recording
  • 6

    Class 4- Visualizing Your Data

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

    • Datasets

    • Class Recording
  • 7

    Class 5- Work on Your Excel Capstone Project

    • Excel Capstone Project

    • Work on Your Project With Your Peers

    • Class Recording
  • 8

    LinkedIn Optimization Session [Mid-Term]

    • Mid-Term

    • LinkedIn Optimisation I

    • LinkedIn Optimisation II

    • LinkedIn Optimisation III
  • 9

    Excel Feedback Survey

    • Feedback Survey
  • 10

    Class 6- Let's Install your PostgreSQL

    • Installation of your PostgreSQL

    • Class Recording
  • 11

    Let's Continue by Learning Database Fundamentals [Pre- Class]

    • The Structured Query Language (SQL) [Must-Watch]

    • Manage and Analyze Data with SQL [Must-Watch]
  • 12

    Class 7- Perform Advanced Data Analysis

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

    • Learning Slide - SQL for Data Analytics

    • Dataset

    • Class Recording

    • Assessment I

    • SQL Assignment I
  • 13

    Class 8- Organize Your Data Sets

    • Grouping Data and Computing Aggregates

    • Class Recording

    • SQL Assignment II
  • 14

    Class 9- Learn From Your Peers

    • Reinforce Your Learning

    • Reinforce Your Learning

    • Class Recording
  • 15

    Class 10- Easily Clean your Data

    • Using SQL for Data Cleansing

    • Class Recording
  • 16

    Class 11- Work on Your SQL Capstone Project

    • SQL Capstone Project

    • Work on Your Project With Your Peers

    • Class Recording
  • 17

    SQL Feedback Survey

    • Feedback Survey
  • 18

    Let's Begin by Laying the Foundation [Pre-Class]

    • Import and Transform Different Data Sources in Power BI [Must-Watch]

    • Learning Slide
  • 19

    Class 12- Connecting Different Data Sources for Visualization

    • Create Measures and Columns for Visualization

    • Learning Slide

    • Datasets

    • Class Recording

    • Assessment
  • 20

    Class 13- Perform Calculable Functions with your Data

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

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

    • Learning Slides

    • Dataset

    • Class Recording
  • 21

    Class 14- Learn From Your Peers

    • Reinforce Your Learning

    • Class Recording
  • 22

    Class 15- Build Interactive Dashboards for Storytelling

    • Creating Interactive Dashboards & Storytelling

    • Learning Slide

    • Class Recording
  • 23

    Class 16- Work on Your Power BI Capstone Project

    • Power BI Capstone Project

    • Work on Your Project With Your Peers

    • Class Recording
  • 24

    PowerBi Feedback Survey

    • Feedback Survey
  • 25

    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.
  • 26

    We Would Love to Hear From You!

    • Feedback Survey

  • 27

    Virtual Projects [Post-Training]

    • Welcome to your Virtual Projects Program!

    • European Football Capstone Project

    • Indicino Capstone Project

    • AGCC Capstone Project