info@stepindia.net

Data Analytics

Duration: 2 Months

About Data Analytics

Data analytics involves the examination, interpretation, and extraction of meaningful insights from various datasets to support informed decision-making. It employs statistical techniques, machine learning, and visualization tools to uncover patterns, trends, and correlations within the data. These insights drive business strategies, optimize processes, and enhance understanding across diverse domains.

Course Main Modules:

  1. MySQL
  2. Data Visualization
  3. Exploratory Data Analysis
  4. Statistics
  5. Programming Language - Python
  6. Pandas
  7. Tableau
  8. Matplotlib
  9. Excel

Course Curriculum:

  • Introduction to Python Programming
  • Data Cleaning in Python
  • Introduction to Kaggle
  • Python for Data Analysis - Numpy,
  • Pandas
  • Python for Data Visualization
  • Matplotlib, Seaborn
  • Introduction to Problem Solving
  • Approach to Problem Solving
  • Aids to Business Problem Solving
  • Database Design and Data Warehouse
  • Data Modelling
  • SQL Querying
  • Joins and Set Operations
  • Business Problem-solving using Data
  • Modelling
  • Introduction to Data Analysis
  • Creating and Formatting Charts
  • Creating a Pivot Table
  • Analysing Data in a Pivot Table
  • Getting Started with Tableau
  • Charts, Plots, Hierarchies
  • Grouping and Tree-Maps
  • Dashboard Creation
  • Storytelling
  • Inferential Statistics
  • Hypothesis testing
  • Data Sourcing
  • Data Cleaning
  • Univariate Analysis
  • Bivariate Analysis
  • Derived Metrics
  • Linear regression
  • Logistic regression
  • Decision trees
  • Charts
  • Treemaps
  • Histograms
  • Database Design
  • Data Modelling
  • SQL Querying
  • Joins and Set Operations
Data Analytics