Live Data Analyst Mock Interview | Power BI | 2 Yr Experience | EP 2
Вставка
- Опубліковано 6 лют 2025
- Codebasics Data Analyst Bootcamp Link:
codebasics.io/...
-------------------------------------
Stuck? Book 1:1 call here - topmate.io/lea...
-------------------------------------
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
☀ Connect with me Here on Social Media ☀
LinkedIn : / shashank-singh-🇮🇳-ba4b...
Instagram : / learnwidgiggs
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
data analyst interview questions and answers
data analyst jobs for freshers
power bi scenario based interview questions
power bi interview questions learnwidgiggs
power query interview questions
how to get interview calls in power bi
data analyst jobs for freshers 2024
data analyst resume for freshers
data analyst resume for 2 years experience
data analyst resume for experienced
data analyst resume with no work experience
data analyst resume template
data analyst resume for 3 years experience
business analyst roadmap
business analyst career path
business analyst interview questions
business analyst job
Hi Shashank,
I'm an avid follower of your UA-cam channel. Yesterday, I interviewed for a Power BI Developer role at Capgemini. I’d like to share the interview questions from my experience to help other aspirants in their preparation.
1 year Experience
1. What are your roles and responsibilities in your project
2. What is power pivot
3. What is data modeling
4. Difference between Import mode & Direct Query Mode
5. What is incremental refresh and how to implement that
6. Incremental refresh can be scheduled or not in import mode
7. If we schedule refresh in import mode the whole dataset is refreshed or not
8. Difference between append and merge
9. Can we append two tables where the column numbers are different and some of the columns are not matching
10. Types of joins in power bi
11. How many active relationship we can have at a time and how many inactive relationship we can have
12. How to activate an inactive relationship
13. Difference between Reference Query and Duplicate Query
14. Which dax functions you have used in project
15. Difference between SUM and SUMX
16. Difference between SAMEPERIODLASTYEAR AND PARALLELPERIOD
17. Dax to calculate running total
this helped so much to prepare and looking forward for more scenario based questions mock interview as well.
Please create a video of analysis of this interview. Share the answers to these questions as well please.
Thank you
best difference for TotalYTD and DatesYTD is:
TotalYTD - it returns scalar(single value), we can directly use totalytd(), only restricted to one filter.
DatesYTD - it returns table of dates, need to use it in calculate(), can be use more than one filter.
if other than this any difference is there please add below.
Inner join: 8 rows
left outer: 8 rows
left anti: empty
Growth Rate =
VAR CY = [Total Sales]
VAR PY =
CALCULATE(
[Total Sales],
DATESBETWEEN(
calander[Date],
EDATE(MIN(calander[Date]),-12),
EOMONTH(MAX(Sales[Order Date]),-12)
)
)
VAR result = DIVIDE(PY,CY)
RETURN
result
For the join questions:
Inner join(All the records from Table A have a matching record in column B):
Apple Apple
Mango Mango
Mango Mango
null null
null null
Orange Orange
Mango Mango
Left Outer join(All from Table A and matching from B):
Apple Apple
Mango Mango
Mango Mango
null null
null null
Orange Orange
Mango Mango
Left-Anti:
Since all the values in A have a matching record in B, we have no unmatched records for Left-Anti join.
Sir can you please share the quotation and answers for every mock interview below every video that will be helpful to us thank you 🙏
LastWeekSales =
CALCUALTE(
[Total_Sales],
DATESINPERIDO(dates, MAX(dates), -7,DAY)
)
Instead of adding an extra column for converting to the date using the column from example option we can use this :
Newtable=Table.FromRecords(Table.TransformRows(
#"Added Custom",
each _&[Column1=Date.From(Text.From([Column1], "en-IN"))]
))
Advantages :
1. Since it skips the creation of an extra column and performs the transformation inline, this can potentially reduce query processing overhead slightly, especially for larger datasets.
2. It will help in reducing the table size also.
But it's easy to do an extra column and then delete the existing column
Can you tell me the solution for a dax problem, I have to calculate YoY, MoM, QoQ and make a slicer with these too, my question is when fetch YoY on the chart the date table should show only years, QoQ shows only quarter, MoM shows only month means x axis have dynamic date granularity
We don't understand which one is right and which one is wrong
GROWTH% =DIVIDE([TOTAL SALES],[PREVIOUSYEAR SALES],0)*100
YOY OR VARIANCE SALES = [TOTAL SALES]-[PREVIOUS YEAR SALES]
Select *
FROM table1
FULL OUTER JOIN table2 ON 1=1
No common fields required 🤔
Thank you for your valuable content Shashank!! I was very excited to share this with you, I cracked 2 offers, 1 of Business Analyst and other as a power bi intern with an NGO altogether. Initially in Jan I was not sure about whether I'll crack a single role also and that to of my interest, but I saw you power bi interview video to revise and avoid my self-doubt. This step turned into a useful step, and helped me in giving interviews in a far better way!!! I am so glad that you make such a content which helps to get opportunity as a fresher, while I did not wanted to reject the offer of power bi intern, but we can't accept 2 offers na !!😄 So I opt for business analyst role as first i got call from them only and while document process I got 2nd offer, but by then I accepted this first one. Once again Thanks for your valuable content !!!
@@ShrutiGore-j5c Many Congratulations Shruti 🎉
Hey can you refer me for that intern role?
Also share your job hunting process please
@@Einaressence Actually, there were 2-3 more candidates in the pipeline for this opportunity, since I denied they were going to continue with them as they told me to confirm from my end. If anything comes like any call, I'll dm you. Wish you the best that you'll get your dream job asap😇 ...
Hi Shashank, I have one use case for my project. I need semantic model refresh history in a report.
After some analysis, I found rest api 'Get Refresh History in Group'. But how can we create report using this? In short, how to integrate it with Power BI.
There is some Power BI Automate solution for this. But I am not able to get it. Can you create one video on this if possible, that will be helpful.
Hi shashank, as you know that in the current scenario, along with the verbal answering , the interviewer will ask us to share the screen of powerBI and execute the code or writing measures or upload the sample data and perform the time intelligence functions,can u please do implement this type of interview in your coming videos, please.
@@vishwanathn6485 Sure, noted
Pls provide answers also
Can Post a Mock Interview for more than 5 years of Power BI People
Post mock interview for data analyst as fresher
@@LoveStorycouple143 Coming soon
Left and Inner join in Power bi 8 record
Sir SQL SERVER AND MY SQL same or different. Which SQL is need for power bi devloper
SQL SERVER
Paarticooler😂
3:43 left join mein 8 record aayenge na ki nhi? Aur inner join mein 6 ?
All the joins will have 8 records.
In power query null is equal to null but in sql null is not equal to null
And anti joins will have no records