dots bg

DSA - Semester 2

Course Instructor SkillArbitrage

FREE

dots bg

Course Overview

Schedule of Classes

Course Curriculum

5 Subjects

Data Analysis and Visualization

211 Learning Materials

Resources

Dates and Times

ZIP

Regular Expressions

ZIP

Intro to Numpy

ZIP

Intro to Pandas

ZIP

Grouping Operations

ZIP

Filtering Operations

ZIP

Basics of Visualization

ZIP

Advanced Visualizations

ZIP

Animated Visualizations

ZIP

Interactive Visualizations

ZIP

Miscellaneous Charts

ZIP

SuperStore

Audio

Tableau Functions Workbook

ZIP

Dates and Times

Introduction to datetime

External Link

The date and time class

External Link

The datetime class

External Link

The timedelta class

External Link

Quiz on Dates and Times

Quiz Solution on Dates and Times

External Link

Exercise on Date and Time

External Link

Solution on Date and Time

External Link

Regular Expressions

Meta Characters for Regular Expressions

External Link

Built-in Functions for Regular Expressions

External Link

Special Characters for Regular Expressions

External Link

Sets for Regular Expressions

External Link

Quiz on Regular Expressions

Quiz Solution on Regular Expressions

External Link

Exercise on Regular Expressions

External Link

Solution on Regular Expressions

External Link

Introduction to Numpy

Array Creation using Numpy

External Link

Mathematical Operations using Numpy

External Link

Built-in Functions in Numpy

External Link

Quiz on Introduction to Numpy

Quiz Solution on Introduction to Numpy

External Link

Exercise on Built-in Functions in Numpy

External Link

Exercise on Mathematical Operations using Numpy

External Link

Solution on Mathematical Operations using Numpy

External Link

Introduction to Pandas

Reading Datasets using Pandas

External Link

Plotting Data in Pandas

External Link

Indexing, Selecting, and Filtering Data using Pandas

External Link

Merging and Concatenating DataFrames

External Link

Lambda, Map, and Apply Functions

External Link

Quiz on Introduction to Pandas

Quiz Solution on Introduction to Pandas

External Link

Exercise on Pandas Plotting

External Link

Solution on Pandas Plotting

External Link

Exercise on Indexing and Selecting

External Link

Solution on Indexing and Selecting

External Link

Exercise on Merging and Concatenating

External Link

Solution on Merging and Concatenating

External Link

Exercise on Apply Functions

External Link

Solution on Apply Functions

External Link

Introduction to Data Exploration

How EDA can be useful

External Link

Data Profiling

External Link

Analyzing Target Data

External Link

Quiz on Introduction to EDA

Quiz Solution on Introduction to EDA

External Link

Examining Data

Summarizing the Data

External Link

Exploring the Dabl Library

External Link

Exploring the Sweetviz Library

External Link

Using Color Gradients for better analysis

External Link

Best Practices for Data Exploration

External Link

Quiz on Examining Data

Quiz Solution on Examining Data

External Link

Grouping Operations

Aggregate functions used for Grouping

External Link

Using Groupby for Grouping Operations

External Link

Groupby with Idxmax and Idxmin functions

External Link

Using Color scales for better visualization

External Link

Visualizing the Groupby Operations

External Link

Using Pivot Tables for Grouping Operations

External Link

Difference between Groupby and Pivot tables

External Link

Performing Cross Tabulation

External Link

Visualizing Cross tabulated Data

External Link

Interactive Grouping Operations

External Link

Quiz on Grouping Operations

Quiz Solution on Grouping Operations

External Link

Filtering Operations

When to perform Filtering Operations

External Link

Introduction to Simple Filtering Operations

External Link

Advanced Filtering Operations

External Link

Filtering and Grouping Operations

External Link

Interactive Filtering Operations

External Link

Quiz on Filtering Operations

Quiz Solution on Filtering Operations

External Link

Basics of Visualization

Univariate Analysis

External Link

Bivariate Analysis

External Link

Multivariate Analysis

External Link

Quiz on Basics of Visualization

Quiz Solution on Basics of Visualization

External Link

Advanced Visualizations

Scatter Plots

External Link

Charts with Colorscale

External Link

Bar, Line, and Area Charts

External Link

