Data Science

Machine Learning

• Machine Learning Fundamentals
• What Is Machine Learning?
• AI / Machine Learning / Data Science
• Machine Learning Playground
• YouTube Recommendation Engine
• Types of Machine Learning
• Machine Learning — Round 2
• Machine Learning Framework
• 6-Step Machine Learning Framework
• Types of Machine Learning Problems
• Types of Data
• Types of Evaluation
• Features in Data
• Splitting Data
• Picking the Model
• Model Tuning
• Model Comparison
• Overfitting and Underfitting
• Experimentation
• Tools Used
• Elements of AI
• Python/Conda/Jupyter Environment
• Introduction to Conda
• Conda environments
• Windows environment setup
• Linux environment setup
• Mac environment setup
• Sharing Conda environments
• Jupyter Notebook
• Downloading workbooks and assignments
• 3. Pandas
• Pandas introduction
• Series
• DataFrames
• CSV files
• Reading data from URLs
• Describing data
• Selecting and viewing data
• Manipulating data
• Assignments
• 4. NumPy
• NumPy introduction
• NumPy data types and attributes
• Creating arrays
• Random seed
• Arrays and matrices
• Array manipulation
• Standard deviation
• Variance
• Reshape
• Transpose
• Dot product
• Element-wise operations
• Comparison operators
• Sorting arrays
• Images as NumPy arrays
• NumPy practice assignment
• Matplotlib & Visualization
• Matplotlib introduction
• Importing and using Matplotlib
• Anatomy of a Matplotlib figure
• Scatter plots
• Bar plots
• Histograms
• Subplots
• Visualization tips
• Plotting Pandas DataFrames
• Regular expressions
• Customizing plots
• Saving and sharing plots
• 6. Scikit-learn & Machine Learning Workflow
• Scikit-learn introduction
• ML refresher
• Scikit-learn cheatsheet
• Typical Scikit-learn workflow
• Train/test splitting
• Data cleaning
• Data transformation
• Data reduction
• Converting data to numbers
• Missing-value handling
• Feature scaling
• Choosing the right model
• Regression
• Classification
• Decision trees
• Fitting models
• Making predictions
• predict() vs predict_proba()
• 7. Model Evaluation
• Cross-validation
• Accuracy
• ROC curve
• ROC-AUC
• Confusion matrix
• Classification report
• R²
• MAE
• MSE
• Model evaluation
• Cross-validation with scoring parameters
• Scikit-learn evaluation functions
• Correlation analysis
• 8. Model Improvement
• Improving ML models
• Hyperparameter tuning
• Metric comparison
• Saving and loading models
• Complete ML workflow
• Scikit-learn practice
• 9. Machine Learning Projects
• Project environment setup
• Framework setup
• Data exploration
• Finding patterns
• Data preparation
• Choosing models
• Experimentation
• Model tuning
• Hyperparameter tuning
• Model evaluation
• Feature importance
• Feature engineering
• Numerical missing values
• Categorical missing values
• RandomizedSearchCV
• Preprocessing
• Making predictions

Deep Learning

• Deep Learning with TensorFlow
• Google Colab
• GPU usage
• TensorFlow 2
• Loading data labels
• Image preparation
• Converting labels into numbers
• Validation sets
• Image preprocessing
• Batching
• Data visualization
• Inputs and outputs
• How machines learn
• Building a deep learning model
• Model summary
• Model evaluation
• Overfitting prevention
• Training neural networks
• TensorBoard
• Making predictions
• Transforming predictions to text
• Visualizing predictions
• Saving/loading trained models
• Training on full dataset
• Test-image predictions
• Kaggle submission
• Predictions on custom images
• Completing Dog Vision project

Excel with AI

PowerBI

