DATA ANALYTICS COURSE IN LUDHIANA

MODULE 1: DATA ANALYSIS FOUNDATION

• Data Analysis Introduction
• Data Preparation for Analysis
• Common Data Problems
• Various Tools for Data Analysis
• Evolution of Analytics domain

MODULE 2: CLASSIFICATION OF ANALYTICS

• Four types of the Analytics
• Descriptive Analytics
• Diagnostics Analytics
• Predictive Analytics
• Prescriptive Analytics
• Human Input in Various type of Analytics

MODULE 3: CRIP-DM Model

• Introduction to CRIP-DM Model
• Business Understanding
• Data Understanding
• Data Preparation
• Modeling
• Evaluation
• Deploying
• Monitoring

MODULE 4: UNIVARIATE DATA ANALYSIS

• Summary statistics -Determines the value’s center and spread.
• Measure of Central Tendencies: Mean, Median and Mode
• Measures of Variability: Range, Interquartile range, Variance and Standard Deviation
• Frequency table -This shows how frequently various values occur.
• Charts -A visual representation of the distribution of values.

MODULE 5: DATA ANALYSIS WITH VISUAL CHARTS

• Line Chart
• Column/Bar Chart
• Waterfall Chart
• Tree Map Chart
• Box Plot

MODULE 6: BI-VARIATE DATA ANALYSIS

• Scatter Plots
• Regression Analysis
• Correlation Coefficients

MODULE 1: PYTHON BASICS

• Introduction of python
• Installation of Python and IDE
• Python objects
• Python basic data types
• Number & Booleans, strings
• Arithmetic Operators
• Comparison Operators
• Assignment Operators
• Operator’s precedence and associativity

MODULE 2: PYTHON CONTROL STATEMENTS

• IF Conditional statement
• IF-ELSE
• NESTED IF
• Python Loops basics
• WHILE Statement
• FOR statements
• BREAK and CONTINUE statements

MODULE 3: PYTHON DATA STRUCTURES

• Basic data structure in python
• String object basics and inbuilt methods
• List: Object, methods, comprehensions
• Tuple: Object, methods, comprehensions
• Sets: Object, methods, comprehensions
• Dictionary: Object, methods, comprehensions

MODULE 4: PYTHON FUNCTIONS

• Functions basics
• Function Parameter passing
• Iterators
• Generator functions
• Lambda functions
• Map, reduce, filter functions

MODULE 5: PYTHON NUMPY PACKAGE

• NumPy Introduction
• Array – Data Structure
• Core Numpy functions
• Matrix Operations

MODULE 6: PYTHON PANDAS PACKAGE

• Pandas functions
• Data Frame and Series – Data Structure
• Data munging with Pandas
• Imputation and outlier analysis

MODULE 1 : OVERVIEW OF STATISTICS 

• Descriptive And Inferential Statistics
• Basic Terms Of Statistics
• Types Of Data
  

MODULE 2 : HARNESSING DATA 

• Random Sampling
• Sampling With Replacement And Without Replacement
• Cochran's  Minimum Sample Size
• Simple Random Sampling
• Stratified Random Sampling
• Cluster Random Sampling
• Systematic Random Sampling
• Biased Random Sampling Methods
• Sampling Error
• Methods Of Collecting Data
  

MODULE 3 : EXPLORATORY DATA ANALYSIS 

• Exploratory Data Analysis Introduction
• Measures Of Central Tendencies: Mean, Median And Mode
• Measures Of Central Tendencies: Range, Variance And Standard Deviation
• Data Distribution Plot: Histogram
• Normal Distribution
• Z Value / Standard Value
• Empherical Rule  and Outliers
• Central Limit Theorem
• Normality Testing
• Skewness & Kurtosis
• Measures Of Distance: Euclidean, Manhattan And MinkowskiDistance
  

MODULE 4 : HYPOTHESIS TESTING 

• Hypothesis Testing Introduction
• P- Value, Confidence Interval
• Parametric Hypothesis Testing Methods
• Hypothesis Testing Errors : Type I And Type Ii
• One Sample T-test
• Two Sample Independent T-test
• Two Sample Relation T-test
• One Way Anova Test
  

MODULE 5 : CORRELATION AND REGRESSION

• Correlation Introduction
• Direct/Positive Correlation
• Indirect/Negative Correlation
• Regression
• Choosing Right Method
   

MODULE 1: COMPARISION AND CORRELATION ANALYSIS

• Data comparison Introduction
• Concept of Correlation
• Calculating Correlation with Excel
• Comparison vs Correlation
• Performing Comparison Analysis on Data
• Performing correlation Analysis on Data
• Hands-on case study 1: Comparison Analysis
• Hands-on case study 2 Correlation Analysis

