We are going to look at 4 relationship functions in more detail with examples.

Photo by Alex Simpson on Unsplash

I found, there are 4 relationship functions in DAX as per Microsoft documentation.

As the name suggested, these functions are for managing and utilizing relationships between tables.

In this blog, you are going to explore 4 relationship functions with practical examples.

Get Data

For this case study, I consider the US Superstore dataset from Kaggle.

I have considered the code from one of my case study (How to Create Dimensional Queries and Decomposition Tree).

If you want to get that file, please check the GitHub (US_Superstore_Decomposition Tree project) location.

CROSSFILTER

The document mentions that the CROSSFILTER function is used to implement a specific…


We are going to look at 23 date and time functions in more detail with examples.

Photo by Debby Hudson on Unsplash

As per Microsoft documentation, there are 23 date and time functions are available in DAX. These functions are more or less similar to excel date-time functions. The only difference is that the DAX function can use DateTime data type and can take values from a column as an argument.

In this blog, we are going to explore them with some hands-on examples.

Get Data

At first import, the US Super Store data from Kaggle and save it to Power BI Desktop.

  • Let’s start with the Get Data option under the Home tab. …


This is based on my 17 years of industry experience and learning experience.

Photo by Campaign Creators on Unsplash

It happened to me in the earlier days of my career. Before appearing at an interview I prepared a lot but, during the interview time, I could not able to answer the questions in a proper format.

I am always trying to learn from my mistakes. So I started to make some proper plan for the interview and over 17 years I am following that. It is not only for the interview, for any type of presentation, I always prefer to make a proper step by step plan.

This blog will contain the top 7 guideline tips which I am…


It is obvious to know Business Intelligence before proceeding to data analysis.

Image by Gerd Altmann from Pixabay

Nowadays we are facing one word most of the time, which is Business Intelligence. Now the question is what is Business Intelligence, why do we need this etc. There are lot many questions are in our mind.

In this blog, I am focusing on some key points which are necessary to understand if you want to get into this Business Intelligence world.

What is Business Intelligence


Data profiling helps to identify data inconsistency.

Photo by Isaac Smith on Unsplash

For any data analysis project, we are following CRISP-DM (Cross-industry standard process for data mining) framework.

In this framework, data profiling is one of the key steps to start with the project.

In previous blogs of this series (Data Analysis in Power BI), we get an idea about the Power BI tool and how to import data in this tool using various data source connectivity.

In this blog, we are going to understand how to describe the data set after importing.

What is Data Profiling?

  1. For any Data Analysis project, data profiling is the key step to understand the overall structure of the data.


CALCULATETABLE is more applicable for context transition requirement.

Photo by Scott Graham on Unsplash

DAX has a different set of functions to manage tables. In this blog, we are going to explore CALCULATETABLE() function. This function helps create and manage tables.

Based on Microsoft documentation, the CALCULATETABLE function evaluates a table expression in a modified filter context.

CALCULATETABLE is the same as CALCULATE function, the difference is in their output. CALCULATETABLE returns a table whereas CALCULATE returns a single value like an integer or a string.

It’s time to understand deeply with some example.

Get Data

For this case study, I consider the US Superstore dataset from Kaggle.

I have considered the code from one of…


5 DAX functions solve the parent-child hierarchy problem in a data model.

Photo by Bonnie Kittle on Unsplash

Last two-three months, I am studying DAX deeply and going through different books. During this learning process, I found various interesting functions in DAX. Out of them, the parent-child function is so impressive to me.

In this blog, I thought to share with you my experimental learning process about parent-child DAX functions.

What is Parent-Child Hierarchies

As the name suggested, it is related to the parent-child relationship.

For example, in your dataset, if you have some employees and managers information you have to use these DAX Parent-Child functions to find out the relationships between employee and his/her manager.

There is no straightforward method, but…


The information function helps to implement percentage calculations over hierarchies.

Photo by Edvard Alexander Rølvaag on Unsplash

In different data models, you may have seen hierarchical data. In DAX, we don’t have any straightforward function to calculate over hierarchies.

However, there are different ways to handle this type of requirement. For example, you need to display the ratio percentage of each level against its parent level.

In this blog, I am providing all those DAX steps to help you solve this problem.

Get Data

At first import, the US Super Store data from Kaggle and save it to Power BI Desktop.

  • Let’s start with the Get Data option under the Home tab. …


In comparison with other business intelligence tool, Power BI can connect with 100 different data sources.

Photo by Tobias Fischer on Unsplash

In my previous blog, you get an idea about the Power BI tool and its installation process.

Now it’s time to get data from different data sources and import it Power BI.

Data Source Categories and Connectivity Mode

In comparison with other business intelligence tool, Power BI can connect with 100 different data sources.

There are 6 types of data source categories and 3 types of data connectivity modes.

In the below video, you can get an idea about all these data source categories and data connectivity modes.

Do you want to more about these data connectivity modes and their comparison study?

Check this below…


Get ready to learn data analysis in Power BI step by step with interactive videos.

Photo by benjamin lehman on Unsplash

Power BI tool can be used in various ways. I choose it as a complete end to end data analysis tool.

I thought to share with you my learning experience like how I explore Power BI in terms of a Data Analysis tool.

In this blog series, you will get to know my story. Let’s start.

Get some idea about the tool

Before exploring the tool, it is always better to know some initial introduction about Power BI. For example,

  1. What is Power BI?
  2. Why are we using Power BI?
  3. How does it work?
  4. What are the key components of it?
  5. A small introduction to Power…

Arpita Ghosh

Data Analyst , Blogger, https://arpitatechcorner.com/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store