⚽ Register with the code EM2024 for our bootcamps by 14th July 2024 & receive a €200 voucher

All Courses

Certified Data Analyst

Data analytics, databases, data storytelling and visualization in practice - Data Analytics Online Bootcamp with mentor and Bildungsgutschein

Bildungs- gutschein
E-Learning Bootcamp
Personal Mentoring
Flexible Learning Time
Job Ready Practice
 

INTRODUCTION TO DATA ANALYSIS

Embark on a journey into the dynamic realm of data analytics with our Certified Data Analyst course. Dive into the essentials of databases, including MySQL and SQL, and gain proficiency in MS Excel for data manipulation. Acquire in-demand data analysis skills: From basic statistics to advanced Python data analysis using Pandas, NumPy, Matplotlib, and Seaborn. With hands-on assignments, you will master exploratory data analysis, data storytelling, and visualization techniques. You will learn to create interactive reports and dashboards with Power BI. Finally, you will apply your new skills to solve a real-world data analysis challenge with a comprehensive Capstone Project. As a Certified Data Analyst, a new world of career opportunities in data analysis will be at your fingertips.

CONTENT

Welcome to the World of Data Analysis and Data Analytics

Dive into the fascinating world of data analysis and analytics.

Databases and Database Management Systems: MySQL and SQL

Master MySQL and SQL, essential tools for handling and managing vast datasets.

From Zero to Hero with MS Excel

Develop proficiency in MS Excel, a fundamental skill for efficient data manipulation

Basic Statistics for Data Analysis

Acquire a solid foundation in statistics, a key element in extracting insights from data

Data Analysis with Python: From Zero to Pandas

Learn Python for data analysis and learn to use the powerful Pandas library

Exploratory Data Analysis, Data Storytelling and Visualization: 10 Hands-on Use Cases

Apply your skills to real-world use cases, mastering the art of data storytelling and visualization.

Dashboarding and Reporting with Power BI

Learn the specifics of Power BI for creating impactful dashboards and reports.

LEARNING JOURNEY

Start your learning journey to become a "Certified Data Analyst"

  • bulletYou will work on a project and apply the methods taught in practice.
  • bulletIn the process, you will be accompanied by an experienced mentor and supported in building a portfolio.
  • bulletYou will receive a lot of theoretical input in the form of articles and videos.
  • bulletYou can permanently check your level of knowledge by means of quizzes.
  • bulletIn live trainings, you will learn how to use relevant tools in interactive settings.
  • bulletIn our community, you can exchange ideas with other participants. 
  • bulletIn moderated live sessions, you can ask questions and exchange ideas.
  • bulletIn short retrospectives, you reflect on the knowledge you have acquired and the methods you have learned.
XDi_Weiterbildung_Bildungsgutschein

Course offer for your education voucher (Bildungsgutschein)

Would you like to finance your course with an education voucher (Bildungsgutschein) from the Federal Employment Agency? Then request a non-binding course offer now.

Request a course offer
WHAT TO EXPECT IN THE DATA ANALYST COURSE?

