Data mashup with Microsoft Excel using Power Query and M : finding, transforming, and loading data from external sources

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 Excels Get and Transform feature set, showing you how to connect to a range of external databases and other...

Full description

Saved in:
Bibliographic Details
Main Author: Aspin, Adam.
Format: eBook
Language: English
Published: Berkeley, CA : Apress, 2020.
Subjects:
Microsoft Excel (Computer file)
Electronic data processing.
Statistical matching.
elektronické knihy
electronic books
ISBN: 9781484260180
148426018X
1484260171
9781484260173
Physical Description: 1 online resource (404 pages)

Cover

Table of contents

LEADER 07112cam a2200493 a 4500
001 kn-on1181833661
003 OCoLC
005 20240717213016.0
006 m o d
007 cr cn|||||||||
008 200801s2020 cau o 001 0 eng d
040 |a EBLCP  |b eng  |e pn  |c EBLCP  |d YDX  |d LQU  |d GW5XE  |d EBLCP  |d OCLCF  |d N$T  |d NLW  |d UKAHL  |d OCLCQ  |d UPM  |d OCLCQ  |d UKMGB  |d OCLCO  |d OCLCL 
020 |a 9781484260180  |q (electronic bk.) 
020 |a 148426018X  |q (electronic bk.) 
020 |z 1484260171 
020 |z 9781484260173 
024 7 |a 10.1007/978-1-4842-6018-0  |2 doi 
024 8 |a 10.1007/978-1-4842-6 
035 |a (OCoLC)1181833661  |z (OCoLC)1178713483  |z (OCoLC)1179000561  |z (OCoLC)1182461612  |z (OCoLC)1182917959  |z (OCoLC)1183934216  |z (OCoLC)1190684998  |z (OCoLC)1193273484  |z (OCoLC)1195453711  |z (OCoLC)1196166151  |z (OCoLC)1197552528  |z (OCoLC)1198148291  |z (OCoLC)1198816763 
100 1 |a Aspin, Adam. 
245 1 0 |a Data mashup with Microsoft Excel using Power Query and M :  |b finding, transforming, and loading data from external sources /  |c Adam Aspin. 
260 |a Berkeley, CA :  |b Apress,  |c 2020. 
300 |a 1 online resource (404 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
505 0 |a Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- What Is Power Query? -- Connecting to Source Data -- Data Transformation -- Loading into a Worksheet or the Data Model -- Integrating Power Query into Daily Workflows -- The Evolution of Power Query -- How to Use This Book -- On to Learning Power Query -- Chapter 1: Using Power Query to Discover and Load Data into Excel -- Power Query -- The Data Load Process -- Why Use Power Query? -- The Queries & Connections Pane -- Displaying the Queries & Connections Pane 
505 8 |a The Peek Window -- Peek Window Options -- View in Worksheet -- Deleting a Query -- Understanding Data Load -- The Navigator Dialog -- Select Multiple Source Tables -- Searching for Datasets -- Navigator Display Options -- Only Selected Items -- Enable Data Previews -- Refresh -- Source Data Refresh -- Data Preview Refresh -- Select Related Tables -- The Navigator Data Preview -- Modifying Data -- The Power Query Editor -- Data Sources -- Source Data Properties -- Query Properties -- Load Destinations -- Repurposing an Existing Connection -- Load to Excel -- Load to the Data Model -- Conclusion 
505 8 |a Chapter 2: Discovering and Loading File-Based Data with Power Query -- File Sources -- Loading Data from Files -- CSV Files -- What Is a CSV File? -- Text Files -- Text and CSV Options -- File Origin -- Delimiter -- Data Type Detection -- Fixed-Width Text Files -- Simple XML Files -- Excel Files -- Why Use Power Query to Connect to Excel -- From Table/Range -- Microsoft Access Databases -- JSON Files -- Conclusion -- Chapter 3: Loading Data from Databases and Data Warehouses -- Relational Databases -- SQL Server -- Automatically Loading Related Tables -- Database Options -- Server Connection 
505 8 |a Searching for Databases, Tables, and Views in Navigator -- Searching for Databases -- Searching for Tables -- Database Security -- Using a SQL Statement -- Stored Procedures in SQL Server -- Oracle Databases -- Other Relational Databases -- Microsoft SQL Server Analysis Services Data Sources -- From Analysis Services -- SSAS Tabular Data Warehouses -- Types of Credentials When Connecting -- Unable to Connect -- Other Database Connections -- Conclusion -- Chapter 4: Loading Data from the Web and the Cloud -- Web and Cloud Services -- Web Pages -- Online Services -- Microsoft Azure -- Web Pages 
505 8 |a Advanced Web Options -- Viewing the Source Web Page -- Salesforce -- Loading Data from Salesforce Objects -- Salesforce Reports -- Microsoft Dynamics 365 -- Azure SQL Database -- Azure SQL Data Warehouse (Azure Synapse Analytics) -- Connecting to SQL Server on an Azure Virtual Machine -- Azure Blob Storage -- Azure Security -- Other Source Types -- Conclusion -- Chapter 5: Generic Data Sources -- ODBC Sources -- OLE DB Data Sources -- OData Feeds -- OData Options -- Refreshing Data -- Refreshing the Entire Data in the Excel In-Memory Model -- Refreshing an Individual Query -- Conclusion 
500 |a Chapter 6: Structuring Imported Data 
500 |a Includes index. 
506 |a Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty 
520 |a 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 Excels 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 worlds 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. 
590 |a Knovel  |b Knovel (All titles) 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Electronic data processing. 
650 0 |a Statistical matching. 
655 7 |a elektronické knihy  |7 fd186907  |2 czenas 
655 9 |a electronic books  |2 eczenas 
776 0 8 |i Print version:  |a Aspin, Adam.  |t Data Mashup with Microsoft Excel Using Power Query and M : Finding, Transforming, and Loading Data from External Sources.  |d Berkeley, CA : Apress L.P., ©2020  |z 9781484260173 
856 4 0 |u https://proxy.k.utb.cz/login?url=https://app.knovel.com/hotlink/toc/id:kpDMMEUPQ9/data-mashup-with?kpromoter=marc  |y Full text 

Similar Items