Facet Grids

External Link

Statistical Charts

External Link

Polar Charts

External Link

Subplots

External Link

3D Charts

External Link

Waffle Charts

External Link

Maps

External Link

Quiz on Advanced Visualizations

Quiz Solution on Advanced Visualizations

External Link

Animated Visualizations

Animation with Bubbleplot

External Link

Animation with Facets

External Link

Animation with Scatter Maps

External Link

Animation with Choropleth Maps

External Link

Quiz on Animated Visualizations

Quiz Solution on Animated Visualizations

External Link

Interactive Visualizations

Introduction to Ipywidgets

External Link

Interactive Univariate Analysis

External Link

Interactive Bivariate Analysis

External Link

Interactive Multivariate Analysis

External Link

Quiz on Interactive Visualizations

Quiz Solution on Interactive Visualizations

External Link

Miscellaneous Charts

Sunburst Charts

External Link

Parallel Co-ordinate Charts

External Link

Funnel Charts

External Link

Gantt Charts

External Link

Ternary Charts

External Link

Tree Maps

External Link

Network Charts

External Link

Quiz on Miscellaneous Charts

Quiz Solution on Miscellaneous Charts

External Link

Tableau Functions

Section Overview

External Link

Getting Started with Calculations

External Link

Types of Calculations

External Link

The Number Functions

External Link

The String Functions

External Link

Searching for Text

External Link

Type Conversions

External Link

The Date Functions

External Link

Datetrunc and datepart

External Link

Gantt Charts using Date Functions

External Link

The Logical Functions

External Link

Calculations using Sets

External Link

Aggregate Functions

External Link

Attribute Function

External Link

Quiz on Tableau Functions

Table Calculations

Section Overview

External Link

Table Calculation - Part 1

External Link

Table Calculations - Part 2

External Link

Table Functions

External Link

Window Functions

External Link

Conditional Highlighting using Windows Functions

External Link

Moving Calculations

External Link

Rank Functions

External Link

Running Functions

External Link

Secondary Calculations with Pareto Chart

External Link

Level of Detail (LOD) Expression

Resources - Global Superstore

ZIP

Resources LOD Workbook

ZIP

Introduction to Level of Details

External Link

FIXED - Level of Detail Expression

External Link

Customer Order Loyalty

External Link

Customer Retention Analysis

External Link

Removing Duplicate Records in Tableau using FIXED

External Link

INCLUDE - Level of Detail Expression

External Link

EXCLUDE - Level of Detail Expression

External Link

Table Scoped Level of Detail Expression

External Link

Nested LOD

External Link

Finding a Dimension at Lower Level

External Link

Sparklines with Min Max Indicator

External Link

Final Words

External Link

Parameters in Tableau

Resources SuperStore

Audio

Resources Parameters Workbook

ZIP

Parameters

External Link

Parameter Basics

External Link

Advanced Parameters Part - 1

External Link

Advanced Parameters Part - 2

External Link

Quiz on Parameters in Tableau

Introduction to Data Preparations

Resources Data Preparation Datasets

ZIP

Resources Data Preparation Workbooks

ZIP

Managing Metadata and Data Types

External Link

Data Extraction

External Link

Data Preparation and Cleaning

External Link

Wide and Long Formats

External Link

Filtering of Rows using Data Source Filters

External Link

Joins

External Link

Joining Multiple Fields

External Link

Complex Joins

External Link

Why Blending?

External Link

How to do Blending in Tableau?

External Link

Data Blending (Additional)

External Link

Data Union

External Link

Quiz on Data Preparations

Slicing & Dicing Data in Tableau

Resources Slicing & Dicing Datasets

ZIP

Resources Slicing & Dicing Workbook

ZIP

Sorting

External Link

Hierarchy

External Link

Groups

External Link

Sets

External Link

Data Filters

External Link

Advanced Filtering

External Link

Quiz on Slicing and Dicing Data in Tableau

Tableau Maps

Resources Superstore_dataset

ZIP

Resources Tableau Maps Workbook

ZIP

Beginner Guide to maps

External Link

Background Maps & Layers

External Link

Dual Axis Map

External Link

Geocoded Fields

External Link

Working with Web Map Service (WMS)

External Link

Custom Background Images

External Link

