LEADER 06830nam 22007695 450 001 9910300462003321 005 20200701060909.0 010 $a9781430266921 010 $a1430266929 024 7 $a10.1007/978-1-4302-6692-1 035 $a(CKB)3710000000199314 035 $a(EBL)1781941 035 $a(SSID)ssj0001298093 035 $a(PQKBManifestationID)11761661 035 $a(PQKBTitleCode)TC0001298093 035 $a(PQKBWorkID)11248804 035 $a(PQKB)11468600 035 $a(MiAaPQ)EBC1781941 035 $a(DE-He213)978-1-4302-6692-1 035 $a(PPN)179921711 035 $a(CaSebORM)9781430266921 035 $a(OCoLC)885819501 035 $a(OCoLC)ocn885819501 035 $a(EXLCZ)993710000000199314 100 $a20140704d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aPower Query for Power BI and Excel /$fby Christopher Webb, Crossjoin Consulting Limited 205 $a1st ed. 2014. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2014. 215 $a1 online resource (261 p.) 225 0 $aExpert's voice in business intelligence Power Query for Power BI and Excel 300 $aIncludes index. 300 $a"The Expert's Voice in Business Intellegence"--Cover. 311 08$a9781322132013 311 08$a1322132011 311 08$a9781430266914 311 08$a1430266910 327 $aContents at a Glance; Chapter 1: Introducing Power Query; Power Query and Power BI; Power BI Components; Power Query; Power Pivot and the Excel 2013 Data Model; Power View; Power Map; SharePoint and Power BI for Office 365; Mobile BI; Workflow Summary; Power Query and Power BI Licensing; Installing Power Query; Power Query Concepts; Power Query Walkthrough; Creating a Simple Query; Editing an Existing Query; Why Use Power Query?; Faster Release Cycles; Connectivity to New Data Sources; Improved Connectivity to Existing Data Sources; Automate Data Loads 327 $aCreate Transformations and Calculations EasilyDo the Work in the Data Source, Not on the Desktop; Share Queries between Workbooks and Users; Summary; Chapter 2: Power Query Data Sources; Querying Relational Databases; Connecting to SQL Server; Navigating through a Database in the Query Editor; Connecting to Other Databases; Extracting Data from Files; Working with CSV Files; Working with Text Files; Working with XML Files; Working with JSON Files; Working with Excel Files; Working with Folders and Multiple Files; Working with Data from the Windows File System 327 $aCombining Data from Multiple Text FilesWorking with Data from the Current Excel Workbook; Working with Data from the Web; Scraping Data from Web Pages; Calling a Web Service; Finding Data Using Power Query Online Search; Searching for Public Data; Searching for Shared Queries and Other Organizational Data; Using the Search Tab; Using Other Queries as Data Sources; Referencing Entire Queries; Duplicating Queries; Using Individual Values from Queries; OData Data Sources; Working with Generic OData Web Services; Working with Data from Excel Workbooks Stored in SharePoint 327 $aWorking with Data from SharePoint ListsWorking with Data from the Windows Azure Marketplace; Working with Data from Windows Azure Blob Storage and Table Storage; Working with Data from HDFS and HDInsight; Working with Active Directory Data; Working with Data from Microsoft Exchange; Working with Data from Facebook; Working with Data from SAP BusinessObjects; Reusing Recent Data Sources; Managing Credentials; The Importance of Locale; Setting a Default Locale; CSV Files and Code Pages; Summary; Chapter 3: Transforming Data with Power Query; Queries and Steps; Working with Columns 327 $aNaming ColumnsMoving Columns; Removing Columns; Splitting Columns; Merging Columns; Setting the Data Type of a Column; Changing Data Types and Locales; Filtering Rows; Filtering Rows Using Auto-Filter; Filtering Rows Using Number, Text, and Date Filters; Number Filters; Text Filters; Date Filters; Filtering Rows by Range; Removing Duplicate Values; Filtering Out Rows with Errors; Sorting a Table; Changing Values in a Table; Replacing Values with Other Values; Text Transforms; Number Transforms; Date/Time/Duration Transforms; Filling Up and Down to Replace Missing Values; Aggregating Values 327 $aUnpivoting Columns to Rows 330 $aPower Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren?t going to be possible from just the GUI interface that is covered in most other books. You?ll have full command of the GUI, and you?ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language. 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aApplication software 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 606 $aComputer Applications$3https://scigraph.springernature.com/ontologies/product-market-codes/I23001 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 0$aApplication software. 615 14$aMicrosoft and .NET. 615 24$aComputer Applications. 676 $a005.369 700 $aWebb$b Christopher$4aut$4http://id.loc.gov/vocabulary/relators/aut$0959565 702 $aLimited$b Crossjoin Consulting$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300462003321 996 $aPower Query for Power BI and Excel$92174424 997 $aUNINA