This FULL course in Power Query, In this video will cover how to write Power query in power bi development. We go through Creating a data transformations, handling data, query folding , data preview and many more concepts.
#PowerBI #PowerBIDesktop #PowerBITutorials
▬▬▬▬▬▬▬▬ Power BI - POWER QUERY- Tutorials - FULL COURSE ▬▬▬▬▬▬▬▬
1) 03:44 - Introduction
Power Query VS Power Pivot VS Power View
2) 12:37 - Excel Transformation
Remove Headers, Rows
Fill gaps, Unpivot
Data Types
3) 25:02 - Common Transformation
Split, derive a Column , remove Column
4) 37:32 - SQL Equivalent Transformation
Append Union / Union All
Merge Left/ Right/ Inner Join
Group By
5) 59:12 - Business Scenarios
Sort by month, Derive Age, Stored in Enter data,
Reading Multiple Excels, Split the delimited value into rows,
6) 01:41:58 - Data Preview Options
7) 01:49:04 - Handling nulls or blanks
8) 01:57:53 - Query Folding in Power BI
9) 02:09:17 - Power Query Tips & Tricks
Column From Examples
Reference vs Duplicate in Power Query
Query Dependency
Change Connection source / Source Type
Source Files:
1) Excel Transformation :
docs.google.com/spreadsheets/d/1VwZX0AUExRo3CKfTBCeIBffKZuLaH1Ng/edit?usp=sharing&ouid=100165819761352551045&rtpof=true&sd=true
2) Append:
drive.google.com/file/d/1nCsHYgkiH4YSHiCUXMiZ_1gGjmg185vR/view?usp=sharing
drive.google.com/file/d/1ZCA53YaUOLVGShoavOqBIrNfAatH2TPl/view?usp=sharing
3) Merge
drive.google.com/file/d/1fu1wtLpDZFAwnYOlu5Tjl4KDV5CvZjk6/view?usp=sharing
4) Excel Automation / Reading Multiple Excel Files
drive.google.com/file/d/1wvFR-B42Z6Emuj3KgxE9YRJFKIItgayV/view?usp=sharing
drive.google.com/file/d/1qPMF4bj9HtDW4lfeSR-Kj3mMSiJRBpu2/view?usp=sharing
drive.google.com/file/d/1qPMF4bj9HtDW4lfeSR-Kj3mMSiJRBpu2/view?usp=sharing
drive.google.com/file/d/1qPMF4bj9HtDW4lfeSR-Kj3mMSiJRBpu2/view?usp=sharing
drive.google.com/file/d/1qPMF4bj9HtDW4lfeSR-Kj3mMSiJRBpu2/view?usp=sharing
drive.google.com/file/d/1qPMF4bj9HtDW4lfeSR-Kj3mMSiJRBpu2/view?usp=sharing
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬
Telegram Channel - t.me/analyticswithnags
Linkedin Page - linkedin.com/company/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 youtube.com/watch?v=T_bRcvmOMSM&list=PLjNd3r1KLjQt0xN_y8F6BSIOVNvdQmq4d
Power BI Desktop Tips and Tricks 📚📖 youtube.com/watch?v=PyFQh8MmDWo&list=PLjNd3r1KLjQv4ds9tM-HbWDrrugMADmgp
Power BI DAX - Complete Playlist 📚📖 youtube.com/watch?v=sCAQtqHINAQ&list=PLjNd3r1KLjQuVWrPuygE8QwEmCL6rrUrx
Power BI Services Playlist 📚📖 youtube.com/watch?v=F1BtmioYzGw&list=PLjNd3r1KLjQvi8p21uS522Xi3qEiFQH2r
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 youtube.com/watch?v=wS2Hw9CPJeY&list=PLjNd3r1KLjQty8rRYWwTUhS_gnzk0f2VK
Data Warehouse Tutorials 📚📖 youtube.com/watch?v=t52xNJTBicc&list=PLjNd3r1KLjQu4f2V9aa9C7NHqn-lTqppN
SQL Full Course | SQL Tutorial For Beginners 📚📖 youtube.com/watch?v=5FrBJ4PXj2s&list=PLjNd3r1KLjQtFEklcPDhidqC_2lmpjk5H
SSAS Tutorials - SQL Server Analysis Services 📚📖 youtube.com/watch?v=0YY7_k-Asmk&list=PLjNd3r1KLjQvvRu_EZ-TSydhIqNr3ZG94
SSIS Tutorials - SQL Server Integration Services 📚📖 youtube.com/watch?v=YyL88pQTFmk&list=PLjNd3r1KLjQsh6EP222gEz_XmW_DcvhXi
Power BI Interview Topics 📚📖 youtube.com/watch?v=Om_DqqvZWOM&list=PLjNd3r1KLjQtX-KTIk1_CjG5_3b5dxnGI
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 youtube.com/watch?v=bZRuQ6XJFYk&list=PLjNd3r1KLjQvj26IO4Wxz40YA198zVxP-
Excel for Data Analysis 📚📖 youtube.com/watch?v=dMBM9KamF4k&list=PLjNd3r1KLjQtfYL5UUfd92ME0CbL9uPKF
Power BI + R 📚📖 youtube.com/watch?v=dMBM9KamF4k&list=PLjNd3r1KLjQvPFEU7rlhwnw9fvBP40-2F
Azure for Analytics - Complete Tutorials 📚📖 youtube.com/watch?v=dMBM9KamF4k&list=PLjNd3r1KLjQsQqRO7qInxEeX3a4DGRj1k
Catch with Nags 📚📖 youtube.com/watch?v=_qZZCD26quw&list=PLjNd3r1KLjQstljLO-5SLmCM2AThWenqw
Nags Checklist 📚📖 youtube.com/watch?v=auQbMvQSx0w&list=PLjNd3r1KLjQv1zMF08IjuCIsG1Inuv2cF
Visuals with Nags 📚📖 youtube.com/watch?v=LfEz7jUAbEc&list=PLjNd3r1KLjQtDEEeTGmcouBc0WJQftvGv
- [[ 3 HOURS ]] Complete Power Query End to End - PowerBI Tutorial { End to End } Full Course Beginner ( Download)
- [[ 3 HOURS ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - { End to End } Full Course ( Download)
- Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡ ( Download)
- Power BI Full Course Tutorial (8+ Hours) ( Download)
- ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024) ( Download)
- Power BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | Edureka ( Download)
- Power BI Full Course in 8 Hours | Power BI Tutorial for Beginners | @PavanLalwani ( Download)
- [[ 2.5 HOURS ]] Power BI Complete Tutorial - Beginner to Pro - End to End ( Download)
- data analyst sql interview questions and answers #47/100 | Flipkart | SQL Tutorials | SQL Tutorials ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- Complete Power BI Tutorial for beginners in 3 hours | Power BI Full Course ( Download)
- Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡ ( Download)
- PQB: Power Query Basics From A to Z - Full Course, 5 hours, 17 topics, 25+ Examples ( Download)
- [[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit ( Download)
- Complete Power BI tutorial for Beginners 2024 🚀🚀(All material 🎁 included) ( Download)
