Data Analyst: Data Analysis

Course overview

Course Name Data Analyst - with SQL, Power BI, Excel, and Python Course Description This course provides comprehensive fundamentals and practical tools for professional work as a data analyst. Participants will learn to efficiently process, analyze, and prepare structured data for data-driven decisions. The focus is on established analytical tools such as SQL, Excel, Power BI, and Python. Additionally, they will be prepared for internationally recognized certifications such as Microsoft PL-300 (Power BI Data Analyst), PL-900, and CompTIA Data+. Course Content Fundamentals of Data Analysis and Understanding Data Introduction to analytical thinking and the role of data analysts in the company. Types of data and analysis goals Data quality, data modeling, KPIs, and visualization goals SQL for Structured Data Queries Practical handling of relational databases and SQL queries. SELECT, JOIN, GROUP BY, aggregations Filtering, sorting, and simple subqueries Excel and Power BI for Visualization and Dashboards Creating meaningful reports and interactive visualizations. Pivot tables, charts, Power Query Data modeling and DAX formulas in Power BI Python Basics for Data Analysts Efficient data processing and analysis with Python. Basics with Pandas, NumPy, and visualization with Matplotlib Data import, cleaning, and exploratory analysis Certification Preparation Orientation towards established standards of data analysis certification. Microsoft PL-300, PL-900, CompTIA Data+ Task examples, exam formats, practice scenarios Conclusion After the course, participants will be able to prepare data-driven decisions using SQL, Excel, Power BI, and Python, create visualizations, and, if desired, take certifications in the field of data analysis - a solid qualification for data-oriented roles in the company.

Upcoming dates

• 2026-09-17T22:00:00.000Z · 2027-01-17T23:00:00.000Z · Bamberg · Combined Learning
• 2026-09-17T22:00:00.000Z · 2027-05-22T22:00:00.000Z · Bamberg · Combined Learning