The Art of Data Analytics in the Real World

Dec 18, 2024

Kaplan’s 4th Industrial Revolution (4IR) Courses encapsulate a wide range of soft and technical skills. The courses are catered to supplement students’ academic training and prepare them for the future of work. The 4IR courses are carefully selected to equip students with interpersonal, digital and practical skills that are industry relevant.

Course Objectives

  • Manage, transform and analyse data using the various functions and power of Microsoft Excel.
  • Understand how SQL (Structured Query Language) can be used with databases to ingest, manipulate and store data.

Course Structure

  • Pivot Table
    • Creating Pivot Tables
    • Sorting and Filtering Pivot Tables
    • Formatting Pivot Tables
    • Creating Pivot Charts
  • Functions & Formulas
    • IF and Related Functions
    • Lookup and Reference Functions
    • Power Functions, Statistical Functions, Math Functions
    • Date and Time Functions
    • Array Functions
    • Text Functions
  • Advanced Charts
    • Creating Basic Charts
    • Style Charts with Design Tabs
    • Fine Tune Chart Elements
  • Simple Data Analysis
    • Installing Data Analysis Tool
    • Goal Seeker & Solver
    • Histogram
    • Linear Regression
  • Basics of SQL (M/S SQL Server 2018/9)
    • Basics of Databases and Tables
    • Database and Table Designs
    • Normal Forms
    • Basics CRUD operations on Tables
    • Where, Having Clauses
    • Joins (Inner/Outer)
    • Aggregate Queries
    • Sub-queries
    • Basics of Stored Procedures

Rewards

  • E-Certificate of Completion by Kaplan will be awarded upon completion of the course.
Register Here
The Art of Data Analytics in the Real World
Share