What are the Best Practices in Power Query? |Tips & Tricks in Power Query |Power Query Tutorial Ep9
In this video, I have explained the tips & tricks that one should follow while working with Power Query. These would help you to work the best way with Power Query.
Timeline:
00:00 - Introduction
00:34 - Choose the right connector
01:38 - Filter early
02:49 - Use the correct data types
03:32 - Explore your data
04:43 - Document your work
05:20 - Take a modular approach
06:45 - Create Groups
07:20 - Future-proofing queries
09:14 - Use parameters
09:35 - Create reusable functions
**********************Important Links ************************
* For the DA-100 Exam Tutorial Series: youtube.com/playlist?list=PLp4MAoTwZIfcBPbzGrQlCbUZqIl36n8vy
* For the DP-203 Exam Tutorial Series: youtube.com/playlist?list=PLp4MAoTwZIfc4bq4MIN398o6OiL65vvrC
* Power BI Admin Tutorials Series: youtube.com/playlist?list=PLp4MAoTwZIfeH00b8G8UyPiV6Ej5KKoXD
* For more DAX Videos: youtube.com/playlist?list=PLp4MAoTwZIfcBuFYCLKeL5DULz8OOHky7
* For more Weekly Videos: youtube.com/playlist?list=PLp4MAoTwZIfcQKSr4DNyrWmrFxrCGN-oh
******************************************************************
1. Power BI Crash Course: youtu.be/tFmcqrhVJkg
2. How to pass DA-100 Exam: youtu.be/K3CyPOzcJR8
3. Data Classification in Power BI: youtu.be/Lw7SBX19gVE
4. Sensitivity Labels in Power B: youtu.be/g_yQYwwS4Pw
5. What is Power BI Service? youtu.be/QYyc5D514Qk
6. Power BI Data Model Analysis: youtu.be/FqQEDU_0LJc
7. Filter Propagation Concept: youtu.be/Cnvs4z4reTE
8. Dynamic Page Navigation with RLS Video: youtu.be/FrEDZZXiit8
9. Incremental Refresh in Power BI: youtu.be/F9oYnq1omnA
10. Create Date Table in Power BI: youtu.be/vyhb6Sxp8-A
11. Deployment Pipelines in Power BI: youtu.be/NUYJxTnBEDE
12. XMLA EndPoint Connectivity in Power BI: youtu.be/pwHFdvFHTP8
13. RLS Vs OLS in Power BI: youtu.be/0Tj_TqbzFMM
14. Power BI Data Gateway: youtu.be/cSDkNZK2tk8
************************************************************************
☎️ LET'S CONNECT!
************************************************************************
🐥 Twitter: twitter.com/BIConsultingPr1
☞ Instagram: instagram.com/biconsultingpro
➥ Facebook: facebook.com/biconsultingpro
🧑💻 Website: biconsultingpro.com
#powequerytutorial #bestpractices #biconsultingpro #ajaykumar #tips #tricks
-~-~~-~~~-~~-~-
Please watch: "Microsoft Azure Synapse Analytics Tutorial | Azure Synapse Studio |BI Consulting Pro |Azure Tutorial"
youtube.com/watch?v=Beg-JASGd_U
-~-~~-~~~-~~-~-
- What are the Best Practices in Power Query |Tips & Tricks in Power Query |Power Query Tutorial Ep9 ( Download)
- Power Query Best Practices ( Download)
- Top 5 easy to implement Power Query tricks ( Download)
- 5 tips to work faster and do some cool things in Power Query ( Download)
- Power Query in Power BI – 10 TIPS for improved performance and structure ( Download)
- 5 POWER Query Tricks in 2022 - Power Query Tips & Tricks [ Power BI ] ( Download)
- Power Query Tips including Excel dataflows ( Download)
- Top 3 Best Practices for Power BI | Data Exposed ( Download)
- Reduce rows & cols GOOD PRACTICE in Power Query ( Download)
- Description to Attributes with Power Query - Advanced Power Query tutorial ( Download)
- Must Know Power Query Quick Stats & Auditing Tools ( Download)
- Excel Today - Power Query Tips & Tricks ( Download)
- Microsoft Excel Office Hour 98: Power Query in the Trenches: 3 Solutions to a Data Problem ( Download)
- Power Query: Tips and Tricks | Get ResponsLIVE #103 ( Download)
- Power Query Simple Documentation Tips ( Download)
