Home › Computers › Microsoft Power BI Query Editor and DAX Programming

Microsoft Power BI Query Editor and DAX Programming

by Jeff Hutchinson Publisher: INDEPENDENTLY PUBLISHED

A workbook guide to Power BI data preparation and DAX

Regular price $17.94 USD
Regular price $23.92 USD Sale price $17.94 USD
Save 25%

Paperback New

In stock · Dispatches in 1–2 business days
Delivery to your door
In stock·Dispatches in 1–2 business days
Standard shipping* from $4.35
Standard shipping transit* 5–8 business days after dispatch

Faster options are available.

Rates and delivery estimates depend on your destination and item quantity. Estimates are informational only; the final shipping method and rate are selected at checkout.

Secure checkout
American Express Apple Pay DiscoverGoogle Pay Mastercard PayPalVisa
30-day eligible returns Returns & refunds policy

AlbakiReads Editorial

A workbook guide to Power BI data preparation and DAX

Jeff Hutchinson’s workbook moves through a practical Power BI workflow: bringing in data, shaping it in Query Editor, then using DAX to create calculations and work with reports. Its four chapters cover Desktop interface and connection topics, data-cleaning and transformation tools, an overview of DAX formulas, and a reference section with practice exercises. The listed Query Editor tasks range from filtering and correcting records to combining or reshaping columns and tables. DAX coverage includes formula structure, new columns, measures, tables, and functions for areas such as math, formatting, and dates. The source also describes PDF downloads and video clips accompanying practice exercises, with access instructions provided in the workbook introduction.

Good fit for readers who enjoy

  • Power BI users seeking a structured introduction to importing and preparing data.
  • Learners who want guided practice with DAX formulas, measures, and tables.
  • Readers who value exercise materials accompanied by PDFs and video clips.

Themes

Power BI data import and connectionData cleaning and transformationDAX formulas and data modelingPractice-based technical learning

Based on publisher information and book metadata.

Book overview

In this workbook/guide, we will cover many behind-the-scenes capabilities of Power BI. We will use the Power BI Desktop tool to get data, the Power Query Editor to filter the data source, and use the DAX programming language to adjust the results.
******** Obtain Your PDF Copy and Recorded Videos ********
This workbook includes PDF Download and Video Clip of each practice exercise. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. To see an example clip: www.elearnlogic.com

Get Data - The first step is to use the Get Data command in order to extract records from many different data sources such as Excel, Access, SQL, etc. Once you GetData, you will then choose a specifically desired table or sheet. Then, you can Load all data or Transform data to clean up any undesired records.

Query Editor - Databases are becoming very large and now contain more records than what is necessary to build Reports. When you choose to Transform, it will open the Query Editor interface 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.

DAX Programming - In these chapters, you will learn the DAX (Dynamic Analysis Expressions) program language for business intelligence data modeling and analysis techniques. It will explain how to change the behavior of records and Reports based on the DAX function and allow you to create new columns that are not already contained in a database. DAX contains most of the Excel 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 Power BI, it might skew the results. However, DAX will allow you to extract records and ignore any locally applied filter. The workbook explains DAX formula terms, basic structure, and common development techniques. Also included, is how to create New Columns in a table, custom calculations known as Measures, as well as how to create New Tables.

Chapter Concepts Covered:
Chapter 1 - Get Data

This will extract a data source from a database such as Excel, Access, 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.

Chapter 2 - Query Editor
This will allow us to review extracted data and filter or remove specific records prior to saving them to the Power BI 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.

Chapter 3 - DAX Formula Overview
This chapter will provide an overview of the most important DAX formulas, functions, and capabilities. First, we will review common settings to better create formulas; then, we will review New Column, New Measure, New Table, and Quick Measure.

Chapter 4 - DAX Reference Guide
In this chapter, we will document many common functions and provide practice exercises to demonstrate DAX capabilities. The sections covered include Math And Statistical Functions, Formatting Functions, Specialized DAX Functions, and Date And Time DAX Functions.
Shipping & returnsShipping options, delivery timing, and our return policy.

In-stock items normally dispatch within 1–2 business days. The ZIP-code estimator on this page is informational only; the final shipping method, price, and availability are confirmed at checkout for your full order.

For the initial delivery estimate we use these transit windows after dispatch: Standard 5–8 business days, Expedited 2–4 business days, and Priority 1–2 business days. Holiday delays are not included.

Eligible items can be returned within 30 days in accordance with our return policy.

Customer reviews

M
AlbakiReads
Malaika Taylor

I highly recommend to for anyone looking for inner clarity

T
AlbakiReads
Thomas DiMassa

Great service and fast service

Great shopping experience! The book arrived quickly, was well packaged, and matched the description perfectly. I would definitely shop with you again

O
AlbakiReads
Olivia

Smooth.