Quiz on Tableau Maps

Dashboards

Resources shark-data-cleaned

Audio

Resources Dashboards Workbook

ZIP

Section Overview

External Link

The Storytelling

External Link

Building Blocks of Dashboard - Part 1

External Link

Building Blocks of Dashboard - Part 2

External Link

Building Blocks of Dashboard - Part 3

External Link

Dashboard

External Link

Containers

External Link

Dashboard Actions

External Link

Quiz on Dashboards

Data Cleaning and Preparation

92 Learning Materials

Resources

Data Cleaning

ZIP

Feature Engineering

ZIP

Data Pre-Processing

ZIP

Dimensionality Reduction

ZIP

Missing Values Treatment

Causes and Impact of Missing Values

External Link

Types of Missing Values

External Link

When should we delete the missing values

External Link

Imputing missing values with the business logic

External Link

Imputing missing values with Mean/Median/Mode

External Link

Imputing missing values in a real-time scenario

External Link

Quiz on Missing Values Treatment

Quiz Solution on Missing Values Treatment

External Link

Outliers Treatment

How outliers can be harmful for machine learning models

External Link

Finding out outliers from the data

External Link

Using Winsorization to deal with outliers

External Link

Deleting and Capping the outliers

External Link

Dealing with outliers in a real-world scenario

External Link

Quiz on Outliers Treatment

Quiz Solution on Outliers Treatment

External Link

Data Manipulation Functions

Introduction to reindex, set_index, reset_index, and sort_index Functions

External Link

Introduction to Replace and Droplevel Function

External Link

Introduction to Split and Strip Function

External Link

Introduction to Stack, and Unstack Functions

External Link

Introduction to Melt, Explode, and Squeeze Functions

External Link

Data Cleaning on Real World Datasets

Data Cleaning on Big Mart Dataset

External Link

Data Cleaning on Movie Dataset

External Link

Data Cleaning on Melbourne Housing Dataset

External Link

Data Cleaning on Naukri Dataset

External Link

Introduction to Feature Engineering

Introduction to Feature Engineering

External Link

Removing Unnecessary Columns

External Link

Decomposing Time and Date Features

External Link

Decomposing Categorical Features

External Link

Binning Numerical Features

External Link

Aggregating features

External Link

Quiz on Feature Engineering

Quiz Solution on Feature Engineering

External Link

Feature Engineering on the Text Data

Introduction to Feature Engineering on Text Data

External Link

Reading and Summarizing the Text Data

External Link

Finding the Length, Polarity and Subjectivity

External Link

Finding the Words, Characters, and Punctuation Count

External Link

Counting Nouns and Verbs in the Text

External Link

Counting Adjectives, Adverb, and Pronouns

External Link

Quiz on Feature Engineering on the Text Data

Quiz Solution on Feature Engineering on the Text Data

External Link

Feature Engineering Functions

Introduction to Assign and Update Functions

External Link

Introduction to at_time and between_time Functions

External Link

Introduction to nlargest and nsmallest Functions

External Link

Introduction to Expanding Function

External Link

Introduction to Cumulative Functions

External Link

Feature Engineering on Real World Datasets

Feature Engineering on Employee Data

External Link

Feature Engineering on FIFA Data

External Link

Feature Engineering on Hotel Reviews

External Link

Feature Engineering on Marketing Data

External Link

Feature Engineering on Titanic Data

External Link

Dealing with Categorical data

Types of Encoding Techniques

External Link

Label Encoding

External Link

Feature Mapping for Ordinal Variables

External Link

OneHot Encoding

External Link

Binary and BaseN Encoding

External Link

Mean and Frequency Encoding

External Link

Quiz on Dealing with Categorical data

Quiz Solution on Dealing with Categorical data

External Link

Data Transformation

Introduction to Skewness and Normal Distribution

External Link

Square and Cube Root Transformation

External Link

Log transformation

External Link

Box Cox transformation

External Link

Quiz on Data Transformation

Quiz Solution on Data Transformation

External Link

Data Splitting and Feature Scaling

Train,Test and Validation Split

External Link

Standardization and Normalization

External Link

Quiz on Data Splitting and Feature Scaling

Quiz Solution on Data Splitting and Feature Scaling

External Link

