Data Analytics Certificate Course

• What is Data Analytics? Overview and Applications
• Setting Up Your Development Environment
• Writing Your First Data Analytics Program
• Understanding Syntax, Indentation, and Basic Commands
• Python’s Place in Modern Tech

Data Analytics is used to make the conclusions from the data. This will help the
organizations to analyse the market the avail more profit & business growth. There will
be huge demand for Data Analysts in the market, even the startups are also hiring Data
Analyst for faster growth of startups.

We at KS Technologies offers Data Analytics course with recognized certificate and job
assistance program. This is program is designed to give an opportunity to learner to
make career in Data Analytics. This course consists of various modules like Python,
Advanced Python, SQL, Numpy, Pandas, Power BI & Tableau. It is designed as per industry
standards so the learner will get all the skills from Beginner to advanced level Even the
NON-IT student can also understand the things very easily & get skilled in period of time.
Along with the course we also provide material in hard as well as in soft copies. After the
completion of the program candidate is eligible for the job assistance program.

• Introduction
• Python-Pluses
• Python -Minus
• Working in python
  • Working in default Python Distribution
  • Anaconda Distribution
  • PYScript
• Understanding

• Introduction
• Types of Statements in Python
• Statements Flow Control
• Program Logic-Development Tools
  • Flowcharts
• The if statements of Python
  • The is statements
  • The if-else statements
  • The if-elif statements
  • The nested if statements
• The range () Function
• Iteration / Looping Statements
  • The for Loops
  • The while Loops
  • Loop else Statements
  • Jump Statements: break, continue
    & pass
  • Nested Loops

• Introduction
• Data Types
  • Numbers – String
  • Lists and Tuples – Dictionary
• Operators
  • Arithmetic Operators
  • Relational Operators
  • Identity Operators
  • Logical Operator
• Expressions
  • Evolution Expression
  • Type Casting
  • Membership Operators
  • Binary Operators

• Introduction
• Python Character Set
• Tokens
  • Keywords
  • Identifiers (Name)
  • Literals/Values
  • Operators
  • Punctuators
• Bare bones of a Python Program
• Variables and Assignments
  • Creating a variable
  • Multiple Assignments
  • Variable Definition
  • Dynamic Typing
• Simple Input and Output
  • Reading Numbers
  • Output Through Print Statements

• Introduction
• Traversing a String
• String Operators
  • Basic Operators
  • Membership Operators
  • Comparison Operators
• String Slices
• String Functions & Methods
• Practical Demo

• Introduction
• What is Debugging?
• Errors and Exceptions
  • Errors in the program
  • Exception
• How to Debug a Program?
  • Debugging Techniques

• Introduction
• Creating and Accessing List
  • Creating List
  • Accessing List
• List Operators
  • Joining List
  • Repeating or Replicating List
  • Slicing the Lists
• Working with Lists
• List Functions & Methods

• What is Tuple?
• Creating & Accessing Tuples
  • Creating Tuples
  • Accessing Tuples
• Tuple Operation
  • Joining Tuples
  • Slicing the Tuples
• Tuple Functions & Methods

• Introduction
• Dictionary-key: Value Pairs
  • Creating a new dictionary
  • Accessing element of dictionary
  • Characteristics of dictionary
• Working with Dictionaries
  • Multiple ways of creating
    dictionary
  • Adding elements to dictionary
  • Updating Existing elements in
    a dictionary
  • Deleting elements from the
    dictionary
  • Pretty printing a dictionary
  • Counting Frequency of elements
    in a list using dictionary
  • Dictionary Functions & Methods

• Introduction to Data & Time function
• Implementing Date Functions
• Implementing Time Functions

• Defining Functions
• Calling Functions
• Function with Parameters
• Return statement
• Function with default Parameters
• Recursive functions
• Keyword Functions
• Functions with *args, *kargs

• Opening & Closing Files
• Various File modes
• Close() method
• Reading & Writing Files
• Appending files
• File positions
• Renaming & Deleting files
• Write & Read Binary files
• Directory related commands