MODULE 2: VARIANCE AND FREQUENCY ANALYSIS

• Concept of Variability and Variance
• Data Preparation for Variance Analysis
• Business use cases for Variance and Frequency Analysis
• Performing Variance and Frequency Analysis
• Hands-on case study 1: Variance Analysis
• Hands-on case study 2: Frequency Analysis

MODULE 3: RANKING ANALYSIS

• Introduction to Ranking Analysis
• Data Preparation for Ranking Analysis
• Performing Ranking Analysis with Excel
• Insights for Ranking Analysis
• Hands-on Case Study: Ranking Analysis

MODULE 4: BREAK EVEN ANALYSIS

• Concept of Breakeven Analysis
• Make or Buy Decision with Break Even
• Preparing Data for Breakeven Analysis
• Hands-on Case Study: Procurement Decision with break even

MODULE 5: PARETO (80/20 RULE) ANALSYSIS

• Pareto rule Introduction
• Preparation Data for Pareto Analysis
• Insights on Optimizing Operations with Pareto Analysis
• Performing Pareto Analysis on Data
• Hands-on case study: Pareto Analysis

MODULE 6: Time Series and Trend Analysis

• Introduction to Time Series Data
• Preparing data for Time Series Analysis
• Types of Trends
• Trend Analysis of the Data with Excel
• Insights from Trend Analysis
• Hands-on Case Study: Trend Analysis

MODULE 7: DATA ANALYSIS BUSINESS REPORTING

• Management Information System Introduction
• Various Data Reporting formats
• Creating Data Analysis reports as per the requirements
• Presenting the reports
• Hands-on case study: Create Data Analysis Reports

MODULE 1: DATA ANALYTICS FOUNDATION

• Business Analytics Overview
• Application of Business Analytics
• Visual Perspective
• Benefits of Business Analytics
• Challenges
• Classification of Business Analytics
• Data Sources
• Data Reliability and Validity
• Business Analytics Model

MODULE 2: OPTIMIZATION MODELS

• Prescriptive Analytics with Low Uncertainty
• Mathematical Modeling and Decision Modeling
• Break Even Analysis
• Product Pricing with Prescriptive Modeling
• Building an Optimization Model
• Case Study 1 : WonderZon Network Optimization
• Assignment 1 : KERC Inc, Optimum Manufacturing Quantity

MODULE 3: PREDICTIVE ANALYTICS WITH REGRESSION

• Mathematics beyond Linear Regression
• Hands on: Regression Modeling in Excel
• Case Study 2 : Sales Promotion Decision with Regression Analysis
• Assignment 2 : Design Marketing Decision board for QuikMark Inc.

MODULE 4: DECISION MODELING

• Prescriptive Analytics with High Uncertainty
• Comparing Decisions in Uncertain Settings
• Decision Trees for Decision Modeling
• Case Study 3 : Decision modeling of Internet Plans, Monte Carlo Simulation
• Case Study 4 : Kickathlon Sports Retailer Supplier Decision Modeling

MODULE 1: MACHINE LEARNING INTRODUCTION

• What Is ML? ML Vs AI
• ML Workflow, Popular ML Algorithms
• Clustering, Classification And Regression
• Supervised Vs Unsupervised

MODULE 2: ML ALGO: LINEAR REGRESSSION

• Introduction to Linear Regression
• How it works: Regression and Best Fit Line
• Hands-on Linear Regression with ML Tool

MODULE 3: ML ALGO: LOGISTIC REGRESSION

• Introduction to Logistic Regression
• How it works: Classification & Sigmoid Curve
• Hands-on Logistics Regression with ML Tool

MODULE 4: ML ALGO: KNN

• Introduction to KNN
• How It Works: Nearest Neighbor Concept
• Hands-on KNN with ML Tool

MODULE 5: ML ALGO: K MEANS CLUSTERING

• Understanding Clustering (Unsupervised)
• K Means Algorithm
• How it works : K Means theory
• Hands-on K Means Clustering with ML Tool

MODULE 6: ML ALGO: DECISION TREE

• Random Forest Ensemble technique
• How it works: Bagging Theory
• Hands-on Decision Tree with ML Tool

MODULE 7: ML ALGO: SUPPORT VECTOR MACHINE (SVM)

• Introduction to SVM
• How It Works: SVM Concept, Kernel Trick
• Modeling and Evaluation of SVM in Python

MODULE 8: ARTIFICIAL NEURAL NETWORK (ANN)

• Introduction to ANN
• How It Works: Back prop, Gradient Descent
• Modeling and Evaluation of ANN in Python

