Data Mashup with Microsoft Excel Using Power Query and M
Finding, Transforming, and Loading Data from External Sources
Taschenbuch
BOD - 2 Tage | Lieferzeit: BOD - 2 Tage I
78,64 €*
Alle Preise inkl. MwSt.| Versandkostenfrei
Sicherheits- und Produktressourcen
Bilder und Kontakte
Sicherheitsbilder- und Kontakte
Artikelnummer:
9781484260173
Veröffentlichungsdatum:
2020
Einband:
Taschenbuch
Erscheinungsdatum:
17.07.2020
Seiten:
412
Autor:
Adam Aspin
Gewicht:
771 g
Format:
254x178x23 mm
Sprache:
Englisch
Langbeschreibung
Master the art of loading external data into Excel for use in reporting, charting, dashboarding, and business intelligence. This book provides a complete and thorough explanation of Microsoft Excel's Get and Transform feature set, showing you how to connect to a range of external databases and other data sources to find data and pull that data into your local spreadsheet for further analysis. Leading databases are covered, including Microsoft Azure data sources and web sources, and you will learn how to access those sources from your Microsoft Excel spreadsheets.
Hauptbeschreibung
Makes using external data in Excel truly simple
Inhaltsverzeichnis
1. Using Power Query to Discover and Load Data into Excel.- 2. Discovering and Loading File-Based Data with Power Query.- 3. Loading Data from Databases and Data Warehouses.- 4. Loading Data from the Web and the Cloud.- 5. Generic Data Sources.- 6. Structuring Imported Data.- 7. Data Transformation.- 8. Restructuring Data.- 9. Complex Data Loads.- 10. Organizing and Managing Queries.- 11. Parameterizing Queries.- 12. The M Language.- 13. Appendix A: Sample Data.