Data Science Master's Program

·      Introduction to Excel spreadsheet

·      Learning to enter data

·      Flling of series and custom fill list

·      Editing and deleting field

·      Practical Exercise              

·      Learning about relative and absolute referencing

·      The concept of relative formulae

·      The issues in relative formulae

·      Creating of absolute and mixed references

·      Practical Exercise              

·      Creating names range

·      Using names in new formulae

·      Working with the name box

·      Selecting range

·      Names from a selection

·      Pasting names in formulae

·      Selecting names

·      Working with Name Manager

·      Practical Exercise              

·      The various logical functions in Excel

·      The If function for calculating values and displaying text

·      Nested If functions

·      VLookUp and IFError functions

·      Practical Exercise              

·      Learning about conditional formatting

·      The options for formatting cells

·      Various operations with icon sets

·      Data bars and color scales

·      Creating and modifying sparklines

·      Practical Exercise              

·      Multi-level drop down validation

·      Restricting value from list only

·      Learning about error messages and cell drop down

·      Practical Exercise              

·      Introduction to the various formulae in Excel

·      Sum, SumIF & SumIFs

·      Count, CountA, CountIF and CountBlank

·      Networkdays, Networkdays International

·      Today & Now function

·      Trim (Eliminating undesirable spaces)

·      Concatenate (Consolidating columns)

·      Practical Exercise              

·      Introduction to dynamic table in Excel

·      Data conversion

·      Table conversion

·      Tables for charts

·      VLOOKUP

·      Practical Exercise              

·      Sorting in Excel

·      Various types of sorting

·      Alphabetical

·      Numerical

·      Row

·      Multiple column

·      Working with paste special

·      Hyperlinking

·      Using subtotal

·      Practical Exercise              

·      The concept of data filtering

·      Understanding compound filter and its creation

·      Removing of filter

·      Using custom filter and multiple value filters

·      Working with wildcards

·      Practical Exercise              

·      Creation of Charts in Excel

·      Performing operations in embedded chart

·      Modifying

·      Resizing

·      Dragging of chart

·      Practical Exercise              

·      Introduction to the various types of charting techniques

·      Creating titles for charts

·      Axes

·      Learning about data labels

·      Displaying data tables

·      Modifying axes

·      Displaying gridlines and inserting trendlines

·      Textbox insertion in a chart

·      Creating a 2-axis chart

·      Creating combination chart

·      Practical Exercise              

·      The concept of Pivot tables in Excel

·      Report filtering

·      Shell creation

·      Working with Pivot for calculations

·      Formatting of reports

·      Dynamic range assigning

·      The slicers

·      Creating of slicers

·      Practical Exercise              

·      Data and file security in Excel

·      Protecting row, column, and cell

·      Different safeguarding techniques

·      Practical Exercise              

·      Learning about VBA macros in Excel

·      Executing macros in Excel

·      The macro shortcuts

·      Applications

·      The concept of relative reference in macros

·      Practical Exercise              

·      In-depth understanding of Visual Basic for Applications

·      The VBA Editor

·      Module insertion and deletion

·      Performing action with Sub

·      Ending Sub if condition not met

·      Practical Exercise              

·      Learning about the concepts of workbooks & worksheets in Excel Protection of macro codes

·      Range coding

·      Declaring a variable

·      The concept of Pivot Table in VBA

·      Introduction to arrays

·      User forms

·      Getting to know how to work with databases within Excel

·      Practical Exercise              

·      Learning how the If condition works

·      How to apply it in various scenarios

·      Working with multiple Ifs in Macro

·      Practical Exercise              

·      Understanding the concept of looping

·      Deploying looping in VBA Macros

·      Practical Exercise              

·      Studying about debugging in VBA

·      The various steps of debugging

·      Understanding breakpoints and way to mark it

·      The code for debugging and code commenting

·      Practical Exercise              

·      The concept of message box in VBA

·      Learning to create the message box

·      Various types of message boxes

