Daten Analysieren, um Fragen zu Beantworten

The first module covers the essential skill of organizing data before analysis. You'll learn about sorting and filtering datasets, using functions, and applying SQL queries to sort data. Practical exercises and quizzes will reinforce your understanding of these concepts.

In the second module, you'll delve into data formatting and customization. Topics include data validation, conditional formatting, transforming data in spreadsheets and SQL, and combining multiple data sources. Practical exercises and self-reflection tasks will solidify your knowledge.

Module three focuses on aggregating data for analysis. You'll explore techniques such as using SVERWEIS and JOINs, understanding COUNT and COUNT DISTINCT, and working with subqueries. Practical exercises and knowledge tests will enhance your mastery of these concepts.

The final module centers on performing data calculations. Topics include general calculation formulas, working with functions and conditions, using pivot tables, embedding calculations in SQL, and utilizing temporary tables. Engage in practical exercises and quizzes to reinforce your learning.