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

Photo by Sebastian Herrmann on Unsplash

Question 24: What is the purpose of summarization in any Data Analysis or BI project?

For any industry, millions of transaction data have been captured. From this large table, we can prepare a summary table using aggregation logic and display a summarised visual.


You will learn how to Create a What-if Parameter in Power BI.

Photo by Rhys Kentish on Unsplash

Get Data

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


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

Photo by JESHOOTS.COM on Unsplash

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.


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

Photo by Ana Municio on Unsplash


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

Photo by Braňo on Unsplash

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


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

Photo by Faye Cornish on Unsplash

Get Data

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

  • 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
Photo by Sam Moqadam on Unsplash

Get Data

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

  • 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
  1. NORM.INV,
  2. NORM.S.DIST,
  3. NORM.S.INV

What is Distribution

Whenever we are discussing inferential statistics, the first is coming to the picture is 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
  1. maximum,
  2. minimum,
  3. count,
  4. median,
  5. standard deviation (sample, population),
  6. variance (sample, population)
  7. 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.

  • 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
  1. Drilling Up and Down features in a visual
  2. Drill Through for a measure, for a column.

Get Data

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

  • Select the file named US…

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