Certified Data Analyst
Data analytics, databases, data storytelling and visualization in practice - Data Analytics Online Bootcamp with mentor and Bildungsgutschein
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
Dive into the fascinating world of data analysis and analytics.
Master MySQL and SQL, essential tools for handling and managing vast datasets.
Develop proficiency in MS Excel, a fundamental skill for efficient data manipulation
Acquire a solid foundation in statistics, a key element in extracting insights from data
Learn Python for data analysis and learn to use the powerful Pandas library
Apply your skills to real-world use cases, mastering the art of data storytelling and visualization.
Learn the specifics of Power BI for creating impactful dashboards and reports.
Interested?
or
or
You will work on a project and apply the methods taught in practice.- In the process, you will be accompanied by an experienced mentor and supported in building a portfolio.
- You will receive a lot of theoretical input in the form of articles and videos.
- You can permanently check your level of knowledge by means of quizzes.
- In live trainings, you will learn how to use relevant tools in interactive settings.
- In our community, you can exchange ideas with other participants.
- In moderated live sessions, you can ask questions and exchange ideas.
- In short retrospectives, you reflect on the knowledge you have acquired and the methods you have learned.
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.
Thank you very much!
You will shortly receive an e-mail about your desired course offer.
If you cannot find an e-mail from us in your inbox, please check your spam folder or send us an e-mail to booking@xd-i-anmeldung.com.
Best regards
Your XDi-Team
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.
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!
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.
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.
Aspiring Data Analysts: Individuals with a keen interest in data analysis and a desire to build a career in the field.- Graduates and Students: Recent graduates or current students seeking to enhance their academic qualifications with practical, industry-relevant skills.
- Professionals Seeking Career Transition: Professionals from diverse backgrounds looking to transition into data analytics for career growth and new opportunities.
- Business and IT Professionals: Business analysts, IT professionals, and decision-makers aiming to leverage data for more informed and strategic decision-making.
- Entrepreneurs and Small Business Owners: Individuals involved in entrepreneurship or small business ownership who wish to harness the power of data for business insights.
- Anyone 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.
Learn more?
or
or
Accomplishments
Internationally recognized certificate
Personal Mentoring via video conference
Practical exercises with mentors
High-quality, own content with university level
Approx. 60 training videos
Practice with real case studies incl. solutions
Lots of best practices
Own final capstone project
Career services incl. job application training
Community for communication of learners
Moderated FAQ sessions with mentors
Coffee talks with mentor and participants
Live sessions with software training
Countless links, literature and tooltips
Internationally recognized certificate
Personal Mentoring via video conference
Practical exercises with mentors
High-quality, own content with university level
Approx. 60 training videos
Practice with real case studies incl. solutions
Lots of best practices
Own final capstone project
Career services incl. job application training
Community for communication of learners
Moderated FAQ sessions with mentors
Coffee talks with mentor and participants
Live sessions with software training
Countless links, literature and tooltips
CURRICULUM
MODULE 1 - WELCOME TO THE WORLD OF DATA ANALYSIS AND DATA ANALYTICS
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
MODULE 2 - DATABASES AND DATABASE MANAGEMENT SYSTEMS: MYSQL AND SQL
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
MODULE 3 - FROM ZERO TO HERO WITH MS EXCEL
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
MODULE 4 - BASIC STATISTICS FOR DATA ANALYSIS
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
MODULE 5 - DATA ANALYSIS WITH PYTHON: FROM ZERO TO PANDAS
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
MODULE 6 - EXPLORATORY DATA ANALYSIS, DATA STORYTELLING AND VISUALIZATION: 10 HANDS-ON USE CASES
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
MODULE 7 - DASHBOARDING AND REPORTING WITH POWER BI
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
MODULE 8 – A DATA ANALYTICS PROJECT FROM A TO Z
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.
Participate?
or
or
Benefits
Dates & Applications
Choose a payment option and your preferred date and register for our "Certified Data Analyst" bootcamp.
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.
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.
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!
Do you still have questions?
We are happy to support you in any way! Get in touch with us.
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. It takes 10-14 days to complete the registration process. Please keep this in mind when choosing your start date.
Next start dates
Our offer for you
Pay once the total amount of 7.248,00 €.
Next start dates
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
-
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.
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.
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!
Do you still have questions?
We are happy to support you in any way! Get in touch with us.
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. It takes 10-14 days to complete the registration process. Please keep this in mind when choosing your start date.
Next start dates
-
Our offer for you
Pay once the total amount of 7.248,00 €.
Next start dates
-
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
Short profile TESTIMONIALS
SATISFACTION GUARANTEE - 14 DAYS TRIAL
You can test this course up to 14 days after the start date without risk. If you find that the course does not meet your requirements, you can cancel your participation at no additional cost. You also have the opportunity to take part in a "Taste Course" teilzunehmen
Take part?
or
or
Contact & Callback
If you have any questions about this training, you can reach us at the email address intouch@xd-i.com and by phone at: +49 30 52001310
Whitepaper Download
Would you like to deepen your knowledge on the topics of our training courses? Then simply download one of our white papers.
INFORMATION
Guided E-Learning | Full-time / Part-time
Cancellation & Rebooking
Kostenfreie Stornierung bis 14 Tage vor Beginn- Kostenfreie Umbuchung bis 14 Tage vor Beginn
- Kostenfreie Umbuchung bei Krankheit
FAQ
Certificate
For the completed training you will receive the certificate “Certified Data Analyst” from the XDi – Experience Design Institute. The certificate is recognised by the German UPA, the Interaction Design Foundation and the UXPA and now enjoys an international reputation.
Certificated!
or
or
REFERENCES
