Power Query for Power BI and Excel
Power 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 wor...
| Autores principales: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2014.
|
| Edición: | 1st ed. 2014. |
| Colección: | Expert's voice in business intelligence Power Query for Power BI and Excel
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629650906719 |
Tabla de Contenidos:
- Contents 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
- Create 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
- Combining 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
- Working 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
- Naming 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
- Unpivoting Columns to Rows
