Open in app
Home
Notifications
Lists
Stories

Write
Arpita Ghosh
Arpita Ghosh

Home

About

Jul 18

How to Create Basic Charts in Power BI — Data Analysis in Power BI — Chapter 6

Let’s learn to create 6 different bar charts, and line and area charts in Power BI. — Power BI helps you to understand your data after loading it but using the data modelling capabilities of this tool, you can create matured and refined analysis. In the previous blog of the data analysis series, we understood how to build the enriched data model to perform sophisticated analysis. This…

Power Bi

2 min read

How to Create Basic Charts in Power BI — Data Analysis in Power BI — Chapter 6
How to Create Basic Charts in Power BI — Data Analysis in Power BI — Chapter 6

Published in Analytics Vidhya

·Feb 10

How to Work with FILTER, KEEPFILTERS, REMOVEFILTERS Functions in DAX — DAX in Power BI — Chapter 17

We are going to explore 3 filter functions (FILTER, KEEPFILTERS, REMOVEFILTERS) in DAX using practical examples. — For any Power BI-related project, DAX filters play an important role. Using these FILTER functions, we may be able to satisfy some client requirements related to data visualization. In this blog, you are going to explore how you can use 3 DAX filter functions FILTER, KEEPFILTERS, and REMOVEFILTERS.

Business Intelligence

3 min read

How to Work with FILTER, KEEPFILTERS, REMOVEFILTERS Functions in DAX — DAX in Power BI — Chapter 17
How to Work with FILTER, KEEPFILTERS, REMOVEFILTERS Functions in DAX — DAX in Power BI — Chapter 17

Published in Geek Culture

·Jan 13

How to Model the Data in Power BI — Data Analysis in Power BI — Chapter 5

Explore data modelling capabilities like relationship, hierarchy and calculation using DAX. — Power BI helps you to understand your data after loading it but using the data modelling capabilities of this tool, you can create matured and refined analysis. In previous blogs of this series (Data Analysis in Power BI), we get an idea of how to do data some ETL processes…

Data Analysis

2 min read

How to Model the Data in Power BI — Data Analysis in Power BI — Chapter 5
How to Model the Data in Power BI — Data Analysis in Power BI — Chapter 5

Jan 11

How to Deal with 5 ALL related Filter Functions in DAX — DAX in Power BI — Chapter 16

We are going to explore ALL, ALLSELECTED, ALLEXCEPT, ALLCROSSFILTERED, ALLNOBLANKROW filter functions in DAX using practical examples. — In any data analysis project, the filter functions of DAX are playing very important roles. Using these functions we can fulfil some customer requirements which are related to the data visualization perspective. In this blog, you are going to explore how you can use 5 ALL related DAX filter functions…

Dax

3 min read

How to Deal with 5 ALL related Filter Functions in DAX — DAX in Power BI — Chapter 15
How to Deal with 5 ALL related Filter Functions in DAX — DAX in Power BI — Chapter 15

Nov 15, 2021

How to Execute ETL Process in Power BI — Data Analysis in Power BI — Chapter 4

Data transformation helps to clean, pivot, transpose, merge and prepare model-ready data. — For any data analysis project, we are following CRISP-DM (Cross-industry standard process for data mining) framework. In this framework, data processing ( data transformation) 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…

Power Bi

2 min read

How to Execute ETL Process in Power BI — Data Analysis in Power BI — Chapter 4
How to Execute ETL Process in Power BI — Data Analysis in Power BI — Chapter 4

Oct 27, 2021

How to Use 7+Text Functions in DAX — DAX in Power BI — Chapter 15

We are going to explore CONCATENATE, CONCATENATEX, COMBINEVALUES, EXACT, FIND, SEARCH, LEFT, RIGHT and MID Text functions in DAX using practical examples. — In any data analysis project, the text functions of DAX are playing very important roles. Using these functions we can fulfil some customer requirements which are related to the data visualization perspective. In this blog, you are going to explore how you can use different DAX text functions like CONCATENATE…

Power Bi

3 min read

How to Use 7+Text Functions in DAX — DAX in Power BI — Chapter 15
How to Use 7+Text Functions in DAX — DAX in Power BI — Chapter 15

Sep 28, 2021

Interview Questions — DAX in Power BI — Part 4

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…

Power Bi

4 min read

Interview Questions — DAX in Power BI — Part 4
Interview Questions — DAX in Power BI — Part 4

Published in Geek Culture

·Sep 14, 2021

Interview Questions — DAX in Power BI — Part 3

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

Power Bi

4 min read

Interview Questions — DAX in Power BI — Part 3
Interview Questions — DAX in Power BI — Part 3

Published in Analytics Vidhya

·Sep 13, 2021

How to Create a What-if Parameter in Power BI — AI and Power BI — Chapter 7

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…

Power Bi

4 min read

How to Create a What-if Parameter in Power BI — AI and Power BI — Chapter 7
How to Create a What-if Parameter in Power BI — AI and Power BI — Chapter 7

Published in Analytics Vidhya

·Sep 7, 2021

Interview Questions — DAX in Power BI — Part 2

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. Otherwise, it will…

Power Bi

4 min read

Interview Questions — DAX in Power BI — Part 2
Interview Questions — DAX in Power BI — Part 2
Arpita Ghosh

Arpita Ghosh

Data Analyst , Blogger, https://arpitatechcorner.wordpress.com/, https://www.youtube.com/c/ArpitasTechCorner/channels

Following
  • Tim Denning

    Tim Denning

  • A. S. Deller

    A. S. Deller

  • Nikhil Adithyan

    Nikhil Adithyan

  • Medium Creators

    Medium Creators

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Knowable