As a the Certified Data Analyst course participant, you can expect a transformative learning experience that equips you with a comprehensive skill set in data analysis. The program covers foundational concepts, hands-on application of industry-standard tools like MySQL and SQL, proficiency in data manipulation using Excel and Python, and the creation of visualizations with Power BI. Through both practical projects and a capstone project, you gain real-world experience and showcase your in-demand data analysis skills. The course not only prepares you for roles such as Data Analyst or Junior Data Scientist but also fosters critical thinking, problem-solving, and effective communication.

    WHAT WILL YOU LEARN IN THE DATA ANALYST COURSE?

    The Certified Data Analyst course covers essential learning objectives to empower you in mastering data analysis. First, you will develop a solid foundation in data analysis concepts and the significance of data-driven decision-making. You will acquire proficiency in database management with MySQL and SQL. The course emphasizes data manipulation and visualization skills with Microsoft Excel, from basic functions to advanced features.

    The next step is statistics. Here, you will cultivate statistical knowledge, so you can interpret data and learn to make informed decisions. The programming portion of the course introduces Python, focusing on the Pandas library for data manipulation and exploration. You will gain practical experience in data storytelling and visualization — A boost to your resume!

    Solid skills in dashboarding and reporting belong in the repertoire of modern data analysts. That’s why we’ve dedicated an entire section to Power BI for business analytics, with a special focus on the creation of visually appealing dashboards and reports. You will conclude the course with a capstone project that challenges you to integrate your newly acquired skills, solve real-world problems, and showcase your proficiency. Benefits of the course include: skill mastery, job readiness, and an industry-recognized certification.

    You will be eligible for roles like Data Analyst, Junior Data Scientist, or Business Analyst, across diverse industries such as finance, healthcare, marketing, and technology. Position yourself for a promising career in data analytics and become an invaluable asset for organizations wanting to make data-driven decisions!

    WHAT ARE THE PREREQUISITES FOR THE COURSE?

    The course is designed to cater to a broad audience. Participants, regardless of their current skill set or industry background, can gain valuable insights and practical skills in data analysis. Whether you are starting your career, seeking a career transition, or aiming to enhance your business acumen, the Certified Data Analyst course provides a comprehensive foundation for success in the dynamic field of data analytics. You need a standard computer (laptop/PC) with a Windows operating system and internet access.

    WHO SHOULD ATTEND THE DATA ANALYST COURSE

    You can take part in this online course with an Bildungsgutschein from the Employment Agency. If you are registered as looking for a job, you can apply for an education voucher at the Employment Agency. We have created an application guide for this.

    • bulletAspiring Data Analysts: Individuals with a keen interest in data analysis and a desire to build a career in the field.
    • bulletGraduates and Students: Recent graduates or current students seeking to enhance their academic qualifications with practical, industry-relevant skills.
    • bulletProfessionals Seeking Career Transition: Professionals from diverse backgrounds looking to transition into data analytics for career growth and new opportunities.
    • bulletBusiness and IT Professionals: Business analysts, IT professionals, and decision-makers aiming to leverage data for more informed and strategic decision-making.
    • bulletEntrepreneurs and Small Business Owners: Individuals involved in entrepreneurship or small business ownership who wish to harness the power of data for business insights.
    • bulletAnyone Interested in Data-Driven Insights: Individuals curious about data analysis, regardless of their background, who want to understand and leverage data for personal or professional purposes.

    Accomplishments

    CURRICULUM

    Introduction and welcome
    Course Overview, Importance of Data Analysis

    Data analysis: Tools, data sources, project planning, and process steps
    Data Analysis Tools, Data Sources, Project Planning, Process Steps, Data Exploration  

    Practice: Deepen your knowledge of tools, data structures, analysis process steps, and project planning elements 

    An exemplary data analysis project: Survey responses from StackOverflow
    Exemplary Project, Survey Data Analysis, StackOverflow Dataset, Project Demonstration, Insights and Findings, Visualization Techniques, Interpretation of Results, Practical Application  

    Practice: Familiarize yourself with fundamental EDA concepts, such as descriptive statistics and data visualization types and tools 

    Introduction: The relational database model and SQL
    Database Concepts, SQL Basics, Relational Database Overview, Structured Query Language

    Installation and first steps with MySQL Workbench
    MySQL Workbench, Installation Procedure, Configuring MySQL Environment

    Getting started: Creating a database and tables
    Database Creation, Table Design, Schema Definition

    Practice: Create your first SQL database and insert tables into this database

    Inserting, editing, and querying values
    Data Insertion, Data Editing, Basic Queries

    Practice: Manipulating data with SQL syntax

    Additional options for using the WHERE clause
    Conditional Filtering, WHERE Clause Functions

    Practice: Creating specific requirements for the WHERE clause

    Using foreign keys in the database
    Foreign Key Concept, Referential Integrity

    Practice: Understand and use foreign keys within a SQL database

    Connecting queries for multiple tables
    Multiple Table Relationships, JOIN Operations

    Practice: Designing queries for multiple tables

    The JOIN command: Using data from multiple tables
    Multiple Table Relationships, JOIN Operations

    Practice: Working with the JOIN command

    Counting entries, summing values, and other arithmetic operations
    Aggregate Functions, Arithmetic Operations

    Practice: Performing arithmetic operations with values

    Grouping and sorting data
    Data Grouping, Sorting Techniques

    Practice: Creating grouped and sorted queries

    Introduction: Data analysis with MS Excel
    Excel Overview, Data Analysis Basics, Spreadsheet Application

    Basics of Excel tables
    Table Structures, Data Formatting, Cell Functions

    Practice: Create your first fully blown Excel tables

    Preparing, manipulating, and cleaning data
    Data Preparation, Data Manipulation, Data Cleaning Techniques

    Practice: Sorting and filtering table records

    PivotTables: Basics
    PivotTable Introduction, PivotTable Creation, Basic Operations

    Practice: Building an exemplary PivotTable from business context data

    More on PivotTables
    Advanced PivotTable Features, Data Filtering, PivotTable Customization

    Practice: Playing around with PivotTables

    Creating and applying PivotTable formulas
    PivotTable Formulas, Calculations in PivotTables, Formula Application

    Practice: Creating and applying PivotTable formulas

    Using PivotCharts
    PivotChart Creation, Data Visualization, Chart Customization

    Practice: Understanding, building, and using PivotCharts

    Introduction: Baseline statistics
    Statistical Foundations, Central Tendency, Data Variability

    Using Excel’s database functions for statistical data analysis
    Excel Database Functions, Statistical Analysis in Excel, Practical Applications

    Practice: Learn to apply DCOUNT and DAVERAGE

    More on Excel’s statistical database functions
    Advanced Database Functions, Complex Statistical Analyses, Function Optimization

    Practice: The power of DSUM, DPRODUCT, DMIN, DMAX, and DSTEDV

    Descriptive statistics
    Data Summarization, Measures of Dispersion, Graphical Representation

    Practice: Apply Excel’s Data Analysis TOOLPAK Add-in

    Mathematical statistics
    Probability Distributions, Statistical Inference, Regression Analysis

    Practice: Build scatter plots, construct t-tests, estimate linear regressions, and more

    Numerical optimization
    Optimization Techniques, Linear and Nonlinear Optimization, Practical Applications

    Practice: Learn to love Excel’s Solver

    Introduction: The wonderful world of Python, Pandas, Numpy, and Matplotlib
    Python Basics, Data Analysis Tools, Introduction to Libraries

    Installation of Anaconda and Jupyter Notebooks
    Anaconda Setup, Jupyter Notebooks Installation, Environment Configuration

    First steps with Python and Jupyter Notebooks
    Python Syntax, Jupyter Notebook Essentials, Basic Operations

    Practice: Use Python as a calculator

    Variables and data types
    Variable Creation, Data Types in Python, Working with Variables

    Practice: Build your first Python variables in the context of business applications

    Branching and loops
    Conditional Statements, Loop Structures, Control Flow in Python

    Practice: Develop advanced looping structures to automate workflow in the context of business applications

    Functions and scope
    Function Creation, Function Arguments, Scope and Lifetime

    Practice: Write some great Python functions

    Numerical computing with NumPy
    Introduction to NumPy, Array Operations, NumPy Applications

    Practice: Learn the power of NumPy arrays

    Data analysis with Pandas
    Pandas Basics, Data Manipulation, Exploratory Data Analysis

    Practice: Apply Pandas to solve short but smart business data applications

    External data (API) and internal data (SQL)
    Working with APIs, SQL Queries in Jupyter, Combining External and Internal Data

    Practice: Learn to load external and internal data into Pandas Data Frames

    Data visualization with Matplotlib
    Matplotlib Basics, Plotting Techniques, Customizing Visualizations

    Practice: Boost your visualization skills with Matplotlib

    Introduction
    Overview, Importance of Exploratory Data Analysis, Introduction to Data Storytelling 

    Use Case 1 – StackOverflow
    Developer Survey, Programming Trends, StackOverflow Data Analysis

    Practice: EDA with StackOverflow survey response data

    Use Case 2 – COVID-19
    Pandemic Analysis, Spread Patterns, Impact Assessment

    Practice: EDA with COVID-19 country-level data

    Use Case 3 – Heart failure
    Medical Data Analysis, Predictive Modeling, Patient Outcomes

    Practice: EDA with heart failure data

    Use Case 4 – FIFA 21
    Sports Data Exploration, Player Performance, Team Analysis

    Practice: EDA with FIFA 21 data of soccer players and leagues

    Use Case 5 – Cardiac patients
    Healthcare Analytics, Patient Health Insights, Treatment Effectiveness

    Practice: EDA with healthcare and patients’ data

    Use Case 6 – Netflix movies and TV shows
    Entertainment Industry Analysis, Viewer Preferences, Content Trends

    Practice: EDA with Netflix movies and TV shows data

    Use Case 7 – Formula 1
    Motorsports Analytics, Driver Performance, Race Strategies

    Practice: EDA with Formula 1 drivers’ data

    Use Case 8 – National happiness
    Social Analysis, Factors Influencing Happiness, Global Comparison

    Practice: EDA with data about variation in country-level happiness of people

    Use Case 9 – Videogames sales
    Gaming Industry Insights, Sales Patterns, Genre Preferences

    Practice: EDA of videogames sales across various countries

    Use Case 10 – Pokemon with stats
    Gaming Data Exploration, Pokemon Characteristics, Player Interactions

    Practice: EDA with Pokemon characteristics data

    Introduction: Power BI
    Power BI Overview, Business Intelligence Tools, Data Visualization

    Getting started with Power BI Desktop
    Power BI Desktop Interface, Data Import, Connecting to Data Sources

    Practice: Prepare your data for Power BI

    Creating data sources in Power BI
    Building Data Models, Query Editor, Data Transformation

    Practice: Build your first data model in Power BI

    Creating visualizations
    Visualization Types, Customizing Visuals, Formatting Options

    Practice: Learn to customize your visuals

    Aggregations, calculations, and parameters
    Aggregation Functions, Calculated Fields, Parameterization

    Practice: Apply aggregation functions for advanced calculations

    Calculations with DAX expressions
    Introduction to DAX, DAX Functions, Advanced DAX Concepts

    Practice: Learn to write your own DAX expressions

    Interactive dashboards
    Building Dashboards, Dashboard Interactivity

    Practice: Build your first interactive dashboard

    Sharing reports with Power BI Online
    Power BI Online Platform, Sharing and Collaboration, Access Control and Permissions

    Practice: Learn to share your dashboard with colleagues

    Bundle all your skills in a practice-oriented project and demonstrate your expertise as a certified data analyst. You will develop your own project based on the knowledge you have acquired and apply the techniques you have learnt in practice.

    Benefits

    Dates & Applications

    Choose a payment option and your preferred date and register for our "Certified Data Analyst" bootcamp.

    I already have a "Bildungsgutschein"
    I do not have a "Bildungsgutschein" yet

    If you are registered in Germany and are looking for work or you are about to be made redundant, then you can apply for an education voucher at the employment agency. To find out if you are eligible for an education voucher, you will need to speak with your local employment agency. If you meet the requirements, you will receive an education voucher that entitles you to attend this XDi continuing education program free of charge. To get a step-by-step guide to this process, then take a look at our "Application Guide".

    Find your local "Agentur für Arbeit" and make an appointment

    If you have never been in contact with the employment agency before, simply find your local employment agency by searching online, e.g. "Agentur für Arbeit Köln" or "Agentur für Arbeit in meiner Nähe". Once you have made an appointment, you will be assigned an advisor.

    Find your local Arbeitsagentur

    Step-by-step instructions for applying for an education voucher (Bildungsgutschein) at the Agentur für Arbeit

    Use our complete application guide to prepare for your employment with the employment agency and convince your advisor to approve your participation in the course. It contains the documents you need for the appointment.

    Aplication guide

    Request your personal course proposal from the XDi

    You may need to provide this document to the employment agency. This will only take a few minutes!

    Request course proposal

    Do you still have questions?

    We are happy to support you in any way! Get in touch with us.

    Get in touch

    You have an education voucher (Bildungsgutschein) from the employment agency (Agentur für Arbeit) and would like to be trained as a "Certified User Experience Designer"! Then you can start now - you can register.

    Next start dates

    Monday, 24.06.2024
    Monday, 24.06.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 01.07.2024
    Monday, 01.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 08.07.2024
    Monday, 08.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 15.07.2024
    Monday, 15.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 22.07.2024
    Monday, 22.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 29.07.2024
    Monday, 29.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 05.08.2024
    Monday, 05.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 12.08.2024
    Monday, 12.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 19.08.2024
    Monday, 19.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 26.08.2024
    Monday, 26.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 02.09.2024
    Monday, 02.09.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 09.09.2024
    Monday, 09.09.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed

    Our offer for you

    Pay once the total amount of 7.248,00 €.

    Next start dates

    Monday, 24.06.2024
    Monday, 24.06.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 01.07.2024
    Monday, 01.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 08.07.2024
    Monday, 08.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 15.07.2024
    Monday, 15.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 22.07.2024
    Monday, 22.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 29.07.2024
    Monday, 29.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 05.08.2024
    Monday, 05.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 12.08.2024
    Monday, 12.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 19.08.2024
    Monday, 19.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 26.08.2024
    Monday, 26.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 02.09.2024
    Monday, 02.09.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 09.09.2024
    Monday, 09.09.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed

    Our offer for you

    Pay a one-time fee of 3.150,00 € to secure your place in the training. After that, you conveniently pay 2x 2.200,00 € in intervals of 30 days, starting four weeks after the start of your continuing education.

    Next start dates

    Monday, 24.06.2024
    Monday, 24.06.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 01.07.2024
    Monday, 01.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 08.07.2024
    Monday, 08.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 15.07.2024
    Monday, 15.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 22.07.2024
    Monday, 22.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 29.07.2024
    Monday, 29.07.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 05.08.2024
    Monday, 05.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 12.08.2024
    Monday, 12.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 19.08.2024
    Monday, 19.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 26.08.2024
    Monday, 26.08.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 02.09.2024
    Monday, 02.09.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed
    Monday, 09.09.2024
    Monday, 09.09.2024
    Enough places
    Max 8 Participant
    Enough places
    Execution guaranteed