Data Analyst Program - eLearning
1.450,00 EUR
- 80 hours
Turn your curiosity about data into a rewarding career as a data analyst with the immersive Data Analyst Bootcamp. Designed to take you from foundational skills to practical expertise, this bootcamp blends expert‑led instruction, hands‑on practice, and real‑world projects to ensure you’re ready for today’s data‑driven job market. This program equips you with essential skills — from data collection and manipulation to analysis and visualization — helping you confidently interpret data and present insights that drive action. You’ll master tools like Excel, SQL, Python, and Tableau while building the technical experience needed to stand out to recruiters.
Key Features
Language
Course and material in English
Level
Beginner-Intermediate level
Access
1 Year access to the learning platform
39 hours of eLearning videos
with 80+ hours study time recommended
57 Auto-Graded Assessments
and 152 Guided Hands-On Exercises
22 Assignments
with 265 Recall Quizzes
Certification
Program completion certification included
Learning Outcomes
At the end of this Course, you will be able to:
Math
Grasp the foundational concepts of Mathematics and Statistics essential for data analysis
Pivot
Work with pivot tables and perform a variety of data analyses
Database
Understand databases and SQL, and write basic SQL queries
Python
Learn Python fundamentals using Pandas and NumPy for data manipulation
Insights
Perform exploratory data analysis (EDA) and generate meaningful insights
Visualization
Create compelling data visualizations using Tableau
Course timeline
Data Analysis with Excel
Lesson 01
- Data Cleaning and Preparing
- PivotTable and Grouping for Data Analysis
- Scenario and Sensitivity Analysis
- Lookup Functions and Merging Techniques
- Charts and Visualization Techniques
- Data Analysis ToolPak for Statistics
Math and Stats Foundations
Lesson 02
- Master Descriptive Statistics and Probability Theory
- Probability distributions such as Normal, Binomial, Poisson, and many more
- Inferential Statistics to draw better inferences from the data
Data Analysis Using SQL
Lesson 03
- What is SQL and Why is it Important?
- SQL Database Admin Commands
- The Basics of SQL
- Filtering Data Using WHERE Clause in SQL
- Aggregation and Summary Functions in SQL
- Miscellaneous Analysis in SQL
- Table to Table Relationship in SQL
- Combining Tables
- Advanced SQL Data Analysis
- Making Efficient Analysis
Python for Data Analytics
Lesson 04
- Starts with the basics of Python programming
- Learn how to use the existing functions and to create the user defined functions
- Working on different Python packages such as Pandas and NumPy
- Visualizations using Python
Advanced Data Analysis with Python
Lesson 05
- Exploratory Data Analysis in Python
- Confirmatory Data Analysis in Python
- Intermediate pandas
- Unstructured Data in Python
- Working with APIs in Python
- Parallel Computing with Dask
- Intermediate Seaborn
- Interactive Visualizations with Plotly and Bokeh
Data Visualization Using Tableau
Lesson 06
- Introduction to Data Visualization and Tableau
- Understanding Tableau Building Blocks
- Managing Data connections
- Prepare Data for Use
- Basic Data Visualization
- Advanced Data Visualization
- Slicing and Dicing Data
- Tableau Basic Calculations
- Tableau Advanced Calculations
- Formatting
- Dashboard Designing
- Publishing and Sharing
Who Should Enroll in This Program?
Prerequisites
No prior experience is required to join this program. While a basic understanding of Mathematics, Statistics, or Python can be helpful, it’s not mandatory.
Aspiring Data Analysts
Career Changers
Business Analysts & IT Professionals
Anyone Seeking Upskilling
Statements
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!