·      The IF condition as related to message boxes

·      Practical Exercise              

·      Mastering the various tasks and functions using VBA

·      Understanding data separation

·      Auto filtering

·      Formatting of report

·      Combining multiple sheets into one

·      Merging multiple files together

·      Practical Exercise              

·      Introduction to powerful data visualization with Excel Dashboard

·      Loading the data

·      Managing data and linking the data to tables and charts

·      Creating Reports using dashboard features

·      Practical Exercise              

·      Learning to create charts in Excel

·      The various charts available

·      The steps to successfully build a chart

·      Personalization of charts

·      Formatting and updating features

·      Various special charts for Excel dashboards

·      Understanding how to choose the right chart for the right data

·      Practical Exercise              

·      Creation of Pivot Tables in Excel

·      Learning to change the Pivot Table layout

·      Generating Reports

·      The methodology of grouping and ungrouping of data

·      Practical Exercise              

·      Learning to create Dashboards

·      The various rules to follow while creating Dashboards

·      Creation of dynamic dashboards

·      Knowing what is data layout

·      Introduction to thermometer chart and its creation

·      How to use alerts in the Dashboard setup

·      Practical Exercise              

·      How to insert a Scroll bar to a data window

·      Concept of Option buttons in a chart

·      Use of combo box drop-down

·      List box control Usage

·      How to use Checkbox Control

·      Practical Exercise              

·      Understanding data quality issues in Excel

·      Linking of data

·      Consolidating and merging data

·      Working with dashboards for Excel Pivot Tables

·      Practical Exercise              

·      What is statistics?

·      How is this useful

·      What is this course for

·      Practical Exercise              

·      Converting data into useful information

·      Collecting the data

·      Understand the data

·      Finding useful information in the data

·      Interpreting the data

·      Visualizing the data

·      Practical Exercise              

·      Descriptive statistics

·      Let us understand some terms in statistics

·      Variable

·      Practical Exercise              

·      Dot Plots

·      Histogram

·      Stemplots

·      Box and whisker plots

·      Outlier detection from box plots and Box and whisker plots

·      Practical Exercise              

·      What is probability?

·      Set & rules of probability

·      Bayes Theorem

·      Practical Exercise              

·      Probability Distributions

·      Few Examples

·      Student T- Distribution

·      Sampling Distribution

·      Student t- Distribution

·      Poison distribution

·      Practical Exercise              

·      Stratified Sampling

·      Proportionate Sampling

·      Systematic Sampling

·      P – Value

·      Stratified Sampling

·      Practical Exercise              

·      Cross Tables

·      Bivariate Analysis

·      Multi variate Analysis

·      Dependence and Independence tests ( Chi-Square )

·      Analysis of Variance

·      Correlation between Nominal variables

·      Practical Exercise              

·      Python Environment Setup and Essentials

·      The Installation of Anaconda Python Distribution

·      What Is A Programming Language

·      Python Interpreter

·      How To Run Python Code

·      Our First Python Program

·      Learning Python

·      Python Data Types

·      Numbers

·      Math Functions

·      Operator Precedence

·      Optional: bin() and complex

·      Variables

·      Expressions vs Statements

·      Augmented Assignment Operator

·      Strings

·      String Concatenation

·      Type Conversion

·      Escape Sequences

·      Formatted Strings

·      String Indexes

·      Immutability

·      Built-In Functions + Methods

·      Booleans

·      Lists

·      List Slicing

·      Matrix

·      List Methods

·      Common List Patterns

·      List Unpacking

·      Dictionaries

·      Practical Exercise              

·      Pandas Introduction

·      Series, Data Frames and CSVs

·      Data from URLs

·      Describing Data with Pandas

·      Selecting and Viewing Data with Pandas

·      Manipulating Data

·      Practical Exercise              

·      Mathematical Computing with Python (NumPy)

·      NumPy Introduction

·      NumPy DataTypes and Attributes

·      Creating NumPy Arrays

