You will learn how to build statistical visuals like decision trees in Power BI.

Photo by Faye Cornish on Unsplash

The decision tree is an equally important part when we are using the Decision Tree machine learning algorithm for our data science project. Power BI has some small visualization capability and custom visual features are enabling to implement this.

In this blog, we are going to explore one statistical visualization, named decision tree.

Get Data

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

  • Let’s start with the Get Data option under the Home tab. As this is a CSV file, select the Text/CSV option from the drop-down list
  • Select the file named US Superstore data.csv
  • After selecting the…


You will learn how to build smart visualizations like correlation plots in Power BI.

Correlation Plot and Decision Tree in Power BI
Correlation Plot and Decision Tree in Power BI
Photo by Sam Moqadam on Unsplash

A correlation Plot is an important visualization for any data analysis or data science project. Power BI has some small visualization capability and custom visual features are enabling to implement this.

In this blog, we are going to explore the one smart and AI visualizations, named correlation plot.

Get Data

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

  • Let’s start with the Get Data option under the Home tab. As this is a CSV file, select the Text/CSV option from the drop-down list
  • Select the file named US Superstore data.csv
  • After selecting the file, data will be displayed…


We are going to explore 4 Normal Distribution statistical functions in DAX using practical examples.

Photo by Raphaël Biscaldi on Unsplash

Using DAX Statististical functions, we can very well determine the inferential statistics for different datasets in Power BI.

In this blog, you are going to explore how you can calculate Normal Distributions using DAX functions.

  1. NORM.DIST,
  2. NORM.INV,
  3. NORM.S.DIST,
  4. NORM.S.INV

What is Distribution

Whenever we are discussing inferential statistics, the first is coming to the picture is Distribution.

In simple terms, a distribution is a function that represents the possible values occurrences of a variable.

Examples: Normal distribution, Student’s T distribution, Poisson distribution, Uniform distribution, Binomial distribution

Normal Distribution

Normal Distribution is one of the most common distributions. …


We are going to explore 28 key statistical functions in DAX using practical examples.

Photo by CardMapr.nl on Unsplash

According to Microsoft documentation, there are different statistical and aggregation functions in DAX.

In this blog, you will explore functions related to the below items,

  1. average,
  2. maximum,
  3. minimum,
  4. count,
  5. median,
  6. standard deviation (sample, population),
  7. variance (sample, population)
  8. sample data extraction from population data.

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. As this is a CSV file, select the Text/CSV option from the drop-down list
  • Select the file named US Superstore data.csv
  • After selecting the file, data will be displayed…


What is special in Power BI with Drill Down/Up, Drill-Through and Expand/Collapse?

Photo by Eugen Str on Unsplash

Drilling down or up is a very interesting feature in any business intelligence tool. Power BI has the same feature but with some twist.

In this blog, we are going to explore the below points

  1. Expand and Collapse features in a visual
  2. Drilling Up and Down features in a visual
  3. Drill Through for a measure, for a column.

Get Data

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

  • Let’s start with the Get Data option under the Home tab. As this is a CSV file, select the Text/CSV option from the drop-down list
  • Select the file named US…


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.

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