Data Analysis Course

Course Overview

This is an all-inclusive 3 weeks Boot Camp Training that gives you the ability to upskill yourself! Batches Start the First Monday of Every Month (Excluding Bank Holidays!)

• Enhanced Problem-Solving : By giving you the tools to recognize trends, spot anomalies, and solve complicated issues with data-driven methods, data analytics enables you to take well-informed decisions.
• Improved Forecasting and Strategic Planning : Data analytics enables accurate forecasts and successful business strategies for improved forecasting and planning by analyzing patterns and trends from previous data.
• Practical Application in Everyday Life : Data analytics expertise has real-world applications in daily life. Effective data organization may help with personal budgeting, and clearly communicating complicated data enhances communication abilities.
• Empowered Decision-Making : Your ability to extract important insights from complicated datasets thanks to your proficiency in data analytics will help you to make well-informed judgments in a variety of industries, including business, finance, and healthcare.

Skills You Will Gain

The students will acquire following set of skills after completing this Training Course.

• Data Visualization : Master the skill of using interactive visualizations, charts, and graphs to display complicated data in a way that is visually appealing and ensures stakeholders can understand and digest the information with ease.
• Data Mining : Learn how to use methods like clustering, classification, and association analysis to extract hidden patterns, trends, and insights from huge datasets, allowing decision-making based on insightful data findings.
• SQL and Database Querying : Gain proficiency in relational database extraction, manipulation, and analysis using SQL (Structured Query Language), improving data analysis procedures and boosting data-driven insights.
• Programming Proficiency : Become proficient in programming languages like Python to automate activities, analyze data more effectively, streamline workflows, and produce more significant outcomes.
• Business Acumen : Develop a thorough grasp of business principles and subject-matter expertise, coordinating data analysis activities with corporate goals, and making data-driven suggestions that promote company success.

Your 3 Week Plan

Week 1

Day 1: MS Excel

• 1st Hour (Basic – Intermediate Excel) :
  • Introduction
  • Cell Intro
  • Freeze Cells
  • Formula Writing
  • Average, Maximum, Minimum
  • References
  • Functions
  • IF, OR
  • IF, AND
  • Nested IFs
  • Average, SUM IF
  • VLookup
  • HLookup
  • Date, Working Days
  • Pivot Tables
  • Slicers
  • Consolidation of Data
  • Heat Map
  • Hyperlinks
  • Charts
  • Pie Chart
• 2nd Hour (Advanced):
  • Nested IFs
  • Goal Seek
  • What-If Table
  • Scenario Managers
  • Match
  • Sober Add-In
  • Loan
  • Grouping in Pivot Table
  • Protection Series
  • VLookup on Duplicate Values
• 3rd Hour (Advanced):
  • Vlookups approx match
  • Vlookup & IF
  • Vlookup & Match
  • Dependent, Drop Down, List
  • Data Validation Options
  • Calculation on Filter Data
  • Filtering with complex Conditions
  • Macros
  • Macros & VBA
  • Power Query

Day 2

• 1st Hour (Mathematics & Statistics):
  • Linear Functions
  • Linear Algebra
  • Vectors
  • Matrices
  • Tensors
  • Descriptive
  • Variability
  • Distribution
  • Probability
• 2nd Hour (Anaconda Environment Setup):
  • Anaconda Demo
  • Environment Setup
• 3rd Hour (Git & Github):
  • Version Control System
  • Version Control Types
  • Git & GitHub
  • Git Operations & Commands

Day 3

• 1st Hour (Python Basics):
  • What is Python
  • Python Setup
  • Python Indentation & Comments
  • Data Types & Syntax
  • Python Operators
  • Escape Characters in Python
  • List
  • Tuples
  • Set
  • Dictionary

Day 4

• 1st Hour (Python Intermediate):
  • Python Conditions
  • if-else Statements
  • Python Loops
  • Functions
  • Methods
  • Class / Objects
  • Inheritance
• 2nd Hour (Python Intermediate – Advance):
  • Error & Exception Handling
  • File Handling
  • Module Packages & Libraries
  • Future Considerations
  • Pandas
• 3rd Hour (Python Advance):
  • Numpy
  • Data visualization Using Python

Day 5