MODULE 9: PROJECT: PREDICTIVE ANALYTICS WITH ML

• Project Business requirements
• Data Modeling
• Building Predictive Model with ML Tool
• Evaluation and Deployment
• Project Documentation and Report

MODULE 1: GIT INTRODUCTION

• Purpose of Version Control
• Popular Version control tools
• Git Distribution Version Control
• Terminologies
• Git Workflow
• Git Architecture

MODULE 2: GIT REPOSITORY and GitHub

• Git Repo Introduction
• Create New Repo with Init command
• Copying existing repo
• Git user and remote node
• Git Status and rebase
• Review Repo History
• GitHub Cloud Remote Repo

MODULE 3: COMMITS, PULL, FETCH AND PUSH

• Code commits
• Pull, Fetch and conflicts resolution
• Pushing to Remote Repo

MODULE 4: TAGGING, BRANCHING AND MERGING

• Organize code with branches
• Checkout branch
• Merge branches

MODULE 5: UNDOING CHANGES

• Editing Commits
• Commit command Amend flag
• Git reset and revert

MODULE 6: GIT WITH GITHUB AND BITBUCKET

• Creating GitHub Account
• Local and Remote Repo
• Collaborating with other developers
• Bitbucket Git account

MODULE 1: DATABASE INTRODUCTION

• DATABASE Overview
• Key concepts of database management
• CRUD Operations
• Relational Database Management System
• RDBMS vs No-SQL (Document DB)

MODULE 2: SQL BASICS

• Introduction to Databases
• Introduction to SQL
• SQL Commands
• MY SQL workbench installation
• Comments
• import and export dataset

MODULE 3: DATA TYPES AND CONSTRAINTS

• Numeric, Character, date time data type
• Primary key, Foreign key, Not null
• Unique, Check, default, Auto increment

MODULE 4: DATABASES AND TABLES (MySQL)

• Create database
• Delete database
• Show and use databases
• Create table, Rename table
• Delete table, Delete table records
• Create new table from existing data types
• Insert into, Update records
• Alter table

MODULE 5: SQL JOINS

• Inner join
• Outer join
• Left join
• Right join
• Cross join
• Self join

MODULE 6: SQL COMMANDS AND CLAUSES

• Select, Select distinct
• Aliases, Where clause
• Relational operators, Logical
• Between, Order by, In
• Like, Limit, null/not null, group by
• Having, Sub queries

MODULE 7: DOCUMENT DB/NO-SQL DB

• Introduction of Document DB
• Document DB vs SQL DB
• Popular Document DBs
• MongoDB basics
• Data format and Key methods
• MongoDB data management

MODULE 1: BIG DATA INTRODUCTION

• Big Data Overview
• Five Vs of Big Data
• What is Big Data and Hadoop
• Introduction to Hadoop
• Components of Hadoop Ecosystem
• Big Data Analytics Introduction

MODULE 2: HDFS AND MAP REDUCE

• HDFS – Big Data Storage
• Distributed Processing with Map Reduce
• Mapping and reducing stages concepts
• Key Terms: Output Format, Partitioners, Combiners, Shuffle, and Sort
• Hands-on Map Reduce task

MODULE 3: PYSPARK FOUNDATION

• PySpark Introduction
• Spark Configuration
• Resilient distributed datasets (RDD)
• Working with RDDs in PySpark
• Aggregating Data with Pair RDDs

MODULE 4: SPARK SQL and HADOOP HIVE

• Introducing Spark SQL
• Spark SQL vs Hadoop Hive
• Working with Spark SQL Query Language

MODULE 5: MACHINE LEARNING WITH SPARK ML

• Introduction to MLlib Various ML algorithms supported by Mlib
• ML model with Spark ML.
• Linear regression
• logistic regression
• Random forest

MODULE 6: KAFKA and Spark

• Kafka architecture
• Kafka workflow
• Configuring Kafka cluster
• Operations

MODULE 1: BUSINESS INTELLIGENCE INTRODUCTION

• What Is Business Intelligence (BI)?
• What Bi Is The Core Of Business Decisions?
• BI Evolution
• Business Intelligence Vs Business Analytics
• Data Driven Decisions With Bi Tools
• The Crisp-Dm Methodology

MODULE 2: BI WITH TABLEAU: INTRODUCTION

• The Tableau Interface
• Tableau Workbook, Sheets And Dashboards
• Filter Shelf, Rows And Columns
• Dimensions And Measures
• Distributing And Publishing

MODULE 3: TABLEAU: CONNECTING TO DATA SOURCE

