Data Analyst
Data analysis is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
Pandas
- Data Frames
- Data Cleaning
- Data Aggregation
- Feature Engineering
- Vectorization
- Parallel Processing
- Maps and Visualization
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