See how can you Automate routine tasks in Power Query in 2021 Part 1 | IMPORT DATA FROM WEB
See how can you Automate routine tasks in Power Query in 2021 Part 1 | IMPORT DATA FROM WEB. This video introduce Power Query and explains what and how it can be used with the help of a example. It also explains what is ETL (Extraction, Transformation & Loading tool). Power Query is very useful data analysis and with automation saves a lot of time spend in routine tasks.
This is first in the series of videos about Power Query. It has covered the introduction and in subsequent videos it will be explained in detail with all the features it offers.
Visit & Subscribe channel:
https://www.youtube.com/c/TechReflect...
This video lecture is part of the videos on Excel and it tools.
Welcome to Tech Reflections (#techreflections) & I am Vikram.
Leave a comment on this video and let me know what all you want us to cover in coming videos of this series.
Playlists on this channel:
Pivot Tables & its features
• Pivot Tables & its features
Excel - Conditional Formatting?
• Excel - Conditional Formatting
How to create Gantt Chart?
• How to create Gantt Chart?
How FILTER function works?
• How FILTER function works?
How Lookup Functions work?
• How Lookup Functions work?
How to use INDEX & MATCH function?
• How to use INDEX & MATCH function?
Google Sheets Tools Formulae (Compared with Excel)
• Google Sheets Tools & Formulae (Compared w...
Excel Tools & Formulae
• Excel Tools & Formulae
Excel Keyboard Shortcuts
• Excel Keyboard Shortcuts
Excel - Formulae & Functions
• Excel - Formulae & Functions
Excel - Tools & Applications
• Excel - Tools & Functions Applications
Powerpoint Hacks
• Powerpoint Hacks
#techreflections #powerquery #etltool