Introduction to Dimensionality Reduction

Why High Dimensional Datasets are a Problem

External Link

Methods to solve the problem of High Dimensionality

External Link

Solving a Real World Problem

External Link

Quiz on Introduction

Correlation Filtering

Introduction to Correlation using Heatmap

External Link

Removing Highly Correlated Columns using Correlation

External Link

Quiz on Correlation Filtering

Feature Selection

Introduction to Recursive Feature Selection

External Link

Implementing Recursive Feature Selection

External Link

Implementing the Boruta Algorithm

External Link

Implementing the Boruta Algorithm

External Link

Quiz on Feature Selection

Machine Learning

Introduction to Principal Component Analysis

External Link

Implementing PCA

External Link

Introduction to t-SNE

External Link

Implementing t-SNE

External Link

Introduction to Linear Discriminant Analysis

External Link

Implementing LDA

External Link

Difference between PCA, t-SNE, and LDA

External Link

Quiz on Machine Learning

Introduction to ML

51 Learning Materials

Introduction to Machine Learning

How Industries are using Machine learning

External Link

Supervised Vs Unsupervised Techniques

External Link

Classification Vs Regression

External Link

Quiz on Introduction to Machine Learning

Quiz Solution on Introduction to Machine Learning

External Link

Modelling with Linear Regression

Introduction to Linear Regression

External Link

Implementing Linear Regression using sklearn

External Link

Feature Selection using RFECV

External Link

Data Transformation with Linear Regression

External Link

Applying Cross Validation

External Link

Analyzing the performance of Regression models

External Link

R2 score and adjusted R2 score intuition

External Link

MAE, RMSE, R2 and Adjusted R2 in code

External Link

Applying real time prediction on our model

External Link

Industry relevance of linear regression

External Link

Quiz on Modelling with Linear Regression

Quiz Solution on Modelling with Linear Regression

External Link

Linear Regression – Materials

ZIP

Regularization Techniques

What is Regularizationa and why is it important?

External Link

Getting the intuition of Lasso, Ridge and Elastic Net

External Link

Understanding when to apply Lasso, Ridge and Elastic Net

External Link

Applying Lasso, Ridge and Elastic Net in sklearn

External Link

Quiz on Regularization Techniques

Resources - Regularization Techniques

ZIP

Quiz Solution on Regularization Techniques

External Link

Modelling with Logistic Regression

Introduction to Logistic Regression

External Link

Implementing Logistic Regression using sklearn

External Link

Feature selection using RFECV

External Link

Hyperparameter tuning using Grid search

External Link

Applying Cross validation

External Link

How to analyze performance of a classification model

External Link

Using accuracy score to analyze the performance of model

External Link

Using ROC-AUC score to analyze the performance of model

External Link

Introduction to Clustering Analysis

Resources

ZIP

Introduction to Clustering

External Link

Types of Clustering

External Link

Applications of Clustering

External Link

Quiz on Introduction to Clustering

K Means Clustering

Using the Elbow method for choosing the best value of K

External Link

Introduction to K-Means clustering

External Link

Solving a Real World Problem

External Link

Implementing K Means on the Mall Dataset

External Link

Using Silhouette Score to analyze the clusters

External Link

Clustering Multiple Dimensions

External Link

Quiz on K Means Clustering

Advanced Clustering Techniques

Introduction to Hierarchal Clustering

External Link

Introduction to Dendrograms

External Link

Implementing Hierarchical Clustering

External Link

Introduction to DBSCAN Clustering

External Link

Implementing DBSCAN Clustering

External Link

Quiz on Advanced Clustering Techniques

Tableau & Data Visualization Bootcamp

43 Learning Materials

Creating your First Tableau Dashboard

Getting Started with Tableau

External Link

Navigating Tableau

External Link

Creating Your First Visualization

External Link

Building Your First Dashboard

External Link

Building Blocks of Data Visualization

Introduction

External Link

Dimensions and Measures

External Link

Green & Blue Pills

External Link

Measures Names & Values

External Link

Working with Time Series Data

External Link

Aggregation and Granularity

External Link

Aggregation Options

External Link

Show Me Toolbar

External Link

Marks cards & Level of Detail

External Link

Custom Shapes

External Link

Filtering Data

Ex