{"product_id":"microsoft-power-bi-query-editor-and-dax-programming-paperback-1","title":"Microsoft Power BI Query Editor and DAX Programming - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eJeff Hutchinson\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eIn this workbook\/guide, we will cover many behind-the-scenes capabilities of\u003cb\u003e Power BI\u003c\/b\u003e. We will use the\u003cb\u003e Power BI Desktop\u003c\/b\u003e tool to get data, the \u003cb\u003ePower Query Editor\u003c\/b\u003e to filter the data source, and use the \u003cb\u003eDAX programming language \u003c\/b\u003eto adjust the results.\u003cbr\u003e\u003cb\u003e******** Obtain Your PDF Copy and Recorded Videos ********\u003c\/b\u003e\u003cbr\u003eThis workbook includes \u003cb\u003ePDF Download\u003c\/b\u003e and \u003cb\u003eVideo Clip \u003c\/b\u003eof each practice exercise. Refer to the \u003cb\u003eWorkbook Introduction\u003c\/b\u003e for instructions on where to send an \u003cb\u003eAmazon\u003c\/b\u003e receipt. To see an example clip: www.elearnlogic.com \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cb\u003eGet Data\u003c\/b\u003e - The first step is to use the \u003cb\u003eGet Data\u003c\/b\u003e command in order to extract records from many different data sources such as \u003cb\u003eExcel, Access, SQL\u003c\/b\u003e, etc. Once you \u003cb\u003eGet\u003c\/b\u003e \u003cb\u003eData\u003c\/b\u003e, you will then choose a specifically desired table or sheet. Then, you can \u003cb\u003eLoad\u003c\/b\u003e all data or \u003cb\u003eTransform\u003c\/b\u003e data to clean up any undesired records. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eQuery Editor\u003c\/b\u003e - Databases are becoming very large and now contain more records than what is necessary to build \u003cb\u003eReports\u003c\/b\u003e. When you choose to \u003cb\u003eTransform\u003c\/b\u003e, it will open the \u003cb\u003eQuery Editor \u003c\/b\u003einterface which is used to filter records, correct many database glitches, clean up data, fix anomalies, and transform, or shape data source information. It can also be used to fix misspellings, clarify labels or columns containing wrong data types, automatically merge two data sources into a single table, adjust columns(fields), adjust rows (records), split columns, combine columns, replace information, transpose an entire table, and sort columns. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eDAX Programming\u003c\/b\u003e - In these chapters, you will learn the \u003cb\u003eDAX\u003c\/b\u003e (\u003cb\u003eDynamic Analysis Expressions\u003c\/b\u003e) program language for business intelligence data modeling and analysis techniques. It will explain how to change the behavior of records and \u003cb\u003eReports\u003c\/b\u003e based on the \u003cb\u003eDAX\u003c\/b\u003e function and allow you to create new columns that are not already contained in a database. \u003cb\u003eDAX\u003c\/b\u003e contains most of the \u003cb\u003eExcel\u003c\/b\u003e functions, but it also has a built-in record-filtering capability to pull data based on specific criteria. Also, if a user applies a filter in \u003cb\u003ePower BI\u003c\/b\u003e, it might skew the results. However, \u003cb\u003eDAX\u003c\/b\u003e will allow you to extract records and ignore any locally applied filter. The workbook explains \u003cb\u003eDAX\u003c\/b\u003e formula terms, basic structure, and common development techniques. Also included, is how to create \u003cb\u003eNew Columns\u003c\/b\u003e in a table, custom calculations known as \u003cb\u003eMeasures\u003c\/b\u003e, as well as how to create \u003cb\u003eNew Tables. \u003c\/b\u003e\u003cp\u003e\u003c\/p\u003eChapter Concepts Covered: \u003cbr\u003eChapter 1 - Get Data\u003cbr\u003eThis will extract a data source from a database such as \u003cb\u003eExcel, Access\u003c\/b\u003e, etc, The sections covered include Power BI Interface, Field List More Options, Report View \/ Home Ribbon Tab, Report View \/ Insert Ribbon Tab, Report View \/ Modeling Ribbon Tab, and Connection Techniques. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eChapter 2 - Query Editor\u003c\/b\u003e\u003cbr\u003eThis will allow us to review extracted data and filter or remove specific records prior to saving them to the \u003cb\u003ePower BI\u003c\/b\u003e file. The sections covered include Query Editor Interface, Query Editor \/ Home Ribbon Tab, Query Editor \/ Transform Ribbon Tab, Query Editor \/ Add Column Ribbon Tab, and Query Editor\/View Ribbon Tab. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eChapter 3 - DAX Formula Overview\u003c\/b\u003e\u003cbr\u003eThis chapter will provide an overview of the most important \u003cb\u003eDAX\u003c\/b\u003e formulas, functions, and capabilities. First, we will review common settings to better create formulas; then, we will review \u003cb\u003eNew Column\u003c\/b\u003e, \u003cb\u003eNew Measure\u003c\/b\u003e, \u003cb\u003eNew Table\u003c\/b\u003e, and\u003cb\u003e Quick Measure.\u003c\/b\u003e \u003cp\u003e\u003c\/p\u003e\u003cb\u003eChapter 4 - DAX Reference Guide\u003c\/b\u003e\u003cbr\u003eIn this chapter, we will document many common functions and provide practice exercises to demonstrate \u003cb\u003eDAX\u003c\/b\u003e capabilities. The sections covered include Math And Statistical Functions, Formatting Functions, Specialized DAX Functions, and Date And Time DAX Functions.\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 168\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.36 x 11 x 8.5 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e May 29, 2023\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47213256868089,"sku":"9798396474017","price":20.18,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/RkN8LAE6PW9798396474017_8bfe0471-70a1-4600-adf4-5374396ca9a1.webp?v=1768104423","url":"https:\/\/bookscloud.io\/products\/microsoft-power-bi-query-editor-and-dax-programming-paperback-1","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}