Loading…
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
Gunduz Haydarov
Python Back-End Development instructor
Mammadali Mammadaliyev
Python Back-End Development instructor
Murad Orujov
Full Stack Development instructor
%20(1)-1761313230587.webp&w=1920&q=68)
Shamil Vasiyev
Full Stack Development instructor
Ramin Mammadazada
Full Stack Development instructor
Gulnara Dashdamirova
Microsoft Office Programs instructor
Vahid Teymurlu
Data Analytics instructor
Mushvig Manafli
Java Back-End Development instructor
Huseynaga Gurbanov
Practical Computer Knowledge instructor
Jeyhun Sharafkhanov
IT Help Desk and Network Administration Trainer
Arif Mukhtarov
IT Help Desk instructor
Tural Karimov
IT Help Desk instructor
-1761719440403.webp&w=1920&q=68)
Nazli Ibrahimli
English instructor
Nijat Babayev
Cybersecurity instructor
-1761912146662.webp&w=1920&q=68)
Huseyn Rustamli
Java Back-End Programming mentor
-1763979824141.webp&w=1920&q=68)
Yusif Teymurlu
Python Back-End Development mentor
-1773752258431.webp&w=1920&q=68)
Nijat Suleymanov
Cybersecurity Mentor
Yusıf Yaqublu
AI Engineering Development instructor