Was Sie vorher wissen sollten
bevor Sie beginnen
Beginnt 4 June 2026 13:20
Endet 4 June 2026
00
Tage
00
Stunden
00
Minuten
00
Sekunden
12 minutes
Optionales Upgrade verfügbar
Not Specified
Lernen Sie in Ihrem eigenen Tempo
Free Video
Optionales Upgrade verfügbar
Übersicht
Lehrplan
- Introduction to Power Query
- Importing Data into Power Query
- Working with Imported Data
- Basic Data Cleaning Techniques
- Basic Data Transformation Techniques
- Conclusion and Practical Tips
- Hands-On Practice
- Course Review and Next Steps
Overview of Power Query and its applications
Navigating the Power Query interface
Importing data from Excel files
Importing data from CSV files
Connecting to databases
Importing data from web pages
Understanding the Query Editor
Exploring data preview and navigation
Removing unwanted columns and rows
Filtering data
Handling nulls and errors
Renaming columns
Changing data types
Splitting and merging columns
Tips for efficient data import and processing
Common pitfalls and solutions in data handling
Guided exercises with sample datasets
Real-world scenario application for practice
Summarizing key takeaways
Resources for further learning
Fachgebiete
Business