OOPs in Python

• Class & Objects
• Variable Type
• Static variable in class
• Create classes
• Instance methods
• Constructor and destructors
• Inheritance and its types
• Polymorphism
• Encapsulation
• Scope and visibility of variables

Exceptions

• Errors and its types
• Exception Handling with try
• Handling multiple Exceptions
• Writing own exception/ custom exceptions
• Raise an Exception

File Handling

• File Handling modes
• Reading files
• Writing & Appending to Files
• Handling file exceptions
• The with statement

Introduction to Pandas

• Brief history
• Installation
• Plots in Pandas
• Time series data
• Manipulate Textual Data
• Data frames
• Method Chaining
• Reshaping data
• Handling Missing data
• Combine dataset

Introduction to Matplotlib

• Brief history
• Installation
• Types of inputs to plotting functions
• The explicit and the implicit interfaces
• Axes labels and text
• Annotations
• Axes Legends
• Scales
• Tick locators and formatters
• Plotting dates and strings
• Additional Axis objects
• Color mapped data
• Working with multiple Figures and Axes

An introduction to seaborn

Overview of seaborn plotting functions Data structures accepted by seaborn The seaborn.objects interface Properties of Mark objects Visualizing statistical relationships Visualizing distributions of data Visualizing categorical data

Statistical estimation and error bars Estimating regression fits Building structured multi-plot grids Controlling figure aesthetics Choosing color palettes

Basic & Advance Excel with Generative AI

• Worksheet Basics
• Data Formats
• Data Handling Basics- Cut, Copy and Paste
• Saving and Printing

New! Xlookup -only for Excel 2021 and office 365

• Xlookup as replacement of Vlookup
• Wildcard matching in Xlookup
• Search modes in Xlookup

Data Tools

• Sorting Filtering and Data Validation
• Text-to-columns and removes duplicates
• Advance Filter option
• Formatting data and tables

Pivot table and Pivot charts

• Pivot Table
• Pivot Charts

Macros

• Introduction to Excel Macros
• When and how to use Excel Macros
• How and when to use Events

Excel Charts

• Important of data visualization
• Elements of charts
• The Easy way of creating charts
• Bar and column charts
• Formatting Charts
• Line Charts
• Area Charts
• Pie and Doughnut Charts
• Scatter plot or XY chart
• Waterfall Charts
• Sparklines

SQL Introduction

• Introduction

Database Basics

• What is SQL
• Table and DBMS
• Types of SQL commands
• PostgreSQL

Restore and Back-up

• Creating DB using CSV files
• Restore and Back-up

Fundamental SQL statements

• CREATE
• Create DB and Table
• INSERT
• PRIMARY KEY FOREIGN KEY
• Import data from file
• Inserting and Importing Data
• SELECT statement
• SELECT DISTINCT
• WHERE
• Logical Operators
• SELECT, WHERE & Logical
• UPDATE
• DELETE
• ALTER

Selection commands: Filtering

• IN
• Quick coding exercise on IN operator
• BETWEEN
• LIKE

Selection commands: Ordering

• Commenting in SQL
• ORDER BY
• LIMIT
• Sorting

Aggregate Commands

• COUNT
• SUM
• AVERAGE
• MIN MAX

Group By Commands

• GROUP BY
• HAVING

Conditional Statement

• CASE WHEN

JOINS

• Introduction to joins
• Concept of Joining and Combining Data
• Preparing the data
• Inner Join
• Left Join
• Right Join
• Full Outer Join
• Cross Join
• Intersect and Intersect ALL
• Except
• Union

Subqueries

• Subquery in WHERE clause
• Subquery in FROM clause
• Subquery in SELECT clause

Views and Indexes

• VIEWS
• INDEX

Date-Time Function

• CURRENT DATE TIME
• AGE
• EXTRACT

String Function

• LENGTH
• UPPER LOWER
• REPLACE
• TRIM LTRIM RTRIM
• CONCATENATION
• SUBSTRING
• LIST AGGREGATION

Mathematical Functions

• CEIL FLOOR
• RANDOM
• SETSEED
• ROUND
• HROUND

Pattern (STRING) Matching

• Pattern Matching Basics
• Advance Pattern Matching (REGULAR EXPRESSION)

Data Types conversion function

• Data Types conversion function
• Converting String to Numbers Date

Introduction to MongoDB Database

• Connect MongoDB Shell
• Helpers
• CRUD
• Databases and Collections
• Indexes
• Handy commands
• Change Streams
• Replica Set
• Sharded Cluster

Power BI Dashboard: Netflix with Generative AI

• Download Power BI and Connect to Data
• Power BI Overview
• Create Area Chart
• Create Shows by Rating & Top 10 Categories Charts
• Create Countries Available Map and Import Netflix logo
• Create Single Title View Page

Classic Models Data Analysis

• Sales Overview by Product
• Sales Overview by Country
• Customers ‘Sales Value by Credit Limit
• Sales Value Change from Previous Order
• Customers Affected by Late Shipping

Power BI Dashboard: Classic Models

• Downloading MSQL Workbench Classic Model Database
• Create View in MySQL Workbench for Power BI
• Connecting to Power BI Data Source
• Connect Power BI to Data Source & Prepare Canvas
• Create Overview Cards
• Create Overview Line Charts
• Set up Measures for Sales & Net Profit Buttons
• Add Actions to Button and Create Bar Chart
• Create Scatter, Column & Donut Charts
• Add Conditional Titles to charts
• Create Decomposition Tree
• Add Filters and Page Navigation Buttons

Python Libraries

• Pandas
• Matplotlib
• Seaborn

GenAI (Generative AI)

• How Generative AI works
• LLMs as a thought partner
• AI is a general-purpose technology
• Writing
• Reading
• Chatting
• What LLMs can and cannot do
• Tips for prompting
• Image generation (optional)

Requirement Analysis

• SMART requirements
• Traceability
• Dependency
• Phase of the Requirement Process
• Elicitation
• Analysis
• Specification
• Business Rules
• Business Requirements
• Requirement Elicitation Introduction
• Identifying Customer before Elicitation
• Stakeholders,Customers,and Users
• Elicitation Technique : Brainstorming
• Elicitation Technique : Surveys (Open-ended, closed-ended)

• Visual Modelling Concepts
• Business Model (Organizational Chart, scoring matrix, stakeholder map, use case, process flow, wireframe)
• Technical Models (System context diagram, data flow diagram, CRUD matrix state diagram, ERD)