Data Analytics Curriculum

Module Overview

Introduction to Business Data Analytics (CBDA) is a comprehensive preparatory course designed to help you pass the IIBA – CBDA certification exam. This course focuses on the technical skills required to effectively perform business data analytics, its objectives, and its applications in various industries. Gain hands-on experience with data collection, cleaning, analysis, interpretation, and visualization techniques.

What You'll Learn

• •Techniques for data cleaning and preparation (handling missing values, outliers, and more)
• •Summarize and understand data characteristics for Exploratory Data Analysis (EDA)
• •Conversion of raw data into a suitable format for analysis
• •Using statistical methods to analyze data, including descriptive statistics, hypothesis testing, and correlation analysis
• •Using visualization techniques to create charts and graphs to communicate data insights
• •Using different visualization methods to create stories that convey complex information
• •Create conceptual, logical, and physical data models to represent data structure and relationships
• •Apply analytical techniques such as decision trees and regression analysis
• •Find optimal solutions to complex problems with mathematical techniques
• •Implement policies and procedures to ensure data quality, security, and compliance
• •Awareness of data warehousing and data marts for centralized data storage and analysis
• •Execute ETL (Extract, Transform, Load) processes
• •Apply data mining techniques and algorithms to find patterns in large datasets
• •Using Machine Learning (ML) algorithms to build predictive models

Course Outline

Module Overview

This course prepares you for the CompTIA Project+ (Exam PK0-005) certification and builds your IT project management skill set. You'll learn to manage the project life cycle, coordinate small- to medium-sized projects, establish communication plans, manage resources and stakeholders, maintain project documentation, and support completion of larger projects within an IT environment.

What You'll Learn

• •Manage the project life cycle
• •Coordinate small- to medium-sized projects
• •Establish a communication plan and manage resources and stakeholders
• •Maintain project documentation and artifacts
• •Support completion of larger projects within an IT environment

Course Outline

Module Overview

Python has a simple syntax that makes it easier to learn than other programming languages. At the same time, it's a powerful language that provides all of the features you need. This module takes you from zero to confident programmer.

What You'll Learn

• •Use IDLE to test Python expressions and statements
• •Code, test, and debug programs
• •Use pseudocode to plan control structures and programs
• •Define and use functions, default values, named arguments, local and global variables
• •Plan test runs for a program
• •Use lists and tuples in programs
• •Use text, CSV, or binary files to save and retrieve data
• •Add exception handling
• •Work with numbers, strings, dates and times

Course Outline

Module Overview

Structured Query Language (SQL) is the language used to work with databases. This course provides a working knowledge of the basic forms of SQL, including how to select and update data from common table formats. Learners will create a database and use SQL to manipulate the data within it.

What You'll Learn

• •Install SQL Server and explore relational database basics
• •Write SQL SELECT statements to retrieve data from single and multiple tables
• •Write queries with JOINs, aggregate functions, and subqueries
• •Insert, update, and delete data
• •Convert and edit data in a database
• •Design and create a database

Course Outline