LEADER 02599nam 2200649Ia 450 001 9910461878303321 005 20200520144314.0 010 $a0-292-73931-1 035 $a(CKB)2670000000273632 035 $a(SSID)ssj0000755021 035 $a(PQKBManifestationID)11424367 035 $a(PQKBTitleCode)TC0000755021 035 $a(PQKBWorkID)10727347 035 $a(PQKB)10178590 035 $a(MiAaPQ)EBC3443623 035 $a(OCoLC)859673164 035 $a(MdBmJHUP)muse17587 035 $a(Au-PeEL)EBL3443623 035 $a(CaPaEBR)ebr10608363 035 $a(OCoLC)814230247 035 $a(EXLCZ)992670000000273632 100 $a20120601d2012 ub 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aAmericans all$b[electronic resource] $egood neighbor cultural diplomacy in World War II /$fby Darlene J. Sadlier 205 $a1st ed. 210 $aAustin $cUniversity of Texas Press$d2012 215 $axii, 251 p. $cill., ports 225 0 $aJoe R. and Teresa Lozano Long series in Latin American and Latino art and culture 300 $aBibliographic Level Mode of Issuance: Monograph 311 $a0-292-73930-3 320 $aIncludes bibliographical references and index. 327 $aThe Culture Industry Goes to War -- On Screen : The Motion Picture Division -- On the Air : The Radio Division -- In Print : The Press and Publication Division -- In Museums, Libraries, and on the Home Front : The Divisions of Cultural Relations and Inter-American Affairs in the United States -- Aftermath. 606 $aWorld War, 1939-1945$xDiplomatic history 606 $aCultural industries$xPolitical aspects$zUnited States$xHistory$y20th century 606 $aPopular culture$xPolitical aspects$zUnited States$xHistory$y20th century 607 $aUnited States$xRelations$zLatin America 607 $aLatin America$xRelations$zUnited States 607 $aUnited States$xCultural policy 607 $aUnited States$xForeign relations$y1933-1945 607 $aUnited States$xIntellectual life$y20th century 608 $aElectronic books. 615 0$aWorld War, 1939-1945$xDiplomatic history. 615 0$aCultural industries$xPolitical aspects$xHistory 615 0$aPopular culture$xPolitical aspects$xHistory 676 $a327.730809/04 700 $aSadlier$b Darlene J$g(Darlene Joy)$0447186 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910461878303321 996 $aAmericans all$92092864 997 $aUNINA LEADER 04164nam 22005655 450 001 9910411929803321 005 20250609112057.0 010 $a9781523150618 010 $a1523150610 010 $a9781484260180 010 $a148426018X 024 7 $a10.1007/978-1-4842-6018-0 035 $a(CKB)4100000011343317 035 $a(DE-He213)978-1-4842-6018-0 035 $a(MiAaPQ)EBC6273795 035 $a(CaSebORM)9781484260180 035 $a(OCoLC)1202027410 035 $a(OCoLC)on1202027410 035 $a(MiAaPQ)EBC6270777 035 $a(EXLCZ)994100000011343317 100 $a20200716d2020 u| 0 101 0 $aeng 135 $aurnn|008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aData Mashup with Microsoft Excel Using Power Query and M $eFinding, Transforming, and Loading Data from External Sources /$fby Adam Aspin 205 $a1st ed. 2020. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2020. 215 $a1 online resource (XXIV, 388 p. 237 illus.) 300 $aIncludes index. 311 08$a9781484260173 311 08$a1484260171 327 $a1. 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. 330 $aMaster 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: 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. 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 14$aMicrosoft and .NET. 676 $a005.369 700 $aAspin$b Adam$4aut$4http://id.loc.gov/vocabulary/relators/aut$0895187 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910411929803321 996 $aData Mashup with Microsoft Excel Using Power Query and M$92179776 997 $aUNINA