LEADER 03655nam  2200469zu 450 
001 9911006712003321
005 20250709211829.0
010   $a9781836646648
010   $a183664664X
035   $a(CKB)36251583200041
035   $a(FR-PaCSA)88958861
035   $a(FRCYB88958861)88958861
035   $a(DE-B1597)728018
035   $a(DE-B1597)9781836646648
035   $a(EXLCZ)9936251583200041
100   $a20250310d2024      u|         |
101 0 $aeng
135   $aur|||||||||||
181   $ctxt$2rdacontent
182   $cc$2rdamedia
183   $acr$2rdacarrier
200 10$aMaster Your Data with Power Query in Excel and Power BI$eLeveraging Power Query to Get & Transform Your Task Flow$fBooks, Mrexcel'S Holy Macro! [and others]
210  1$aBirmingham, England$cPackt Publishing$d2024
215   $a1 online resource (386 p.) 
311 08$a9781836646655 
311 08$a1836646658 
327   $tMaster Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
330   $aMaster data transformation techniques using Power Query in Excel and Power BI. Learn to manage, optimize, and automate your data workflows with practical examples.Key FeaturesComprehensive coverage of Power Query from basics to advanced techniquesSeamless integration and movement of queries between Excel and Power BIHands-on practice with real-world data scenarios to build your confidenceBook DescriptionThis book equips you with the essential skills to master Power Query in Excel and Power BI. Starting with the basics, you'll learn query management, data types, and error handling, establishing a solid foundation. You'll explore techniques to move queries between Excel and Power BI, ensuring seamless workflow integration. As the guide progresses, you'll delve into data import methods from flat files, Excel, web-based, and relational sources, while performing key transformations like appending, combining, and reshaping data. Advanced topics such as conditional logic, Power Query values, and M Language fundamentals will enhance your ability to customize and optimize queries. The book also covers the creation of parameters and custom functions, alongside applying sophisticated date and time techniques. Finally, you'll learn to optimize query performance and automate data refreshes, ensuring your analysis remains current. By the end of this guide, you'll have the confidence and expertise to effectively transform and manage data using Power Query, significantly enhancing your data analysis capabilities in Excel and Power BI.What you will learnUnderstand Power Query fundamentalsManage queries effectivelyTransform and cleanse dataImport data from diverse sourcesUtilize advanced features like M languageAutomate and optimize data processesWho this book is forIdeal for data analysts, Excel users, and Power BI enthusiasts looking to streamline data processing. Readers should have a basic understanding of Excel and data handling concepts. No prior knowledge of Power Query is required.
606   $aCOMPUTERS / Data Processing$2bisacsh
606   $aCOMPUTERS / Databases / Servers$2bisacsh
606   $aCOMPUTERS / Expert Systems$2bisacsh
615  7$aCOMPUTERS / Data Processing
615  7$aCOMPUTERS / Databases / Servers
615  7$aCOMPUTERS / Expert Systems
700   $aBooks$b Mrexcel'S Holy Macro!$01824588
701   $aEscobar$b Miguel$01824589
701   $aPuls$b Ken$01824590
801  0$bFR-PaCSA
906   $aBOOK
912   $a9911006712003321
996   $aMaster Your Data with Power Query in Excel and Power BI$94391808
997   $aUNINA