See how can you Automate routine tasks in Power Query in 2021 Part 3 | TRANSFORM DATA
See how can you Automate routine tasks in Power Query in 2021 Part 3 | TRANSFORM DATA This video explains how to transform data in Power Query. It include some basic operations and will be continued in next videos. Power Query is very useful for data analysis and with automation saves a lot of time spend in routine tasks.
This is third video in the series of videos about Power Query. In this series we will cover various feature of Power Query for Extraction, Transformation & Loading of data.
Here is the link to the practice file. You can download and use for your practice.
https://drive.google.com/file/d/1k0K1...
Power Query Part1 | Import data from web
• See how can you Automate routine tasks in ...
Power Query Part2 | Import data from folder
• See how can you Automate routine tasks in ...
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