• What is Exception?
• Exception types
• Exception handling code
• Try-finally clause
• Raising an exception
• Custom Exceptions
• Creating & Implementing Custom Exception

• Introduction to OOPS Programming ,
  Advantages &Disadvantages
• What is class & objects
• Implementing classes
• Creating Objects
• Sample codes for Classes & objects

• Introduction to inheritance,
  base class and derived class concepts
• Need for inheritance
• Types of inheritance
• Creating inheritance code in python
• Base() in Inheritance
• Exercise for inheritance

• Introduction
• Applying polymorphism in python
  code
• Method Overriding

• Introduction to Numpy
• INdarray object
• Data types
• Array attributes
• Array from existing data
• Array from numerical ranges
• Indexing & Slicing
• Iteration over array
• Array manipulations
• Binary operations
• String operations
• Math functions
• Arithmetic operations

• Introduction to PANDAS
• Data structures
• Series (Create, Access, Operations)
• Data Frame
• Data Frame Methods
• Reindexing
• Sorting
• Window Functions

• Introduction to MYSQL
• MYSQL Syntax
• MYSQL Data Types
• MYSQL Operators

• MYSQL CREATE Database
• MYSQL DROP Database
• MYSQL RENAME Database
• MYSQL SELECT Database

• What is Table
• MYSQL TABLE Variable
• MYSQL CREATE TABLE
• MYSQL DROP TABLE
• MYSQL DELETE TABLE
• MYSQL RENAME TABLE
• MYSQL TRUNCATE TABLE
• MYSQL COPYTABLE
• MYSQL ALTER TABLE

• INSERT Statement
• INSERT INTO Values
• INSERT INTO SELECT
• NSERT Multiple Rows

• SELECT Statement
• MYSQL SELECT UNIQUE
• MYSQL SELECT DISTINCT

• MYSQL WHERE
• MYSQL AND
• MYSQL OR
• MYSQL WITH
• MYSQL AS

• ORDER BY Clause
• ORDER BY ASC
• ORDER BY DESC
• ORDER BY LIMIT
• ORDER BY Multiple Cols

• UPDATE single value
• UPDATE multiple values
• UPDATE all values

• DELETE all rows
• DELETE rows on conditions
• TRUNCATE command
• MYSQL DELETE DATABASE

• MYSQL JOIN
• MYSQL Outer Join
• MYSQL Left Join
• MYSQL Right Join
• MYSQL Full Join
• MYSQL Cross Join

• Primary Key
• Foreign Key
• Composite Key
• Unique Key
• Alternate Key

• Grant All rights
• Grant rights to user
• Revoke rights

• Python & MyMYSQL integration
• Installing components for
  integration
• Demo Application with CRUD –
  CREATE, READ, UPDATE, DELETE
  operations using python
• Create Database driven python
  application

• Introduction
• Data Visualization tools
• Advantages & Disadvantages
  of Tableau
• Tools of Tableau
• Architecture
• Data Filtration in Tableau
• Installation
• Workspace
• Tableau Navigation
• Data Terminology
• Data Types
• String Calculations
• Data Calculations
• Data Aggregation
• Tableau Data Connections
• Operators
• Functions
• Numeric Calculations
• Charts & Graphs
• Tableau v/s. Power BI

• Introduction
• What is Power BI?
• Why Power BI?
• Data Sources in BI
• Charts in BI
• Export Data to csv
• Tables & Matrices in BI
• Conditional Formatting in BI
• Formatting in Charts
• Reports in BI
• Export Reports PPT, PDF
• Create Dashboards in BI
• DAX Functions in BI
• Calculated Columns

• Spreadsheet introduction
• Formulas & Functions
• Creating sheets
• Applying functions
• Absolution, Relative & Mixed
  cell references
• Sorting, Searching, Filters,
  Advanced Filters Goal Seek
• Consolidations
• Naming cells & using them
• Pivot table & Charts
• Different types of charts
• Math functions
• Vlookup & Hlookup
• Logical functions
• Conditional functions
• Trigonometric functions
• String Functions
• Date & Time Functions
• Creating charts
• Practical Assignments