Data Mashup with Microsoft Excel Using Power Query and M Finding, Transforming, and Loading Data from External Sources
Afbeeldingen
Sla de afbeeldingen overArtikel vergelijken
Auteur:
Adam Aspin
- Engels
- Paperback
- 9781484260173
- 17 juli 2020
- 388 pagina's
Samenvatting
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.
Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources.
Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world’s leading analytics tool.
You will:
Getting data into Excel is a prerequisite for using Excel's analytics capabilities. This book takes you beyond copying and pasting by showing you how to connect to your corporate databases that are hosted in the Azure cloud, and how to pull data from Oracle Database and SQL Server, and other sources.
Accessing data is only half the problem, and the other half involves cleansing and rearranging your data to make it useful in spreadsheet form. Author Adam Aspin shows you how to create datasets and transformations. For advanced problems, there is help on the M language that is built into Excel, specifically to support mashing up data in support of business intelligence and analysis. If you are an Excel user, you won't want to be without this book that teaches you to extract and prepare external data ready for use in what is arguably the world’s leading analytics tool.
You will:
- Connect to a range of external data, from databases to Azure sources
- Ingest data directly into your spreadsheets, or into PowerPivot data models
- Cleanse and prepare external data so it can be used inside Excel
- Refresh data quickly and easily to always have the latest information
- Transform data into ready-to-use structures that fit the spreadsheet format
- Execute M language functions for complex data transformations
Productspecificaties
Wij vonden geen specificaties voor jouw zoekopdracht '{SEARCH}'.
Inhoud
- Taal
- en
- Bindwijze
- Paperback
- Oorspronkelijke releasedatum
- 17 juli 2020
- Aantal pagina's
- 388
- Illustraties
- Nee
Betrokkenen
- Hoofdauteur
- Adam Aspin
- Hoofduitgeverij
- Apress
Overige kenmerken
- Editie
- 1st ed.
- Extra groot lettertype
- Nee
- Product breedte
- 178 mm
- Product lengte
- 254 mm
- Studieboek
- Ja
- Verpakking breedte
- 172 mm
- Verpakking hoogte
- 27 mm
- Verpakking lengte
- 249 mm
- Verpakkingsgewicht
- 962 g
EAN
- EAN
- 9781484260173
Je vindt dit artikel in
- Categorieën
- Taal
- Engels
- Beschikbaarheid
- Leverbaar
- Boek, ebook of luisterboek?
- Boek
- Studieboek of algemeen
- Studieboeken
Kies gewenste uitvoering
Kies je bindwijze
(2)
Prijsinformatie en bestellen
De prijs van dit product is 83 euro en 99 cent. De meest getoonde prijs is 90 euro en 99 cent. Je bespaart 8%.
Je bespaart 8%
1 - 2 weken
Verkoop door
Roelants
- Bestellen en betalen via bol
- Prijs inclusief verzendkosten, verstuurd door Roelants
- 30 dagen bedenktijd en gratis retourneren
- Wettelijke garantie via Roelants
Shop dit artikel
Vaak samen gekocht
Rapporteer dit artikel
Je wilt melding doen van illegale inhoud over dit artikel:
- Ik wil melding doen als klant
- Ik wil melding doen als autoriteit of trusted flagger
- Ik wil melding doen als partner
- Ik wil melding doen als merkhouder
Geen klant, autoriteit, trusted flagger, merkhouder of partner? Gebruik dan onderstaande link om melding te doen.