• What is Power BI?
• All Files for Download
• How to Install Power BI Desktop: Step-by-Step Guide for Beginners
• Data and Creating Your First Visualization
• The Interface
• Important: Configuring Initial Project Settings
• How to Connect and Load CSV Data in Power BI
• Our Project: How to Create a Comprehensive Sales Report in Power BI
• How to Use Power Query Editor for Data Transformation in Power BI
• The Query Editor
• How to Fix Data Source Errors in Power BI: Troubleshooting Missing File Paths
• Power BI Data Transformation: Using Remove Rows and Choose Columns Features
• Power BI Query Editor: Changing Column Data Types for Accurate Analysis
• How to Change Data Types in Power BI Using Locales
• Data Types, Replace & Edit rows
• Power BI Data Cleaning: Replace Text and Change Column Data Types Step-by-Step
• Summary: Query Editor and Transform Data in Power BI
• Effective Visualizations and Data Transformations
• How to Extract Values in Power BI: Data Transformation Techniques for Analysis
• Optimizing Data Preparation: Using Split Column Tools in Power BI Query Editor
• How to Clean and Transform Text Data in Power BI Query Editor
• Power Query Data Cleaning: Numerical Transformations in Power BI
• Power BI Data Model Essentials: Building Efficient Relationships for Dashboards
• Practice: Data Cleaning & Relationship
• Solution: Data Cleaning & Relationship
• Solution: How to Create and Fix Relationships in Power BI Data Models
• Power BI Visualization Techniques: Mastering Stacked Column Charts and Legends
• Power BI Formatting: Mastering the Format Pane for Enhanced Visualizations
• How to Use Data Labels in Power BI Charts: Stacked Column and Pie Visualizations
• How to Use Pie Charts Effectively in Power BI: Best Practices and Alternatives
• How to Create and Format a Pie Chart in Power BI
• Combining Data and Data Modelling in Power BI
• How to Append Queries in Power BI: Combining Data from Multiple Tables
• How to Group and Manage Queries in Power BI: Organizing Your Data Sources
• How to Hide Tables in Power BI: Improving User Experience in Report View
• How to Use Date Hierarchy in Power BI Line Charts for Time-Based Visualizations
• How to Use Drill Down Mode in Power BI: Beyond Date Hierarchies
• How to Create and Customize Line Charts in Power BI
• How to Combine Multiple Files from a Folder in Power BI
• How to Create a Fact-Dimension Model in Power BI: Star Schema Explained
• Fact-Dimension model
• Understanding Cardinality in Power BI: Mastering Many-to-One Relationships
• How to Manage Active and Inactive Relationships in Power BI Data Models
• How to Manage Relationships in Power BI: Autodetect & Data Model Best Practices
• Power BI Table Visualization: Tips for Effective Data Presentation
• How to Format Tables in Power BI: Customizing Styles & Colors for Visualizations
• How to Use Conditional Formatting Rules in Power BI for Data Visualization
• Mastering Data Integration: Merge Queries for Comprehensive Dashboards
• Power BI Data Transformation: Mastering Pivot & Unpivot Techniques for Analytics
• Mastering Power BI Relationships: From One-to-Many to Many-to-Many Connections
• How to Use Power BI Slicers: A Comprehensive Guide to Filtering Data Effectively
• How to Design Professional Power BI Reports: Formatting Canvas and Wallpaper
• Mastering Power BI Filters: Basic and Advanced Filtering Options Explained
• Advanced Power BI Filtering Techniques: Top N, Visual-Level, and Date Filters
• Mastering Power BI Slicer Sync: Advanced Techniques for Data Filtering
• Mastering Tree map Visuals in Power BI: Alternatives to Bar and Pie Charts
• Power BI Edit Interactions: Mastering Cross-Filtering Between Visuals
• Power BI Drill Through : Enhancing Dashboard Interactivity and Analysis
• Mastering Power BI Tooltips: Enhance Your Data Visualization with Custom Info
• Using M Language: Creating Custom Columns for Advanced Data Manipulation
• How to Enable and Disable Load in Power BI Data Models for Better Performance
• Power BI Query Management: Differences Between Duplicates and References
• How to Use Power BI Columns from Examples for Efficient Data Transformation
• Optimizing Power BI Charts: Sorting Weekdays for Effective Data Visualization
• How to Create a Conditional Column in Power BI for Weekday Sorting
• How to Create Interactive Map Visualizations in Power BI for Data Analysis
• How to Use Power BI Filled Maps for Effective Data Filtering and Visualization
• Power BI Line Charts: Adding Forecasts and Trend Lines for Advanced Analytics
• How to Use Power BI Anomaly Detection: Find Outliers in Time Series Data
• How to Create Interactive Drill through Buttons in Power BI for Better Navigation
• How to Use Clear and Apply Slicer Buttons in Power BI for Efficient Filtering
• Creating User-Friendly Buttons in Power BI: Tooltips, Transparency, and Actions
• How to Create and Use Bookmarks in Power BI: A Step-by-Step Guide
• Challenge: Building Interactive Top N Filters with Buttons and Bookmarks
• Solution: Building Interactive Top N Filters with Buttons and Bookmarks
• Mastering Power BI Card Visual: Customize and Format for Impactful Dashboards
• How to Use Multi-Row Cards in Power BI
• How to Create Custom Tooltips in Power BI: Displaying Report Pages as Visuals
• Power BI Theme Gallery: Finding and Importing Custom Themes for Better Reports
• How to Create Calculated Columns in DAX: Power BI Data Model Enhancement
• Power BI Measures vs Calculated Columns: Key Differences in DAX Calculations
• How to Use DAX Average Function in Power BI: Mastering Calculated Measures
• Create a Measure Table in Power BI: Organizing DAX Calculations Efficiently
• DAX Basics: Understanding COUNT, COUNTROWS, and DISTINCTCOUNT in DAX
• Mastering SUMX and AVERAGEX: Iterative Functions in DAX for Power BI
• Mastering Row-Based Functions in DAX: SUMX & AVERAGEX for Power BI Calculations
• Power BI DAX Essentials: Rounding Numbers with Precision in Calculated Columns
• DAX Essentials: Understanding Row Context and RELATED Function in Power BI
• DAX Filter Context Explained: Mastering CALCULATE Function
• How to Use the FILTER Function in DAX: Advanced Power BI Calculations Explained
• Master DAX Logical Operators: Advanced Filtering Techniques in Power BI
• DAX Challenges
• Advanced DAX Techniques: Overcoming Filter Context with ALL Function in Power BI
• Advanced DAX Techniques: Optimizing Percentage Calculations with ALL Function
• How to Use ALLEXCEPT Function in DAX: Advanced Power BI Filtering Techniques
• How to Use ALLSELECTED Function in DAX: Advanced Power BI Filtering Techniques
• How to Use DATEADD Function in DAX for Time Intelligence in Power BI
• Mastering Running Totals with DAX: Year-to-Date and Quarter-to-Date in Power BI
• How to Use DAX FORMAT Function in Power BI for Custom Date Formatting
• Power BI Time Intelligence: Building a Date Table with DAX and ADDCOLUMNS
• Complete Date Table with features
• Mastering DAX in Power BI: Using ChatGPT for Measures and Calculated Columns
• Optimizing Power BI Reports with ChatGPT: Advanced DAX Measure Techniques

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