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 feature that enables us to implement these what-if scenarios. This is known as What-If Parameters.

In this blog, we are going to explore this functionality with examples.

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…

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. Otherwise, it will be very difficult for you to explain any example using DAX.

Question 13: Tell me about the context concept in DAX. How many types of contexts are there?

In DAX, context is the layer of filtering and is applied to calculations to produce a result related to every value of a visual or pivot table including rows and columns totals.

By definition, context is an important concept…

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. That means you need to concentrate on this area more in comparison with others.

In this blog, I am going to start with capture some possible questions and answers on DAX in Power BI. I cannot say that these are obvious questions but from an interviewer perspective, I will look for some candidates who have this knowledge.

…

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 we will use one file named “country_vaccinations.csv” for this case study.
2. If you want to know more in detail about each field, you can have a look at the below picture. Though all the fields are self-explanatory.

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…

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…

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. …

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 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…