This 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.

Osoby które kupowały "Master Your Data with Power Query in Excel and Power BI. Leveraging Power Query to Get & Transform Your Task Flow", wybierały także:

• Databricks. Kurs video. Wst 148,98 zÅ‚, (59,59 zÅ‚ -60%)
• Apache NiFi. Kurs video. Automatyzacja przep 148,98 zÅ‚, (59,59 zÅ‚ -60%)
• Web scraping. Kurs video. Zautomatyzowane pozyskiwanie danych z sieci 139,00 zÅ‚, (55,60 zÅ‚ -60%)
• Data Science w Pythonie. Kurs video. Przetwarzanie i analiza danych 149,00 zÅ‚, (67,05 zÅ‚ -55%)
• Excel 2013. Kurs video. Poziom drugi. Przetwarzanie i analiza danych 79,00 zÅ‚, (35,55 zÅ‚ -55%)

Spis treści

Master Your Data with Power Query in Excel and Power BI. Leveraging Power Query to Get & Transform Your Task Flow eBook -- spis treści

• 1. The Data Revolution
• 2. Power Query Fundamentals
• 3. Query Management
• 4. Data Types and Errors
• 5. Moving Queries Between Excel & Power BI
• 6. Importing from Flat Files
• 7. Importing Data from Excel
• 8. Simple Transformation Techniques
• 9. Appending Data
• 10. Combining Files
• 11. Merging Data
• 12. Web Based Data Sources
• 13. Relational Data Sources
• 14. Reshaping Tabular Data
• 15. Conditional Logic in Power Query
• 16. Power Query Values
• 17. Understanding the M Language
• 18. Parameters and Custom Functions
• 19. Date and Time Techniques
• 20. Query Optimization
• 21. Automating Refresh