Data Analytics

Training Mode
Offline
Course Duration
6 months
Course Materials
Available
Training Session
1 hrs.
Practical Learning
Yes
Market Exposure
Yes
Placement Sessions
Yes
Certifications
Yes
Other Certifications
Yes

Course Overview

पढाने का अनोखा तरीका

  • Excel Basics
  • Data entry and basic functions
  • Logical and data validation functions
  • Lookup and reference functions
  • Text manipulation functions
  • Excel tables and structured data
  • Pivot tables for data analysis
  • Advanced pivot table techniques
  • Data visualization basics
  • Advance charting techniques
  • Conditional formatting and sparklines
  • Dashboard design principles
  • Advance dashboarding techniques
  • Power query and data transformation

  • Installation Of Anaconda Navigator 
  • Data Types in Python 
  • Operations in Python 
  • Control Structures in Python
  • Functions
  • OOPs in Python (Operational) 

Python For Data Science

  • Introduction to NumPy
  • Operation in NumPy
  • Indexing NumPy Arrays 
  • Pandas Series and Data Frames 
  • Operations 
  • Group by Function 
  • Joining Concatenating and merging Data Frames

Data Visualisation in Python

  • Data Visualisation Using Matplotlib 
  • Data Visualisation Using Seaborn

Exploratory Data Analysis 

  • Web Scraping 
  • Data Wrangling 
  • Data Preparation 
  • Missing Value Imputation 
  • EDA

  • Fundamentals of Databases
  • OLAP vs OLTP
  • SQL DDL commands
  • SQL DML commands
  • SQL Grouping and Sorting
  • SQL Joins
  • Subquery
  • Window Functions
  • Stored Procedures, View and Triggers
  • Optimizing SQL queries
  • Data analysis using SQL

  • Introduction to Statistics
  • Measures of central tendency
  • Measures of dispersion
  • Correlation and covariance
  • Data visualization using graphs
  • Probability Distributions
  • Central Limit Theorem
  • Confidence Interval
  • Hypothesis Testing
  • Fundamentals of Probability

  • Introduction to PowerBI
  • Understanding the PowerBI interface
  • PowerBI Visualizations
  • PowerBI filtering and interactivity DAX 
  • Advance DAX and Data modelling
  • Power Query
  • Advance Data transformation and integration
  • PowerBI Services
  • PowerBI Architecture
  • PowerBI AI Integration

  • Introduction to Tableau
  • Tableau Basics 
  • Various Important Charts 
  • Interactive Dashboard Presentation 

  • Importance of Data Storytelling 
  • Components of Good Story 
  • Presenting Story Memorable Way 

  • Interactive Text Analysis Platform
  • E-commerce Sales Analysis
  • Financial Data Analysis using Excel
  • Uber Data Analysis
Enquiry Now
Message Sent Successfully!!