Tuesday, August 19, 2025

Power Query ( ETL Tool ) : - Extract Transform Load

Reference Link : https://www.youtube.com/watch?v=W6Fg6B3Gklc 


IMPORTANT : Power queries also known as Automation Because all Steps Record and we can used further


Query Setting:-

1. Source ( Source of Data )

2. Chang type ( Types of data type Automatically )


Document : Used This for Notes

OneNotes : For Notes


Important Things : data to promote header

Formula :- Table.PromoteHeaders(Excel.Workbook([column_name]) for CSV Csv.Document[(column_name)])



Master Class 2



-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL _ ( Structure Query Language )

🎉 Welcome to SQL Learning! 🎉 Today marks your first step into the world of SQL—Structured Query Language. Whether you're aiming to be...

  • Getting Started a Data Analytics
    Starting with Data Analytics   1. SQL : Basic CURD Operation, Create Undo Read and Delete & Joins and Primary Key ETC. SQL Learning Mail...
  • Power Query ( ETL Tool ) : - Extract Transform Load
    Reference Link : https://www.youtube.com/watch?v=W6Fg6B3Gklc  IMPORTANT : Power queries also known as Automation Because all Steps Record a...
  • Job Related
    Simple Cold DM Hi Recruter Name , I got your number from Source of Number and Contact . I’ve applied for the Operations and Data-related ro...