·      NumPy Random Seed

·      Viewing Arrays and Matrices

·      Manipulating Arrays

·      Standard Deviation and Variance

·      Reshape and Transpose

·      Dot Product vs Element Wise

·      Store Sales

·      Comparison Operators

·      Sorting Arrays

·      Turn Images Into NumPy Arrays

·      Practical Exercise              

·      What Is Machine Learning?

·      AI/Machine Learning/Data Science

·      Practical Exercise              

·      Machine Learning Framework

·      Types of Machine Learning

·      Types of Data

·      Types of Evaluation

·      Features In Data

·      Modelling - Splitting Data

·      Modelling - Picking the Model

·      Modelling - Tuning

·      Modelling – Comparison

·      Practical Exercise              

·      Introducing Our Tools

·      Windows Environment Setup

·      Linux Environment Setup

·      Jupyter Notebook Walkthrough

·      Practical Exercise              

·      Matplotlib Introduction

·      Importing And Using Matplotlib

·      Anatomy Of A Matplotlib Figure

·      Scatter Plot And Bar Plot

·      Histograms And Subplots

·      Subplots Option 2

·      Plotting From Pandas DataFrames

·      Customizing Your Plots

·      Saving And Sharing Your Plots

·      Practical Exercise              

·      Scikit-learn Introduction

·      Scikit-learn Cheatsheet

·      Typical scikit-learn Workflow

·      Debugging Warnings In Jupyter

·      Splitting Your Data

·      Clean, Transform, Reduce

·      Convert Data To Numbers

·      Handling Missing Values With Pandas

·      Handling Missing Values With Scikit-learn

·      Choosing The Right Model For Your Data

·      Practical Exercise              

·      Types of Regression Algorithms

·      Simple Linear Regression

·      Multiple Linear Regression

·      Logistic Regression

·      Polynomial Regression

·      Support Vector Regression

·      Ridge Regression

·      Lasso Regression

·      ElasticNet Regression

·      Bayesian Regression

·      Decision Tree Regression

·      Random Forest Regression

·      Practical Exercise              

·      Types of Classification Algorithms

·      Logistic Regression/Classification

·      K-Nearest Neighbours

·      Support Vector Machines

·      Kernel Support Vector Machines

·      Naive Bayes

·      Decision Tree Classification

·      Random Forest Classification

·      Case Studies

·      Practical Exercise              

·      K-Means Clustering

·      A Simple Example of Clustering

·      Clustering Categorical Data

·      How to Choose the Number of Clusters

·      Pros and Cons of K-Means Clustering

·      To Standardize or not to Standardize

·      Relationship between Clustering and Regression

·      Market Segmentation with Cluster Analysis

·      Market Segmentation with Cluster Analysis

·      Species Segmentation with Cluster Analysis

·      Advanced Statistical Methods - Other Types of Clustering

·      Types of Clustering

·      Dendrogram

·      Heatmaps

·      Practical Exercise              

·      The concepts of text-mining

·      Use cases

·      Text Mining Algorithms

·      Quantifying text

·      TF-IDF

·      Beyond TF-IDF

·      Practical Exercise              

·      What is time series?

·      Techniques and applications

·      Time series components

·      Moving average

·      Smoothing techniques

·      Exponential smoothing

·      Univariate time series models

·      Multivariate time series analysis

·      Sentiment analysis in Python (Twitter sentiment analysis)

·      Text analysis

·      Rolling Mean For Detecting Temporal Variation

·      Simple Exponential Smoothing (SES)

·      Holt extended simple exponential smoothing

·      Holt Winters

·      Auto Regression Model (AR): Consider Previous Time Steps

·      Implement a Basic ARIMA Model

·      Automated ARIMA & Account for Seasonality (SARIMA)

·      Practical Exercise              

·      Primer

·      Measurement

·      Assumptions

·      Applied PCA work flow

·      Analysis of performance

·      Dimensionality reduction with (PCA)

·      Practical Exercise