Data Analytics

Course Description

Data analytics is not just about working with numbers—it’s about turning data into meaningful insights for better decision-making. This course introduces the fundamentals of data analytics, including data collection, cleaning, and basic analysis techniques. Learn how to interpret data and uncover patterns that support real-world problem solving. Join this course to build a strong foundation and gain confidence in data-driven thinking.

What will you learn from this course?

• Confidence in Data-driven Decision Making
• Problem Solving Through Powerful Data Analysis
• Basics of Statistics
• Fundamentals of Database
• Data Analysis with Python
• How to ace Data Analytics Job Interviews
• How to Work Conveniently with Large Scale Data
• Basics of Data
• Usage of Data Analytics Tools and Technologies
• Data Analysis with SQL
• Career Paths in Data Analytics

For whom the course is

• Students
• Freelancer
• Anyone interested in working with Data Analytics
• Any industry professional
• Business, Finance & Data Professional

Complete Curriculum of the Course

Module 1: Data Analytics Basics

Lesson 1: Introduction to Data Analytics

Lesson 2: Data Preparation & Data warehousing

Lesson 3: Data Analytics Tools and Technologies

Lesson 4: Exploratory Data Analysis

Lesson 5: Basics of Stats

Module 2: Data Analysis with SQL

Lesson 6: Introduction to Databases and SQL Basics

Lesson 7: Database Fundamentals

Lesson 8: Normalization & Creating our first Table!

Lesson 9: SQL Queries and Retrieval

Lesson 10: Data Manipulation and Joins

Lesson 11: SQL Aggregation & functions

Lesson 12: Advanced SQL Topics

Lesson 13: Intro to Your BI Tool

Module 3: Data Analysis with Python

Lesson 14: Introduction to Python

Lesson 15: The pandas DataFrame

Lesson 16: Creating pandas DataFrames

Lesson 17: Accessing and Modifying Data

Lesson 18: Sorting, Filtering, and Handling Missing Data

Lesson 19: Working With Time Series and Plotting Data

Lesson 20: Capstone Project: Stock Market Data Analysis

Module 4: Career Path

Lesson 21: Career Opportunities in Data Analytics

Module 5: Conclusion

Lesson 22: Conclusion

What is Data Analytics?

Understand the fundamentals of public procurement from a PE perspective, including PPA 2006, PPR 2025, compliance obligations, and financial delegation structures.

Module 2: eGP Guidelines & APP Planning

Learn advanced eGP system guidelines, role-based access, system validation, and the preparation, approval, and revision of the Annual Procurement Plan (APP).

Module 3: Procurement Methods & Planning

Explore different procurement methods for Goods, Works, and Services, including tender selection strategies, classification, and audit risk control with practical examples.

Module 4: Tender Preparation & Committees

Gain knowledge of IFT preparation, STD structure, tender scheduling, and the formation and responsibilities of TEC and TOC committees, including conflict of interest management.

Module 5: Evaluation, Award & Contract Management

Learn the complete tender evaluation process, including administrative, technical, and financial evaluation, qualification verification, and contract award procedures.

Module 6: Complaints, Audit & Risk Prevention

Understand complaint handling procedures, audit compliance, risk mitigation strategies, and how to maintain audit-proof documentation through real case analysis