Joins in DAX

Joins in DAX

  June 22, 2023    asghars

---

DAX relationship has some limitations like:The matching criteria always use the = operator and does not allow the use of other operators such as <>, >=, <, and <= .Supports only one-to-many and one-to-one relationships.In order to overcome these limitations,...

Read More

Logical Functions in DAX

Logical Functions in DAX

  June 20, 2023    asghars

---

Logical functions evaluates to TRUE or FALSE.Following are the DAX Logical functions.IF(logical_test, result_true, result_false) Evaluates a condition and returns one value if it is TRUE, and another value if it is FALSE.The IF logical function can also be nested. IF.EAGER(logical_test,...

Read More

Relationships in Power BI

Relationships in Power BI

  June 20, 2023    asghars

---

When working with multiple tables, it is highly likely that you will need to perform analysis using data from all of them.Relationships are rules that define how two tables can be associated.Relationships connect one table column to another table’s column.Power BI Desktop...

Read More

Operators in DAX

Operators in DAX

  June 19, 2023    asghars

---

Operators are used to create expressions.There are four different types of operators in DAX.Arithmetic Operators perform basic arithmetic calculations.+ (Addition)– (Subtraction)* (Multiplication)/ (Division)^ (Exponentiation)Comparison Operators return true or false when used to compare two values.= (Equal to)== (Strict equal to)> (Greater than)< (Less than)>= (Greater than or equal...

Read More

Data Types & Variables in DAX

Data Types & Variables in DAX

  June 19, 2023    asghars

---

Data TypesDAX is strongly typed language. DAX data types can be categorized into three groups: NumericNumeric data types include DecimalFixed decimal/currencyInteger/whole numbers, Percentage (same is decimal data type but with formatting as percentage)  Date/Time...

Read More

Snowflake Schema

Snowflake Schema

  June 19, 2023    asghars

---

The Snowflake schema is an enhanced version of the Star Schema. In this schema, dimension tables are broken down into additional sub-dimensions. For example, the Product dimension table could be further normalized into related tables, such as a SubCategory table.Snowflake...

Read More

Star Schema

Star Schema

  June 13, 2023    asghars

---

Star Schema is a data modeling approach to classify tables as either lookup tables (dimensions or master data tables) or data tables (fact or transaction tables).Lookup Tables Lookup tables describe business entities e.g. Products, time etc.Lookup tables typically...

Read More

Context in DAX

Context in DAX

  June 13, 2023    asghars

---

Context describes the environment in which a DAX formula is evaluated. There are two types of context.Filter ContextFilter context is the context that is applied to a whole table or column (set of rows).The filter context is set of filters that are applied to the data...

Read More

What is Data Modeling in Power BI

What is Data Modeling in Power BI

  June 12, 2023    asghars

---

A Data model is a collection of data, tables, relationship between different tables, formatting rules, calculations/measures, and hierarchies.Power Pivot is used for data modeling in Power BI.The first step of data modeling is loading of data from Power Query, which are stored in tables in the form of columns. A single column usually primary key column is used to define relationships, in Power...

Read More

What is Data Analysis Expressions (DAX)

What is Data Analysis Expressions (DAX)

  June 12, 2023    asghars

---

DAX is a functional and, query language.Functional means DAX primarily use functions to generate results.Query means DAX can only filter or query data from table in Power BI, SSAS Tabular or PowerPivot.DAX is used in:MeasuresMeasure is a calculated value or expression that...

Read More

xVelocity

xVelocity

  June 11, 2023    asghars

---

With the introduction of Microsoft SQL Server 2012, a cutting-edge technology called xVelocity was unveiled, revolutionizing the way data is processed in-memory.In the realm of Data Warehousing, the xVelocity memory-optimized columnstore index offers an exceptional acceleration for frequently encountered data warehouse queries. For Business Intelligence purposes, xVelocity introduces an advanced...

Read More