Data Analytics course

Hours: 96

Lessons per week: 3

Duration: 4 Months

The Data Analytics Training is designed for anyone over the age of 18 who wants to learn how to work with data, develop analytical thinking, and make informed decisions based on results.

The 4-month program is delivered three times a week, with each session lasting 2 hours, in either in-person or online format. Throughout the training, you will work with real datasets and projects, gain hands-on experience with Python, SQL, Excel, and Power BI, and develop the statistical knowledge required to interpret results accurately.

By the end of the training, you will not only know how to use analytical tools but also how to approach data analytically, visualize findings, and turn numbers into well-founded decisions.

What You Will Learn

Data Analytics with Python
Statistics and Statistical Analysis
Data Processing with Microsoft Excel
Database Querying with SQL
Data Visualization and Dashboard Creation with Power BI

By the End of the Course, You Will

Work on real-world datasets and practical projects;
Learn how to clean, analyze, and visualize data effectively;
Build a professional Data Analytics portfolio with mentor guidance;
Receive a Certificate of Completion and gain practical experience that will strengthen your career opportunities in the job market.

Course modules

Python Introduction, Variables, and Data Types
Data Structures: Lists, Tuples, Dictionaries, and Sets
Conditional Statements and Loop Statements
Functions, Modules, and Exception Handling
Numerical Computing and Arrays with NumPy
Reading and Processing Data with Pandas
Data Cleaning and Analysis
Data Visualization and Plotting with Matplotlib

Introduction to Statistics and Fundamental Concepts
Types of Variables and Levels of Measurement
Descriptive Statistics and Data Summarization
Mean, Median, Mode, and Measures of Variability
Distributions, Skewness, and Kurtosis
Sampling, Central Limit Theorem, and Standard Error
Hypothesis Testing, p-value, A/B Testing, and t-Tests
Correlation, Covariance, and Regression
Application of Statistical Analysis in Python

Excel Fundamentals and Data Structuring
Basic, Logical, Text, Date, Mathematical, Statistical, and Lookup Functions
Data Cleaning, Filtering, and Sorting
Data Analysis with Pivot Tables and Pivot Charts
Data Transformation with Power Query
Building Relationships with Power Pivot and Data Model
Charts, Visual Analytics, and Dashboard Creation

Introduction to Databases, PostgreSQL, and SQL
SELECT Queries, Filtering, and Sorting
SQL Functions and Data Types
Aggregate Functions and Data Grouping
Working with Multiple Tables and JOIN Operations
Subqueries, CTEs, and Query Combining
Working with Date, Text, and Numerical Data
INSERT, UPDATE, and DELETE Operations
Practical Exercises with PostgreSQL and Oracle SQL

Introduction to Power BI and the Main Working Environment
Connecting to Data from Various Sources
Data Cleaning and Transformation with Power Query
Building Data Models and Relationships Between Tables
DAX Functions and Creating Calculations
Charts, Tables, and Interactive Visualizations
Filters, Slicers, and KPI Indicators
Creating Professional Dashboards and Reports
Publishing, Sharing, and Updating Reports

Microsoft Office Specialist Excel (only those who wish to obtain this certification may enroll in this module).

#data analytics#python#sql#power bi#excel#statistics#data analytics#python#sql#power bi#excel#statistics

Enroll Now

Who Can Enroll?

Those who want to build a career in Data Analytics

For Those Who Want to Work as Data Analysts and Transition into a High-Paying Career in IT

Students and Recent Graduates

For Those Who Want to Work as Data Analysts and Transition into a High-Paying Career in IT

For those who want to change their career path

For professionals from other fields who want to pursue a more promising, engaging, and higher-paying career path

Business Owners and Executives

For entrepreneurs and executives who want to grow their businesses more effectively and faster by analyzing data

Course Instructors

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

Vahid Teymurlu

Teacher

Enroll Now

Other Fields

Data Analytics course

Hours: 96

Lessons per week: 3

Duration: 4 Months

The Data Analytics Training is designed for anyone over the age of 18 who wants to learn how to work with data, develop analytical thinking, and make informed decisions based on results.

By the end of the training, you will not only know how to use analytical tools but also how to approach data analytically, visualize findings, and turn numbers into well-founded decisions.

What You Will Learn

Data Analytics with Python
Statistics and Statistical Analysis
Data Processing with Microsoft Excel
Database Querying with SQL
Data Visualization and Dashboard Creation with Power BI

By the End of the Course, You Will

Work on real-world datasets and practical projects;
Learn how to clean, analyze, and visualize data effectively;
Build a professional Data Analytics portfolio with mentor guidance;
Receive a Certificate of Completion and gain practical experience that will strengthen your career opportunities in the job market.

Course modules

Python Introduction, Variables, and Data Types
Data Structures: Lists, Tuples, Dictionaries, and Sets
Conditional Statements and Loop Statements
Functions, Modules, and Exception Handling
Numerical Computing and Arrays with NumPy
Reading and Processing Data with Pandas
Data Cleaning and Analysis
Data Visualization and Plotting with Matplotlib

Introduction to Statistics and Fundamental Concepts
Types of Variables and Levels of Measurement
Descriptive Statistics and Data Summarization
Mean, Median, Mode, and Measures of Variability
Distributions, Skewness, and Kurtosis
Sampling, Central Limit Theorem, and Standard Error
Hypothesis Testing, p-value, A/B Testing, and t-Tests
Correlation, Covariance, and Regression
Application of Statistical Analysis in Python

Excel Fundamentals and Data Structuring
Basic, Logical, Text, Date, Mathematical, Statistical, and Lookup Functions
Data Cleaning, Filtering, and Sorting
Data Analysis with Pivot Tables and Pivot Charts
Data Transformation with Power Query
Building Relationships with Power Pivot and Data Model
Charts, Visual Analytics, and Dashboard Creation

Introduction to Databases, PostgreSQL, and SQL
SELECT Queries, Filtering, and Sorting
SQL Functions and Data Types
Aggregate Functions and Data Grouping
Working with Multiple Tables and JOIN Operations
Subqueries, CTEs, and Query Combining
Working with Date, Text, and Numerical Data
INSERT, UPDATE, and DELETE Operations
Practical Exercises with PostgreSQL and Oracle SQL

Introduction to Power BI and the Main Working Environment
Connecting to Data from Various Sources
Data Cleaning and Transformation with Power Query
Building Data Models and Relationships Between Tables
DAX Functions and Creating Calculations
Charts, Tables, and Interactive Visualizations
Filters, Slicers, and KPI Indicators
Creating Professional Dashboards and Reports
Publishing, Sharing, and Updating Reports

Microsoft Office Specialist Excel (only those who wish to obtain this certification may enroll in this module).

#data analytics#python#sql#power bi#excel#statistics#data analytics#python#sql#power bi#excel#statistics

Data Analytics course

Course modules

Data Analytics with Python

Statistics and its application in Python

Data Analytics with Excel

Database Analytics with SQL

Visual Analytics with Power BI

Preparation for International Certification

Enroll Now

Who Can Enroll?

Those who want to build a career in Data Analytics

Students and Recent Graduates

For those who want to change their career path

Business Owners and Executives

Course Instructors

Enroll Now

Other Fields

Data Analytics course

Course modules

Data Analytics with Python

Statistics and its application in Python

Data Analytics with Excel

Database Analytics with SQL

Visual Analytics with Power BI

Preparation for International Certification

Enroll Now

Who Can Enroll?

Those who want to build a career in Data Analytics

Students and Recent Graduates

For those who want to change their career path

Business Owners and Executives

Course Instructors

Enroll Now

Other Fields