Data Analytics

Course Description:

This course provides a comprehensive introduction to data analytics, focusing on powerful tools like Power BI, Tableau, and SQL. Participants will learn to visualize, analyze, and interpret data effectively to drive informed business decisions. The curriculum combines theoretical concepts with hands-on projects to ensure practical experience in data analysis.

Learning Outcomes:

Proficiency in using Power BI for creating interactive dashboards and reports.
Expertise in Tableau for data visualization and storytelling with data.
Strong understanding of SQL for querying and managing relational databases.
Ability to clean, transform, and analyze data using best practices.
Skills to present data-driven insights and make strategic recommendations.

Target Audience:

Aspiring data analysts and business intelligence professionals.
Individuals looking to enhance their analytical skills for career advancement.
Professionals in fields such as marketing, finance, or operations who want to leverage data in decision-making.

Prerequisites:

Basic knowledge of data analysis concepts is helpful but not mandatory.
Familiarity with Excel or other data manipulation tools can be beneficial.

This course is designed to equip students with the skills needed to thrive in data analytics roles, empowering them to uncover insights and drive business success.

Course Pricing

S$ 2400

Free

Course Features

University Approved Syllabus
40 Hours Instructor-led Training
40 Hours Lab & Assignments
Expert Trainer
Study From Anywhere
Certificate of Completion
100% Job Assistance

Founded by a team of industry veterans, we offer a wide range of courses in programming, data science, cybersecurity, cloud computing, and more. Our expert instructors bring real-world experience, ensuring that our students receive practical, hands-on training that prepares them for today’s job market.

Data Analytics

Overview

Course Content

Tools – Tableau

Tableau interface demo

Tableau Products

Tableau Desktop

Types of Connection

Dimension and measures

Tableau file extension

Set, Parameter, Group

Bin, Hierarchy, Combine

Sorting, Types of Axis, Maps

Filters

Quick Table Calculation

Analytics Functions

Number Functions

Aggregate Functions

Logical Functions

String Functions

Table Calculation Functions

Window Functions

Date Functions

LOD-Level of Detail

Types of Charts

Dashboard Functions

Dashboard Actions

Data Modeling

Tableau Server/Online

Embedded Data Source

Published Data Source

Different site roles

User controls RLS (Row level Security)

Alert, Subscription, Metrics

Empty Extract

Real time Scenarios

Dashboard Creation from Scratch

Thread Communication

Thread Safety and Deadlocks

Tools – Power BI

Microsoft Power BI

M Query

Power Query Editor

Data types

Column Tracking

Split columns

Choose column

Keep / Remove Rows

Append Queries

Duplicates Queries

Join Kind

Merge Queries

Join

Extract

Format

Functions

Data Modelling Data modeling is the process of analyzing and defining all the different data types your business collects and produces, as well as the relationships between those bits of data.

DAX Functions

Data Types

Basic Functions

Date Function

Aggregation Functions

Logical Function

Filter Function

Time Intelligence Function

Information Function

Power BI Visualization

Dashboards

Formatting

Power BI service The Power BI service is a cloud-based service, or software as a service (SaaS). It supports report editing and collaboration for teams and organizations. You can connect to data sources in the Power BI service, too, but modeling is limited.

Tools – SQL Structured Query Language is a domain-specific language used to manage data, especially in a relational database management system. It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

Oracle SQL Developer

Topics – SQL

Introduction to SQL

Introduction to databases

Install a database engine

Data types

Operators

Case manipulation functions

Character manipulation functions

Data Modelling
Data modeling is the process of analyzing and defining all the different data types your business collects and produces, as well as the relationships between those bits of data.

Power BI service
The Power BI service is a cloud-based service, or software as a service (SaaS). It supports report editing and collaboration for teams and organizations. You can connect to data sources in the Power BI service, too, but modeling is limited.

Tools – SQL
Structured Query Language is a domain-specific language used to manage data, especially in a relational database management system. It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.