Learning Power Query : Simplify data cleaning and analysis with Excel's most powerful tool
Description: In a time where data drives decision-making, Excel continues to be a vital resource for professionals. Power Query greatly enhances its functionality. As businesses increasingly seek automation and scalable solutions, proficiency in Power Query and the M language is a crucial advantage...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Livre numérique |
| Sprache: | Anglais |
| Veröffentlicht: |
New Delhi :
BPB Publications
2025.
Paris : Cyberlibris |
| Online Zugang: | Accès Université d'Orléans et IFPM |
| Anmerkung: |
Couverture. https://static2.cyberlibris.com/books_upload/300pix/9789365891539.jpg Cyberlibris (ScholarVox) corpus Informatique |
| Autres localisations: | Voir dans le Sudoc |
| Edition sous un autre format: | • Learning Power Query, Simplify data cleaning and analysis with Excel's most powerful tool, Adam Szczepan Kopeć, New Delhi, BPB Publications, 2025, 1 vol. (480 p.), 978-93-6589-153-9 |
Inhaltsangabe:
- 1. Getting Started with Power Query
- 2. Advanced Data Connections and Imports
- 3. Combining Data Queries
- 4. Grouping Data
- 5. Pivot and Unpivot
- 6. Adding Columns
- 7. Logical Operations and Conditional Columns
- 8. Parameters and Query Parameterization
- 9. Creating Custom Functions
- 10. Examples Using M Language
- 11. Optimization and Extensions