Data Analytics Master's Program

·     Introduction to Excel spreadsheet

·     Learning to enter data

·     Flling of series and custom fill list

·     Editing and deleting fields

·     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 colour scales

·     Creating and modifying Sparkline

·     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, Sum IF & Sum IFs

·     Count, Count A, Count IF and Count Blank

·     Network days, Network days International

·     Today & Now function

·     Trim (Eliminating undesirable spaces)

·     Concatenate (Consolidating columns)

·     Practical Exercise

·     Lecture-8 Working with Dynamic table

·     Introduction to dynamic table in Excel

·     Data conversion

·     Table conversion

·     Tables for charts

·     VLOOKUP

·     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 variant Analysis

·     Dependence and Independence tests ( Chi-Square )

·     Analysis of Variance

·     Correlation between Nominal variables

·     Practical Exercise

·     Different Sectors Using Data Science

·     The Purpose and Components of Python

·     The Data Analytics Process

·     Exploratory the Data Analysis (EDA)

·     EDA-Quantitative Technique

·     EDA - Graphical Technique

·     The Data Analytics Conclusion or Predictions

·     The Data Analytics Communication

·     The Data Types for Plotting

·     Practical Exercise

·     Introduction to the Statistics

·     About Statistical and Non-statistical Analysis

·     The Major Categories of Statistics

·     About the Statistical Analysis Considerations

·     The Population and Sample

·     What is the Statistical Analysis Process?

·     The Data Distribution

·     Dispersion

·     Practical Exercise

·     The Companies using Python

·     Different Applications where Python is used

·     Discuss Python Scripts on UNIX/Windows

·     Values, Types, Variables

·     Operands and Expressions

·     Conditional Statements

·     Loops

·     Command Line Arguments

·     Writing to the screen

·     Practical Exercise

·     Python files I/O Functions

·     Numbers

·     Strings and related operations

·     Tuples and related operations

·     Lists and related operations

·     Dictionaries and related operations

·     Sets and related operations

·     Practical Exercise

·     Functions

·     Function Parameters

·     Global Variables

·     Variable Scope and Returning Values

·     Lambda Functions

·     Object-Oriented Concepts

·     Standard Libraries

·     Modules Used in Python

·     The Import Statements

·     Module Search Path

·     Package Installation Ways

·     Errors and Exception Handling

·     Handling Multiple Exceptions

·     Practical Exercise

·     Introduction To Statistic

·     Distributions and Hypothesis Tests

·     Distributions of One Variable

·     Hypothesis Testing

·     Typical Analysis Procedure

·     Data Screening and Outliers

·     Normality Check

·     Hypothesis Concept

·     Errors

·     p-Value

·     Sample Size

·     Chi Square

·     ANOVA

·     Practical Exercise

·     Pandas Introduction

·     Series

·     Data Frames

·     CSVs

·     Data from URLs

·     Describing Data with Pandas

·     Selecting and Viewing Data with Pandas

·     Manipulating Data

·     Practical Exercise

·     NumPy Introduction

·     NumPy Data Types 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

·     Introduction to the SciPy

·     About the SciPy Sub Package - Integration and Optimization

·     What is SciPy sub package?

·     Know About the SciPy Sub Package - Statistics, Weave & IO

·     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

·     Jupiter 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 Cheat sheet

·     Typical Scikit-learn Workflow

·     Debugging Warnings In Jupiter

·     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

·     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

·     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

·     Introduction to Natural Language Processing (NLP)

·     Introduction to text mining

·     Importance and applications of text mining

·     How NLP works with text mining

·     Writing and reading to word files

·     OS modules

·     Natural Language Toolkit (NLTK) environment & text mining

·     Principal Component Analysis (PCA)

·     Practical Exercise