Skip to main content

Data Analytics Course - Master Analytics Tools and Techniques

19999.00 INR 19999.00 INR (Excl. GST)

Data Analytics Course - Master Analytics Tools and Techniques

Master analytics tools and techniques with Data Analytics Training. Sign up for the JanBask Data analytics programs to gain expertise in Data Visualization, Mining, Refining, and Interpretation. Understand the roles, events, artifacts, and rules of an ideal Data Analyst.

Course Information

  • Instructor Led Live Classes
  • Resume and Interview Guidance
  • 100% Job Placement Assistance
  • Industry-Recognized Certification
  • Comprehensive Curriculum
  • Hands-On Project Experience

      • Course Content

    • Intro to Data Analytics, Basic and Advance Excel

      • Introduction to Data Analytics
      • Data Analytics Overview Lesson 
      • Dealing with Different Types of Data Lesson
      • Data Visualization for Decision making Lesson 
      • Data Science, Data Analytics, and Machine Learning Lesson
      • Data Analytics in Different Sectors Lesson
      • Analytics Framework and Latest trends
      • Understand various data types
      • Explain Population and Sample
      • Discuss sampling techniques
      • Formatting Conditional Formatting and Important Functions
      • Analysing Data with Pivot Tables
      • Dash boarding
      • Business Analytics with Excel, Data Analysis Using Statistics
      • Important formulas in Excel Working with Dynamic table
      • Working with Macros in Excel and VBA

    • SQL

      • Introduction to SQL Database
      • Introduction to DBMS, Concepts of RDBMS
      • Normalization and entity-relationship model
      • SQL operators Working with SQL: Join, tables, and variables
      • SQL Commands, Data Query Language, DML & DDL Commands
      • Views and Index
      • Deep dive into SQL Functions Working with Sub queries 
      • SQL views, functions, and stored procedures
      • Database Constraints
      • SQL Transactions
      • Integrity, Constraints, CASE Statements and Case Studies
      • Joins, Sub Queries, and Nested Queries
      • Views and Database constraints
      • Stored Procedures and Functions

    • Python

      • Introduction to Data Science using Python
      • Python Environment Setup and Essentials
      • Python Environment Setup and Essentials
      • Python basic constructs
      • Python Operators
      • Flow Control Statements -If Statements -While Loops
      • Data & time modules in python -Interfaces in Python -For Loops
      • Data Manipulation with Pandas
      • Maths for DS-Statistics & Probability
      • Oops in Python (self-paced)
      • Numpy for mathematical computing
      • Scipy for scientific computing Data
      • Manipulation Data visualization with Matplotlib

    • Tableau

      • Introduction to data visualization
      • Architecture of Tableau
      • Working with metadata and data blending
      • Creating Calculated Fields
      • Creating Charts in Tableau
      • Working with Metadata
      • Filters in Tableau
      • Tableau-Joins and Data Pane
      • What are Joins in Tableau
      • Types Of Joins in Tablea
      • Applying Analytics to the worksheet
      • Working with mapping
      • Working with calculations and expressions
      • Working with parameters Charts and graphs
      • Dashboards and stories

    • Statistics

      • Data Types, Measure Of central tendency, Measures of Dispersion
      • Graphical Techniques, Skewness & Kurtosis, Box Plot
      • Descriptive Stats
      • Random Variable, Probability, Probility Distribution, Normal Distribution, SND, Expected Value
      • Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
      • Introduction to Hypothesis Testing
      • Hypothesis Testing (2 proportion test, 2 t sample t test)
      • Anova and Chisquare
      • Data Cleaning
      • Imputation Techniques
      • Scatter Diagram
      • Correlation Analysis

    • Data Science

      • Machine Learning using Python
      • Supervised learning
      • Unsupervised learning
      • Dimensionality reduction
      • Time-series forecasting
      • AI & Deep Learning using TensorFlow
      • Multi-layered Neural Networks

    Data Analytics Course Certificate

    Stand out with resume-worthy Data Analyst Certification Online. It's time to get your Data Analytics certification!

    Online Course Certification