DSA - Semester 2
Course Curriculum
5 Subjects
Data Analysis and Visualization
211 Learning Materials
Resources
Interactive Visualizations
Tableau Functions Workbook
Dates and Times
Quiz Solution on Dates and Times
Exercise on Date and Time
Solution on Date and Time
Regular Expressions
Meta Characters for Regular Expressions
Built-in Functions for Regular Expressions
Special Characters for Regular Expressions
Sets for Regular Expressions
Quiz on Regular Expressions
Quiz Solution on Regular Expressions
Exercise on Regular Expressions
Solution on Regular Expressions
Introduction to Numpy
Array Creation using Numpy
Mathematical Operations using Numpy
Built-in Functions in Numpy
Quiz on Introduction to Numpy
Quiz Solution on Introduction to Numpy
Exercise on Built-in Functions in Numpy
Exercise on Mathematical Operations using Numpy
Solution on Mathematical Operations using Numpy
Introduction to Pandas
Reading Datasets using Pandas
Indexing, Selecting, and Filtering Data using Pandas
Merging and Concatenating DataFrames
Lambda, Map, and Apply Functions
Quiz on Introduction to Pandas
Quiz Solution on Introduction to Pandas
Exercise on Pandas Plotting
Solution on Pandas Plotting
Exercise on Indexing and Selecting
Solution on Indexing and Selecting
Exercise on Merging and Concatenating
Solution on Merging and Concatenating
Exercise on Apply Functions
Solution on Apply Functions
Introduction to Data Exploration
Quiz on Introduction to EDA
Quiz Solution on Introduction to EDA
Examining Data
Exploring the Dabl Library
Exploring the Sweetviz Library
Using Color Gradients for better analysis
Best Practices for Data Exploration
Quiz Solution on Examining Data
Grouping Operations
Aggregate functions used for Grouping
Using Groupby for Grouping Operations
Groupby with Idxmax and Idxmin functions
Using Color scales for better visualization
Visualizing the Groupby Operations
Using Pivot Tables for Grouping Operations
Difference between Groupby and Pivot tables
Performing Cross Tabulation
Visualizing Cross tabulated Data
Interactive Grouping Operations
Quiz on Grouping Operations
Quiz Solution on Grouping Operations
Filtering Operations
When to perform Filtering Operations
Introduction to Simple Filtering Operations
Advanced Filtering Operations
Filtering and Grouping Operations
Interactive Filtering Operations
Quiz on Filtering Operations
Quiz Solution on Filtering Operations
Basics of Visualization
Quiz on Basics of Visualization
Quiz Solution on Basics of Visualization
Advanced Visualizations
Bar, Line, and Area Charts
Quiz on Advanced Visualizations
Quiz Solution on Advanced Visualizations
Animated Visualizations
Animation with Bubbleplot
Animation with Scatter Maps
Animation with Choropleth Maps
Quiz on Animated Visualizations
Quiz Solution on Animated Visualizations
Interactive Visualizations
Introduction to Ipywidgets
Interactive Univariate Analysis
Interactive Bivariate Analysis
Interactive Multivariate Analysis
Quiz on Interactive Visualizations
Quiz Solution on Interactive Visualizations
Miscellaneous Charts
Parallel Co-ordinate Charts
Quiz on Miscellaneous Charts
Quiz Solution on Miscellaneous Charts
Tableau Functions
Getting Started with Calculations
Gantt Charts using Date Functions
Quiz on Tableau Functions
Table Calculations
Table Calculation - Part 1
Table Calculations - Part 2
Conditional Highlighting using Windows Functions
Secondary Calculations with Pareto Chart
Level of Detail (LOD) Expression
Resources - Global Superstore
Introduction to Level of Details
FIXED - Level of Detail Expression
Customer Retention Analysis
Removing Duplicate Records in Tableau using FIXED
INCLUDE - Level of Detail Expression
EXCLUDE - Level of Detail Expression
Table Scoped Level of Detail Expression
Finding a Dimension at Lower Level
Sparklines with Min Max Indicator
Parameters in Tableau
Resources Parameters Workbook
Advanced Parameters Part - 1
Advanced Parameters Part - 2
Quiz on Parameters in Tableau
Introduction to Data Preparations
Resources Data Preparation Datasets
Resources Data Preparation Workbooks
Managing Metadata and Data Types
Data Preparation and Cleaning
Filtering of Rows using Data Source Filters
How to do Blending in Tableau?
Data Blending (Additional)
Quiz on Data Preparations
Slicing & Dicing Data in Tableau
Resources Slicing & Dicing Datasets
Resources Slicing & Dicing Workbook
Quiz on Slicing and Dicing Data in Tableau
Tableau Maps
Resources Superstore_dataset
Resources Tableau Maps Workbook
Working with Web Map Service (WMS)
Dashboards
Resources shark-data-cleaned
Resources Dashboards Workbook
Building Blocks of Dashboard - Part 1
Building Blocks of Dashboard - Part 2
Building Blocks of Dashboard - Part 3
Data Cleaning and Preparation
92 Learning Materials
Missing Values Treatment
Causes and Impact of Missing Values
When should we delete the missing values
Imputing missing values with the business logic
Imputing missing values with Mean/Median/Mode
Imputing missing values in a real-time scenario
Quiz on Missing Values Treatment
Quiz Solution on Missing Values Treatment
Outliers Treatment
How outliers can be harmful for machine learning models
Finding out outliers from the data
Using Winsorization to deal with outliers
Deleting and Capping the outliers
Dealing with outliers in a real-world scenario
Quiz on Outliers Treatment
Quiz Solution on Outliers Treatment
Data Manipulation Functions
Introduction to reindex, set_index, reset_index, and sort_index Functions
Introduction to Replace and Droplevel Function
Introduction to Split and Strip Function
Introduction to Stack, and Unstack Functions
Introduction to Melt, Explode, and Squeeze Functions
Data Cleaning on Real World Datasets
Data Cleaning on Big Mart Dataset
Data Cleaning on Movie Dataset
Data Cleaning on Melbourne Housing Dataset
Data Cleaning on Naukri Dataset
Introduction to Feature Engineering
Introduction to Feature Engineering
Removing Unnecessary Columns
Decomposing Time and Date Features
Decomposing Categorical Features
Binning Numerical Features
Quiz on Feature Engineering
Quiz Solution on Feature Engineering
Feature Engineering on the Text Data
Introduction to Feature Engineering on Text Data
Reading and Summarizing the Text Data
Finding the Length, Polarity and Subjectivity
Finding the Words, Characters, and Punctuation Count
Counting Nouns and Verbs in the Text
Counting Adjectives, Adverb, and Pronouns
Quiz on Feature Engineering on the Text Data
Quiz Solution on Feature Engineering on the Text Data
Feature Engineering Functions
Introduction to Assign and Update Functions
Introduction to at_time and between_time Functions
Introduction to nlargest and nsmallest Functions
Introduction to Expanding Function
Introduction to Cumulative Functions
Feature Engineering on Real World Datasets
Feature Engineering on Employee Data
Feature Engineering on FIFA Data
Feature Engineering on Hotel Reviews
Feature Engineering on Marketing Data
Feature Engineering on Titanic Data
Dealing with Categorical data
Types of Encoding Techniques
Feature Mapping for Ordinal Variables
Binary and BaseN Encoding
Mean and Frequency Encoding
Quiz on Dealing with Categorical data
Quiz Solution on Dealing with Categorical data
Data Transformation
Introduction to Skewness and Normal Distribution
Square and Cube Root Transformation
Quiz on Data Transformation
Quiz Solution on Data Transformation
Data Splitting and Feature Scaling
Train,Test and Validation Split
Standardization and Normalization
Quiz on Data Splitting and Feature Scaling
Quiz Solution on Data Splitting and Feature Scaling
Introduction to Dimensionality Reduction
Why High Dimensional Datasets are a Problem
Methods to solve the problem of High Dimensionality
Solving a Real World Problem
Correlation Filtering
Introduction to Correlation using Heatmap
Removing Highly Correlated Columns using Correlation
Quiz on Correlation Filtering
Feature Selection
Introduction to Recursive Feature Selection
Implementing Recursive Feature Selection
Implementing the Boruta Algorithm
Implementing the Boruta Algorithm
Quiz on Feature Selection
Machine Learning
Introduction to Principal Component Analysis
Introduction to Linear Discriminant Analysis
Difference between PCA, t-SNE, and LDA
Introduction to ML
51 Learning Materials
Introduction to Machine Learning
How Industries are using Machine learning
Supervised Vs Unsupervised Techniques
Classification Vs Regression
Quiz on Introduction to Machine Learning
Quiz Solution on Introduction to Machine Learning
Modelling with Linear Regression
Introduction to Linear Regression
Implementing Linear Regression using sklearn
Feature Selection using RFECV
Data Transformation with Linear Regression
Applying Cross Validation
Analyzing the performance of Regression models
R2 score and adjusted R2 score intuition
MAE, RMSE, R2 and Adjusted R2 in code
Applying real time prediction on our model
Industry relevance of linear regression
Quiz on Modelling with Linear Regression
Quiz Solution on Modelling with Linear Regression
Linear Regression – Materials
Regularization Techniques
What is Regularizationa and why is it important?
Getting the intuition of Lasso, Ridge and Elastic Net
Understanding when to apply Lasso, Ridge and Elastic Net
Applying Lasso, Ridge and Elastic Net in sklearn
Quiz on Regularization Techniques
Resources - Regularization Techniques
Quiz Solution on Regularization Techniques
Modelling with Logistic Regression
Introduction to Logistic Regression
Implementing Logistic Regression using sklearn
Feature selection using RFECV
Hyperparameter tuning using Grid search
Applying Cross validation
How to analyze performance of a classification model
Using accuracy score to analyze the performance of model
Using ROC-AUC score to analyze the performance of model
Introduction to Clustering Analysis
Introduction to Clustering
Applications of Clustering
Quiz on Introduction to Clustering
K Means Clustering
Using the Elbow method for choosing the best value of K
Introduction to K-Means clustering
Solving a Real World Problem
Implementing K Means on the Mall Dataset
Using Silhouette Score to analyze the clusters
Clustering Multiple Dimensions
Quiz on K Means Clustering
Advanced Clustering Techniques
Introduction to Hierarchal Clustering
Introduction to Dendrograms
Implementing Hierarchical Clustering
Introduction to DBSCAN Clustering
Implementing DBSCAN Clustering
Quiz on Advanced Clustering Techniques
Tableau & Data Visualization Bootcamp
43 Learning Materials
Creating your First Tableau Dashboard
Getting Started with Tableau
Creating Your First Visualization
Building Your First Dashboard
Building Blocks of Data Visualization
Working with Time Series Data
Aggregation and Granularity
Marks cards & Level of Detail