Power Query Editor Bootcamp in Tamil: 15-Day Learning Plan
Welcome to the Power Query Editor Bootcamp in Tamil! This 15-day bootcamp is designed to guide you through the essentials of Power Query in Microsoft Power BI, with live sessions and problem-solving exercises to solidify your learning. This program is perfect for beginners and intermediate learners who want to enhance their data transformation and analysis skills.
Resources
- GitHub Repository for Data Access: https://github.com/Gomathikrishna
- Power BI Tamil Playlist: https://www.youtube.com/playlist?list=PL9FfW__Sm3pLffXsQwRJDBJK0ZWSH99Ts
Bootcamp Agenda
Power Query Editor Bootcamp Agenda
| Day | Title | Reference | Live Session Date | Live Session Link |
|---|---|---|---|---|
| Day 1 | Import Data Remove top rows Promote headers Remove blank columns Remove staff with no salary Extracting country from address to new column |
GitHub Repository | 24-Nov-24 | |
| Day 2 | Exercise - Problem Statement | GitHub Repository | 25-Nov-24 | |
| Day 3 | Solution Discussion | GitHub Repository | 26-Nov-24 | |
| Day 4 | Transform Tab - Introduction Replace Values Pivot Transpose Split Column - Removing the dollar symbol from Salary |
GitHub Repository | 27-Nov-24 | |
| Day 5 | Exercise - Problem Statement | GitHub Repository | 28-Nov-24 | |
| Day 6 | Solution Discussion | GitHub Repository | 29-Nov-24 | |
| Day 7 | Add Column Tab - Introduction Column From Example Custom Column Index Column Duplicate Column |
GitHub Repository | 30-Dec-24 | |
| Day 8 | Exercise - Problem Statement | GitHub Repository | 1-Dec-24 | |
| Day 9 | Solution Discussion | GitHub Repository | 2-Dec-24 | |
| Day 10 | View Tab | GitHub Repository | 3-Dec-24 | |
| Day 11 | Exercise - Problem Statement | GitHub Repository | 4-Dec-24 | |
| Day 12 | Solution Discussion | GitHub Repository | 5-Dec-24 | |
| Day 13 | Tools Tab Merge Join |
GitHub Repository | 6-Dec-24 | |
| Day 14 | Exercise - Problem Statement | GitHub Repository | 7-Dec-24 | |
| Day 15 | Solution Discussion | GitHub Repository | 8-Dec-24 |
Each day is structured to provide a comprehensive understanding of Power Query Editor functionalities in Power BI, with hands-on exercises and solution discussions to support your learning. Make sure to join the live sessions on the specified dates to make the most out of this bootcamp!
0 Comments