How to Model the Data in Power BI — Data Analysis in Power BI — Chapter 5

Explore data modelling capabilities like relationship, hierarchy and calculation using DAX. Power BI helps you to understand your data after loading it but using the data modelling capabilities of this tool, you can create matured and refined analysis. In previous blogs of this series…

How to Deal with 5 ALL related Filter Functions in DAX — DAX in Power BI — Chapter 16

We are going to explore ALL, ALLSELECTED, ALLEXCEPT, ALLCROSSFILTERED, ALLNOBLANKROW filter functions in DAX using practical examples. In any data analysis project, the filter functions of DAX are playing very important roles. Using these functions we can fulfil some customer…

How to Execute ETL Process in Power BI — Data Analysis in Power BI — Chapter 4

Data transformation helps to clean, pivot, transpose, merge and prepare model-ready data. For any data analysis project, we are following CRISP-DM (Cross-industry standard process for data mining) framework. In this framework, data processing ( data transformation) is one of the…

How to Use 7+Text Functions in DAX — DAX in Power BI — Chapter 15

We are going to explore CONCATENATE, CONCATENATEX, COMBINEVALUES, EXACT, FIND, SEARCH, LEFT, RIGHT and MID Text functions in DAX using practical examples. In any data analysis project, the text functions of DAX are playing very important roles. Using these functions…

How to Create a What-if Parameter in Power BI — AI and Power BI — Chapter 7

You will learn how to Create a What-if Parameter in Power BI. In any data analysis project, whenever we analyze data, always want to find out, some what-if scenarios. For example, what if sales increased by 10% or what if we…