Power BI Mock Interview No.3 | Power BI Interview | Power BI Live Interview |
Вставка
- Опубліковано 14 жов 2024
- #powerbi #powerbiinterviews
Power BI Mock Interview No.3. All Basic + Advanced level questions are asked in this. In these questions, we covered Power Query Editor, Power BI Desktop, Power BI Service, SQL Server, and Data Warehousing. Scenario-based questions are asked mostly in 2nd technical round, which also has been included in this video.
We are Microsoft Certified Power BI Data Analysts.
Fill out Google Form. bit.ly/3LFlWMc
Playlist of Data Analyst \ Power BI
• What is Power BI | Sal...
Open Free Stock Market Demat Account:
upstox.com/ope...
Our Social Media Support
Linkedin: / vinayak-kadam-402513189
Instagram: / indian_paradise_trainer
Telegram: t.me/+FjULK3XH...
Pinterest: / _created
Blog: www.theindianp...
Topics Covered:
Power BI Mock Interview, Power BI Developer Interview Questions, Power BI Service Questions, SQL interview Questions, Data Concepts.
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
Could you plz share total related experience of the candidate ?
3+
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
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
Hi sir.. have u posted the answer video for above mock??
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 please make answer videos for this...
Yes
Sir please upload one video actual work on agile
Yes
I will say questions were pretty easy. She not able to tell simple % dax query. How she is selected ?
answers ka video am not finding for this..
Ap apni company me interview lete ho ya fir ye demo hota hai sir
It is mock interview of my placed students
sir this video answers didn't upload
Respected sir, please upload interview answer video of 3,4,5
Except 3rd already done for others
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
Agr ap interview lete ho hmara bhi kra dijiye
Yes Jarur
Introduction also
Will make separate video for it...
Sir plz introduction and how to explain project
Sir please make answers video
7.5 lpa is very less men on pbi role
Depends on experience and previous package too
hw mny yoe ?
2+ years
The interviewer voice is too low... It's not clear and we are not able to listen his questions properly...
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