1. what are the differences between calculated column and Measures? 2. what is the differences between calendar and calender table? 3. what is the difference between stacked bar chart and 100% stacked bar chart 4. which is the best chart comparing with stacked bar chart or 100% stacked bar chart 5. what is the differences between ALL, All except and all selected functions? 6. what is whatIF parameter? what DAX function we will use for this? 7. what are the buttons you use in power BI? and which scenarios you will use? 8. in your report visuals are breaking or taking too much time to open? then what you will do? 9. what is visual tool tip in power BI? 10. what is blank query in power BI Below are the Answers Differences between Calculated Column and Measures: Calculated Column: It is a column created in a table based on a DAX formula. It is calculated at the row level and stored in the data model. It can be used for operations like concatenation, arithmetic calculations, etc. Measures: They are dynamic calculations based on the data in your model. They aggregate data across multiple rows and are not stored in the data model. They are used in visuals for reporting and analysis. Differences between Calendar and Calendar Table: Calendar: Refers to the actual calendar (e.g., the dates on which events occur). Calendar Table: This is a table you create in Power BI that contains a range of dates. It's often used to join to your data tables, enabling time-based analysis and reporting. Difference between Stacked Bar Chart and 100% Stacked Bar Chart: Stacked Bar Chart: It displays data in a series of bars, each divided into segments that represent different categories. The total height of the bar represents the total value. 100% Stacked Bar Chart: It also displays data in bars, but each bar represents 100% and is divided into segments that show the percentage contribution of each category to the total. Best Chart between Stacked Bar and 100% Stacked Bar: The choice depends on the specific data and the story you want to tell. Stacked bar charts show absolute values, while 100% stacked bar charts emphasize relative proportions. Differences between ALL, AllExcept, and AllSelected functions: ALL: Returns all the rows in a table, or all the values in a column, while ignoring any filters applied in the current context. ALLSELECTED: Returns all the rows in a table, or all the values in a column, but keeps any explicit filters applied by the user in the current context. ALLEXCEPT: Returns all the rows in a table except for those that you specify, while ignoring other filters applied in the current context. What-If Parameter and DAX function: A What-If Parameter is a tool in Power BI that allows users to input a value into a visual, which can then be used as a parameter for calculations. The DAX function used with What-If Parameters is typically SELECTEDVALUE. Buttons in Power BI and Scenarios: Power BI has buttons like slicers, filters, drill-through buttons, bookmarks, etc. These are used to interact with visuals and navigate between pages. They are used for creating interactive reports and dashboards. Fixing Slow or Broken Visuals: Options include optimizing data model, checking for complex calculations, reducing visuals on a page, using direct query mode, and considering performance improvements at the data source. Visual Tooltip in Power BI: It's a feature that allows you to display additional information when hovering over a visual. It can provide context, explanations, or detailed data points related to the visual. Blank Query in Power BI: A blank query is an empty query in Power Query Editor. It allows you to create custom tables or perform operations without initially connecting to an external data source. It's useful for creating manual tables or entering data directly.
Great Video. Keep continue making this kind of video. It's very help full for us. How can i connect with you. I fill 3 time of google form but not received any call or email from your side.
questions are very proper but please release the all answers video as in this not able to understand the proper form of answers. Please share the all answers video ASAP
1. what are the differences between calculated column and Measures?
2. what is the differences between calendar and calender table?
3. what is the difference between stacked bar chart and 100% stacked bar chart
4. which is the best chart comparing with stacked bar chart or 100% stacked bar chart
5. what is the differences between ALL, All except and all selected functions?
6. what is whatIF parameter? what DAX function we will use for this?
7. what are the buttons you use in power BI? and which scenarios you will use?
8. in your report visuals are breaking or taking too much time to open? then what you will do?
9. what is visual tool tip in power BI?
10. what is blank query in power BI
Below are the Answers
Differences between Calculated Column and Measures:
Calculated Column: It is a column created in a table based on a DAX formula. It is calculated at the row level and stored in the data model. It can be used for operations like concatenation, arithmetic calculations, etc.
Measures: They are dynamic calculations based on the data in your model. They aggregate data across multiple rows and are not stored in the data model. They are used in visuals for reporting and analysis.
Differences between Calendar and Calendar Table:
Calendar: Refers to the actual calendar (e.g., the dates on which events occur).
Calendar Table: This is a table you create in Power BI that contains a range of dates. It's often used to join to your data tables, enabling time-based analysis and reporting.
Difference between Stacked Bar Chart and 100% Stacked Bar Chart:
Stacked Bar Chart: It displays data in a series of bars, each divided into segments that represent different categories. The total height of the bar represents the total value.
100% Stacked Bar Chart: It also displays data in bars, but each bar represents 100% and is divided into segments that show the percentage contribution of each category to the total.
Best Chart between Stacked Bar and 100% Stacked Bar:
The choice depends on the specific data and the story you want to tell. Stacked bar charts show absolute values, while 100% stacked bar charts emphasize relative proportions.
Differences between ALL, AllExcept, and AllSelected functions:
ALL: Returns all the rows in a table, or all the values in a column, while ignoring any filters applied in the current context.
ALLSELECTED: Returns all the rows in a table, or all the values in a column, but keeps any explicit filters applied by the user in the current context.
ALLEXCEPT: Returns all the rows in a table except for those that you specify, while ignoring other filters applied in the current context.
What-If Parameter and DAX function:
A What-If Parameter is a tool in Power BI that allows users to input a value into a visual, which can then be used as a parameter for calculations. The DAX function used with What-If Parameters is typically SELECTEDVALUE.
Buttons in Power BI and Scenarios:
Power BI has buttons like slicers, filters, drill-through buttons, bookmarks, etc. These are used to interact with visuals and navigate between pages. They are used for creating interactive reports and dashboards.
Fixing Slow or Broken Visuals:
Options include optimizing data model, checking for complex calculations, reducing visuals on a page, using direct query mode, and considering performance improvements at the data source.
Visual Tooltip in Power BI:
It's a feature that allows you to display additional information when hovering over a visual. It can provide context, explanations, or detailed data points related to the visual.
Blank Query in Power BI:
A blank query is an empty query in Power Query Editor. It allows you to create custom tables or perform operations without initially connecting to an external data source. It's useful for creating manual tables or entering data directly.
Good
Nice information
Nice Video sir .I THINK YOUR NEXT VIDEO IS ANSWERS FOR THIS MOK QUESTIONS and I am waiting for your next video pls upload video as soon as possible.
Yes Sure....Share the Videos
Great Video. Keep continue making this kind of video. It's very help full for us. How can i connect with you. I fill 3 time of google form but not received any call or email from your side.
Thanks...DM me on Instagram
@@indianparadisetrainer Thank you for reply. I have sent the message over Instgram Sir.
She was fed with answers by some other person throughout the interview, pretty evident.
She is placed in Accenture......
All questions are good sir
But proper ans ka video dal do
Eagerly waiting
Yes Sure
Sir plz make video on SQL and DAX queries ever ask in interviews.
Already we had made Power BI and SQL Scenario Based Interview Questions 3 videos....more are going to come....you can find in Power bi playlist.
Ok thank u
questions are very proper but please release the all answers video as in this not able to understand the proper form of answers. Please share the all answers video ASAP
Hi sir.. have u posted the answer video for above mock??
Could you plz share total related experience of the candidate ?
3+
Sir please upload one video actual work on agile
Yes
Sir please make answer videos for this...
Yes
Respected sir, please upload interview answer video of 3,4,5
Except 3rd already done for others
Introduction also
Will make separate video for it...
Sir plz introduction and how to explain project
sir this video answers didn't upload
answers ka video am not finding for this..
I will say questions were pretty easy. She not able to tell simple % dax query. How she is selected ?
Ap apni company me interview lete ho ya fir ye demo hota hai sir
It is mock interview of my placed students
Sir please make answers video
Agr ap interview lete ho hmara bhi kra dijiye
Yes Jarur
plz help to build resume not getting calls
Already Resume Video is there in our playlist plz check and also we will make one more video about it.
@@indianparadisetrainersir plz give link of resume video
7.5 lpa is very less men on pbi role
Depends on experience and previous package too
The interviewer voice is too low... It's not clear and we are not able to listen his questions properly...
hw mny yoe ?
2+ years
Please correct answers for this questions
Yes
No confidence or understanding in the answers, even when almost given them.
She is fresher or experienced ?
Experienced