Data Science
Data science combines math and statistics, specialized programming, advanced analytics, artificial intelligence (AI) and machine learning with specific subject matter expertise to uncover actionable insights hidden in an organization’s data. These insights can be used to guide decision making and strategic planning.
Pandas
- Data Frames
- Data Cleaning
- Data Aggregation
- Feature Engineering
- Vectorization
- Parallel Processing
- Maps and Visualization
Statistics
- Exploratory Data Analysis
- Descriptive statistics
- Sampling Theory
- Frequency distributions
- Mean, Median, Mode, standard Deviation, variance
- Covariance and correlation
- Normal Distribution
- Z scores
Probability Theory
- Introduction to probability
- Estimating Probability
- Addition Rule
- Permutation and combination
- Bayes Theorem
Machine learning
- Supervised and Unsupervised learning
- Linear Regression
- Polynomial Regression
- Logistic Regression
- Support vector machines
- Decision Trees
- K-Nearest Neighbours
- Assessing performance
- Regularization, Outfitting, outliers and generalization
Deep Learning
- Neural Networks
- NLP
- Unsupervised learning
- Directionality Reduction
- Customer Clustering
- Real Time Case Studies
PowerBI
- Introduction to Power BI and its components.
- Data Sourcing and Loading
- M language for data manipulation (optional)
- Data Modelling
- Rules to establish relationship between tables
- DAX – Data analysis expressions
- Power Query
- Visualization and usages of chart
- Dashboard creations, publish and sharing options in web
- Setup Auto refresh
SQL
- SQL Introduction
- SQL Syntax
- SQL Select
- SQL Select Distinct
- Unique
- SQL Where
- Comments
- Column Aliasing
- SQL Order By
- Relational Operators
- SQL And
- SQL Or
- SQL Not
- Dual table
- Single and Multiple Column Sorting
- SQL Insert Into
- SQL Null Values
- SQL Update
- SQL Delete
- SQL Like Operator
- SQL Wildcards
- SQL In
- SQL Between
- SQL Aliases
- SQL Aggregate Functions
- SQL Min and Max
- SQL Count
- SQL Sum
- SQL Avg
- SQL Variance
- SQL Standard Deviation
- SQL Group by Single and Multiple Column
- SQL Having
- Scalar Functions
- Numeric Functions
- String Functions
- Date Time Functions
- Conversion Functions
- Tables
- SQL Create Table
- SQL Drop Table
- SQL Alter Table
- Primary Key
- Foreign Key
- SQL Constraints
- SQL Not Null
- SQL Check
- SQL Default
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- Cross Join
- SQL Self Join
- Natural Join
- Set Operators
- SQL Union
- Intersect
- Minus
- Union all
- SQL Case
- Sub Queries
- Single and multi row
- Multi column sub queries
- SQL Views
- Synonyms
- Indexes
- Sequences
- Data Dictionary
- Analytical Functions
- Raking
- Row_Number
- Rank
- Dense Rank
Python
- Python Intro
- Python Get Started
- Python Syntax
- Python Comments
- Python Variables
- Python Data Types
- Python Numbers
- Python Casting
- Modify Strings
- Concatenate Strings
- Escape Characters
- String Methods
- String Exercises
- Python Booleans
- Python Operators
- Python Lists
- Python Tuples
- Python Sets
- Python Dictionaries
- Input Functions
- Python If…Else
- if elif
- Python While Loops
- Nested While
- Coffee machine project
- Python For Loops
- Patterns program
- For else
- Arrays
- Implicit conversion
- Explicit Conversion
- Numpy
- Deep Copy
- Shallow Copy
- Different Arrays in Numpy
- Multi-Dimensional Array
- Conversion 1D array to multi D array
- Array Multiplication
- Matrix Multiplication
- Replacing the values in the array
- Replacing the values in the matrix
- User Defined Functions
- Types of Arguments
- Kwargs
- Scope of a variable
- Fibonacci
- Even and Odd count
- Factorial of a number
- Recursion
- Factorial using recursion
- Lambda functions or Lambda
- expression
- filter
- map
- reduce
- Decorators
- Functions
- Special Variable Name
- OOPS
- Constructors
- Class or Static Variables
- Instance variables
- Class Methods
- Instance Methods
- Accessors
- Mutators
- Static Methods
- Namespace
- Nested Class
- Inheritance
- Single Level
- Multilevel
- Multiple
- Method Resolution Order
- Polymorphism
- Duck Typing
- Operator Overloading
- Method Overloading
- Method Over Riding
- Abstraction
- Iterators
- Generators
- Errors
- Handling Exceptions
- finally