StackFuel Friends - Recommend StackFuel and receive €250!

> Learn more

100 % eligible with education voucher

100% Promotion possible.

Data Analyst - Basics and expertise for career changers

Further training as a data analysis specialist

Certificate of completion

(Cross) boarding

Full-time

German, English

Free of charge with education voucher

Course description

The certificate course Data Analyst - Fundamentals and Expertise for Career Changers enables you to independently perform data analyses in the context of Work 4.0 and Industry 4.0. You will acquire highly sought-after skills in the Python programming language as well as expertise in SQL and machine learning.

Successful completion of the training qualifies you for the job role of (Junior) Data Analyst or another analytical role such as (Junior) Business Intelligence Analyst or (Junior) Financial Analyst. The Data Analyst certification proves your new knowledge and skills and allows you a successful career change.

In this training you will learn

Data Analytics Skills

Python Skills

AI Skills

Fundamentals of Industry 4.0 and Work 4.0
Refreshing basic mathematics and statistics knowledge
Successful project management
Basic data and AI skills.
Tools for data analysis and data visualization with focus on SQL and Google Data Studio
Basics for data analysis with Python
Basics for Machine Learning
Best practices for communication and presentation

Target audience

The target group for the Data Analyst - Fundamentals and Expertise for Career Changers certificate course is clerical staff, office administrators and administrative staff who are unemployed, on short-time working or who are about to lose their job and who would like to have the further training funded with an education voucher from the employment agency or job center. The training is suitable for career changers and the ideal entry into a data-driven job role as a data analyst or business analyst.

Requirements for participation

This training can only be financed with an education voucher from the employment agency or job center. No programming skills or a university degree are required for the Data Analyst course. You should have a motivation for numbers, logical thinking and a routine in the daily use of computers. You must also have a B2-level knowledge of German and an A2-level knowledge of English.

Modules

1
Introduction to relational databases

The first chapter introduces you to the topic of databases. You will learn what databases are, where they are used, and why. You will understand how relational databases are constructed and familiarize yourself with their advantages and disadvantages. You will delve deeper into ER diagrams (Entity Relationship Model) and learn how to read them. You will build your knowledge around the most important SQL terms and locate SQL as the language to communicate with relational databases. You will get an overview of how this interaction works and what SQL can do.

2
Deepening SQL

In the second chapter, you will learn how to write SQL queries and read relational databases to extract company-relevant information. You will distinguish between data formats and learn about Boolean logic and filter tables with Boolean operators. In the first practical project, you will apply the previous learning content and build a toolkit to filter, group, sort, and join data.

3
Database design specialization

In the third chapter, you will focus on advanced SQL concepts and techniques and how to use them to overcome limitations of basic SQL queries. This includes 4 concepts for reusing query results: subqueries, views, Common Table Expressions (CTEs), and table creation. In multiple use cases, you will learn advanced filtering and joining methods using nested SQL queries. Additionally, you will learn how to accelerate your queries (indexes) and apply all the learning content taught so far in the second practical project.

4
SQL in practice

The final chapter focuses on the practical project. You will analyze a completely new database independently - from the first exploration to the last query. For this, we teach you two more important concepts that often come up in everyday work with SQL: you will learn how to optimally use arithmetic with SQL and how to calculate with SELECT. You also build up in-depth knowledge of analytical functions to create ranking lists or calculate running totals over longer periods of time. To do so, you determine statistical parameters such as correlations, standard deviations, and medians, create window functions, and learn to control various SQL dialects.

FAQ

Why should I choose a career in data, coding or AI?

The demand for data experts is high. Around 4 million data experts will be needed in Europe by 2025. In Germany alone, 149,000 IT jobs are currently vacant. The demand for data and AI experts in particular continues to grow enormously. But choosing a career in data is so much more than just a safe decision for the future! As a data expert, you deal with strong, socially relevant topics, are a tech professional and are communicative and creative at the same time. The job is varied, can be combined with most other professions and offers an attractive salary. And most importantly: you can learn it with us!

Am I qualified to work in this profession after further training as a data analyst and data scientist and can I make a lateral move?

Yes, after successful completion of the training, you will receive a certificate of completion from us that you can show in your job applications. Data Analysts and Data Scientists are desperately sought after in many business sectors. Even without relevant work experience, your chances of finding an entry-level job are good. In addition, there are analysts in almost every industry who have different job titles, but the skills you need are the same as those of a data analyst or data scientist.

testemonial_picture_

The StackFuel Data Lab offers me real added value. Here you can feel the practical relevance particularly well. The tasks were always clearly described and presented. So I always knew what I had to do. The course itself was a great experience!

Alexander Gross
Data Analyst at AIC Portaltechnik

testemonial_picture_

The greatest added value for me is the practical relevance. Thanks to StackFuel, I can quickly implement what I've learned and adapt it for myself. That is the real learning success behind the online courses.

Lutz Schneider
Strategic IT Buyer at Axel Springer SE

testemonial_picture_

The content of StackFuel's online course was very practical. There were plenty of good examples and projects. I found that very interesting and educational. Since the course, my day-to-day professional life has changed significantly: I am now a data analytics specialist in my department.

Jaroslaw Wojciech Sulak
Specialist for data analysis at IAV GmbH

testemonial_picture_

The user-friendly and flexible Python programming course has completely changed my view of complex data structures. Thanks to the sustainable and well thought-out learning concept as well as the seamless application of the learning content in the development environment, I can now implement the new things I've learned in my day-to-day work in test automation in more detail and process data more easily and efficiently than before.

Jenny Lindenau
Technical Manager Test Management at Bank Deutsches Kraftfahrzeuggewerbe GmbH

Let's start with a consultation.

Our consultants will be happy to help you and answer all your questions. Free of charge and without obligation. We look forward to meeting you.

Free of charge with education voucher*

(incl. VAT)

0 € with education voucher

English