• 1st Hour (Python Activities):
  • Problem Statements and Questions
  • Fizz Buzz
  • Swap Cases
  • Swap Numbers
  • Fibonacci Series
  • Number Guessing Game
  • Basic Calculator
• 2nd Hour (Python Projects):
  • Rock, Paper, Scissors
  • Binary Search
  • Email Program
  • Zodiac Sign
• 3rd Hour (Python Projects):
  • Zodiac SignB
  • Bulk File Renamer
  • Web Scraping

Week 2

Day 1

• 1st Hour (R Language Basics) :
  • R Programming Introduction
  • R & R Studio Installation Setup
  • R Basics
• 2nd Hour (R Language Intermediate & Advanced):
  • R Data Structures
  • R Graphics
• 3rd Hour (R Language Intermediate & Advanced):
  • R Graphics
  • R Statistics

Day 2

• 1st Hour (R Language Projects):
  • Covid-19 Data Analysis with R
  • Data Set
  • Exploratory Data Analysis with R – Bank Marketing
  • Data Set
• 2nd Hour (Python Add ON):
  • SQ Lite
  • GUI

• 3rd Hour (Machine Learning):
  • Data Preprocessing
  • Data Source
  • Cross-Validation

Day 3

• 1st Hour (Machine Learning):
  • Simple Linear Regression
  • Data Source
  • Multiple Linear Regression
  • Data Source
  • Polynomial Regression
  • Data Source
  • Decision Tree Regression
  • Data Source
  • Linear Regression Assumption
• 2nd Hour (Machine Learning):
  • Random Forest Regression
  • Data Source
  • Assessing a Regression Model
  • Bias vs Variance
  • Regularization

• 3rd Hour (Machine Learning):
  • Decision Tree Classification
  • K-Nearest Neighbor

Day 4

• 1st Hour (Machine Learning):
  • Logistic Regression
  • Naive Bayes
  • Random Forest Classification
• 2nd Hour (Machine Learning):
  • Support Vector Machines
  • Assessing a Classification Model
  • Adaboost

• 3rd Hour (Machine Learning):
  • Gradient Boosting
  • XGBoost

Day 5

• 1st Hour (Machine Learning):
  • Grid Search CV
  • Hierarchical Clustering
  • K-Means Clustering
• 2nd Hour (Machine Learning):
  • Principal Component Analysis (PCA)
  • Apriori
  • Eclat

• 3rd Hour (Machine Learning Projects):
  • Weather Prediction
  • Wine Quality Prediction

Week 3

Day 1

• 1st Hour (Machine Learning Projects) :
  • Predicting Cancer Malignant or Benign
  • Marketing Data Analysis
• 2nd Hour (Machine Learning Projects):
  • Predicting Stock Prices
• 3rd Hour (Machine Learning Projects):
  • ETL / ELT

Day 2

• 1st Hour (Talend Open Studio Basic – Intermediate):
  • Talend Open Studio ( TOS )
• 2nd Hour (Talend Open Studio – Advance):
  • Talend Open Studio ( TOS )

• 3rd Hour (Talend Open Studio Projects):
  • TOS Project 01
  • TOS Project 02

Day 3

• 1st Hour (PowerBi Basic – Intermediate):
  • PowerBi Basics
  • PowerBi Intermediate
• 2nd Hour (PowerBi Advance):
  • PowerBi Advance

• 3rd Hour (PowerBi Projects):
  • PowerBI Project 01
  • PowerBI Project 02

Day 4

• 1st Hour (Tableau Basic – Intermediate):
  • Tableau Installation
  • Tableau UI
  • Tableau UI Components
  • Tableau Marks Chart
• 2nd Hour (Tableau Basic – Intermediate):
  • Tableau Functions & Filters
  • Tableau Forecasting & Parameters

• 3rd Hour (Tableau Basic – Intermediate):
  • Project 01
  • Project 01

Career Path

• Data Analyst
• Business Intelligence Analyst
• Powe BI Analyst
• Data Engineer
• Market Research Analyst
• Financial Analyst
• Data Quality Analyst
• Healthcare Analyst

Projects

• Weather Prediction
• Predicting Cancer Malignant or Benign
• Predicting Stock Prices
• Wine Quality Prediction

Certification

Participants will receive certificates from Future Connect Training to mark their success and the priceless information they have learned after completing the training program.