Video 8 Modelo Datos Campos Calculados

Introduction

In this section, the speaker introduces the topic of using Data Analysis Expressions (DAX) in Power Pivot to calculate new fields or columns within a data model.

Connecting and Activating Data Model

• DAX used superficially to calculate new fields or columns within the data model.

• Accessing the data view and selecting the sales table for working on calculations.

Calculating Subtotal Column

This part focuses on calculating a subtotal column by multiplying the quantity of a product by its price.

Creating Subtotal Column

• Multiplying product quantity by product price to calculate subtotal.

• Leveraging existing relationships between tables to extract necessary information.

• Utilizing DAX function to access information from related tables like products.

Calculating Cost and Profit Columns

Here, the process of calculating cost and profit columns is explained using DAX expressions.

Determining Cost and Profit

• Calculating cost per product by accessing cost information from the products table.

• Creating a profit column to determine actual earnings from sales after deducting production costs.

Utilizing Calculated Columns in Power Pivot

Demonstrates how calculated columns can be utilized effectively in Power Pivot for data analysis tasks.

Applying Calculated Columns

• Renaming calculated columns for clarity and ease of understanding.

• Highlighting that various functions in DAX are similar to Excel formulas, simplifying calculations.

Differentiating Source Data and Calculated Columns

Discusses distinguishing between source data columns and those calculated through DAX expressions in Power Pivot.

Source Data vs. Calculated Columns

• Differentiating between source data (in green) directly from the dataset and calculated columns (in black) derived through DAX expressions.

New Section

In this section, the speaker discusses the importance of being cautious when using DAX and highlights the significance of observing new metrics and fields in a diagram view.

Observing New Metrics and Fields

• Being cautious when utilizing DAX is crucial.

• In a diagram view, one can observe new metrics and fields being added.

• Examples of these additions include subtotal product cost and profit.

• It is essential to pay attention to these new elements for accurate analysis.