What You Need to Know Before
You Start
Starts 10 June 2025 02:53
Ends 10 June 2025
00
days
00
hours
00
minutes
00
seconds
How to Import External Data in Power Query - Beginners Guide
Learn how to import external data in Power Query with this step-by-step guide. Connect to Excel files, CSV files, databases, and web pages, then explore basic data cleaning and transformation techniques for your analysis needs.
Simon Sez IT
via YouTube
Simon Sez IT
2565 Courses
12 minutes
Optional upgrade avallable
Not Specified
Progress at your own speed
Free Video
Optional upgrade avallable
Overview
Learn how to import external data in Power Query with this step-by-step guide. Connect to Excel files, CSV files, databases, and web pages, then explore basic data cleaning and transformation techniques for your analysis needs.
Syllabus
- 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
Subjects
Business