• Connecting To Data File , Database Servers
• Managing Fields
• Managing Extracts
• Saving And Publishing Data Sources
• Data Prep With Text And Excel Files
• Join Types With Union
• Cross-Database Joins
• Data Blending
• Connecting To Pdfs

MODULE 4: TABLEAU : BUSINESS INSIGHTS

• Getting Started With Visual Analytics
• Drill Down And Hierarchies
• Sorting & Grouping
• Creating And Working Sets
• Using The Filter Shelf
• Interactive Filters
• Parameters
• The Formatting Pane
• Trend Lines & Reference Lines
• Forecasting
• Clustering

MODULE 5: DASHBOARDS, STORIES AND PAGES

• Dashboards And Stories Introduction
• Building A Dashboard
• Dashboard Objects
• Dashboard Formatting
• Dashboard Interactivity Using Actions
• Story Points
• Animation With Pages

MODULE 6: BI WITH POWER-BI

• Power BI basics
• Basics Visualizations
• Business Insights with Power BI

A discipline called data analytics is dedicated to drawing conclusions from data. It includes the procedures, equipment, and methods for gathering, organising, and storing data as well as data analysis and management. Applying statistical analysis and technology to data in order to identify trends and resolve issues is the main goal of data analytics.

In the fields of engineering, computer science, and management, there are postgraduate courses in data science accessible. A Bachelor's degree with at least 50% overall or an equivalent grade from a reputable university, ideally in the fields of science or computer science, is the minimum requirement for enrollment in a data analytics course.

A very solid career in data analytics. There has never been a better time to be a data professional, to put it simply. Data creation is increasing at a rate of 2.5 quintillion bytes each day. Depending on the training level you want, there will be a difference in cost. The cost of data analytics training might be anything between 30,000 and 100,000 Indian rupees.

A degree is typically not required for a position as a data analyst, but getting the right certification from an accredited college is crucial. It could take anywhere from six weeks to two years to learn the skills needed for success in data analytics. A 4-month training programme is an efficient way to learn about and master data analytics. Because there are so many different paths one might take to become a data analytics specialist, the variability is explained by this.

The benefits of a career in data analytics won't manifest without extensive training and effort. Data analysts require a particular set of skills to succeed in their line of work, and while having a technical background is important, they also need a few soft skills.

Data Clearing and Information Display

Linear algebra, MATLAB, R, Python, and NoSQL Machine Learning Calculus

Communication and Critical Thinking in Excel for Windows

• The national average salary for a Data Analyst is USD 69,517 per year in the United States. (Glassdoor)

• The national average salary for a Data Analyst is £36,535 per annum in the UK.  (Glassdoor)

• The national average salary for a Data Analyst is INR 6,00,000 per year in India. (Glassdoor)

• The national average salary for a Data Analyst is C$58,843 per year in Canada. (Payscale)

• The national average salary for a Data Analyst is AUD 85,000 per year in Australia. (Glassdoor)

• The national average salary for a Data Analyst is 46,328 EUR per annum in Germany. (Payscale)

• The national average salary for a Data Analyst is CHF 95,626 per year in Switzerland. (Glassdoor)

• The national average salary for a Data Analyst is AED 106,940 per year in UAE. (Payscale)

• The national average salary for a Data Analyst is SAR 95,960 per year in Saudi Arabia. (Payscale.com)

• The national average salary for a Data Analyst is ZAR 286,090 per year in South Africa. (Payscale.com)

Outside of the computer and digital industries, data science offers career opportunities and transferable skills.

• Business Intelligence Analyst

• IT Systems Analyst

• Data Analyst Consultant

• Data Analyst

• Data Scientist

• Data Engineer

• Quantitative Analyst

• Marketing Analyst

• Project Manager

• Operations Analyst

Among the most in-demand specialists worldwide are skilled data analysts. Data analysts earn enormous incomes and top-notch benefits, even at the entry level, due to the high demand for their services and the relatively small pool of qualified candidates. The average pay for a data analyst in India is 4,64,926 INR according to Payscale. In Ludhiana, a data analyst makes an average salary of 3,07,180 LPA! (Indeed)

Since there is a growing need for data specialists but a limited supply, there are many excellent work prospects in this industry. If you want to pursue a career in the analytics industry, DataMites is the finest institute for you. The primary mentors are knowledgeable and industry-oriented, and the course curriculum is skillfully laid out. With projects and internship opportunities, we provide practical training!

The phrase "data analytics" has gained popularity in recent years due to the rise in data generation. The DataMites Data Analytics Course has no formal prerequisites because it is designed to train candidates starting at level 1. However, having a prior understanding of programming languages, databases, data structures, mathematics, and algorithms will only be favourable.