Some more possible interview questions and answers about DAX in Power BI based on my experience and understanding.

I hope, now you got some idea about DAX related interview questions after going through my previous blogs on DAX interview questions.

If you have missed that, here are the links for your reference.

Interview Questions — DAX in Power BI — Part 1 | by Arpita Ghosh | Analytics…


Some more possible interview questions and answers about DAX in Power BI based on my experience and understanding.

In the previous blog, we have gone through some context and relationship-related questions and answers.

In this blog, we will go into aggregation related questions.

Please remember, only questions and answers can’t help you to clear any interview, you have to practice each and every syntax. …


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 decreased item cost by 1%.

These what-if analyses can be very helpful for any decision-making process.

Power BI has an AI-driven…


It’s a continuation of possible interview questions and answers about DAX in Power BI based on my experience and understanding.

In the previous blog, we learn 12 interview questions and answers on DAX.

Now in this blog, we will get into a deeper level of questions.

Please remember, only questions and answers can’t help you to clear any interview, you have to practice each and every syntax. …


Here are some possible interview questions and answers about DAX in Power BI based on my experience and understanding.

You have practice and study a lot before any interview, but still, you are thinking about what could be the questions on DAX.

For most of the Power BI jobs, if you observe, they mention specifically DAX as one of the skill sets. …


A complete guided case study in Power BI based on the Kaggle data set.

Introduction

In this blog, we are going to explore COVID vaccine data and try to find out the inference of how the immunization process is going on worldwide.

Source of Data

For the case studies, Kaggle is a good source of data. So this time I consider below dataset

  1. It has two files, but…


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

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…


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

Correlation Plot and Decision Tree in Power BI

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…


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

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…


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

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

Data Set 1

At first import, the US Super Store…

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