JET Academy

Data Analytics course

data analyticspythonsqlpower biexcelstatistics

About the Course

The Data Analytics Course is designed for anyone aged 16 and above who wants to work with data, develop analytical thinking skills, and learn how to extract insights from data. The course lasts 4 months and is conducted 3 times a week (2 in-person + 1 online, 2 hours each). The training process is practical and project-oriented.

The program teaches participants key analytics tools such as Python, SQL, Excel, and Power BI, helping them develop both technical skills and analytical thinking abilities.

📌 What you will learn during the course:

  • Python for Data Analytics
  • Statistics
  • Excel
  • SQL
  • Power BI

💡 At the end of the course, students will:

  • Work on real projects
  • Build their Data Analytics portfolio with mentor support
  • Receive a professional certificate and gain practical experience
  • Main objects and data structures in Python
  • Conditional operators
  • Loop operators in Python
  • Modules
  • NumPy library (Multidimensional arrays for scientific computing)
  • Pandas library (Processing and analysis of tabular data)
  • Matplotlib library (Visualization and graph plotting)
  • Introduction to Statistics
  • Variables, Measurement Levels
  • Measures of Central Tendency: Mean, Median, Mode
  • Measures of Variability: Quartile, Range, Variance, Standard Deviation
  • Deviation, Skewness, Kurtosis
  • Central Limit Theorem, Standard Error, Degree of Freedom
  • Distributions
  • Statistical Tests (A/B testing, T-test family, etc.)
  • Covariance, Correlation, Regression
  • Excel Fundamentals
  • Essential Formulas
  • Data Lookup & Referencing
  • Data Cleaning & Preparation
  • Data Analysis Tools
  • Charts & Visual Analytics
  • Dashboard Preparation
  • Introduction to PostgreSQL
  • Basic SELECT statements
  • Filtering and sorting data
  • PostgreSQL functions
  • Group (Aggregate) functions
  • Working with multiple tables (JOIN)
  • Combining queries
  • Using subqueries
  • Data modification operations (INSERT, UPDATE, DELETE)
  • Parallel exercises and code examples with Oracle SQL
  • Introduction to Power BI
  • Data extraction and transformation
  • Power Query
  • Power Pivot
  • DAX (most commonly used functions)
  • Data visualization
  • Saving and sharing

Enroll Now

Who Can Enroll?

16 above

Suitable for young people over 16 years old

Computer usage

Those who can use a computer comfortably

English knowledge level

Those with basic reading and writing skills in English

Logical thinking

Those who are able to analyze problems and find the right solutions

Course Instructors

All instructors at JET Academy are highly experienced professionals in their field, distinguished by their pedagogical skills

Team member Vahid Teymurlu

Vahid Teymurlu

Data Analytics Teacher

Other Course Fields