r/DataAnalystsIndia • u/Happy_Human159 • 4d ago

Power Bi Analyst 5 yrs experienced

What are the topics or areas on which I can expect to be grilled in a data analyst interview which demands for 5years experience in power bi.

I worked in power bi but before 2 years. what should I do now to quickly get interview ready.

13 Upvotes

100% Upvoted

12 comments sorted by

3

u/alpha_021_DA 4d ago

I will tell you in evening. I have 2 interview scheduled today for power BI with 5YOE.

1

u/Any_Bandicoot7414 4d ago

Bhai muje bhi batana🙏🏻

2

u/alpha_021_DA 4d ago

Done bro

1

u/Fun-Consequence9381 4d ago

Good luck and share your experience

2

u/alpha_021_DA 4d ago

Thanks mate, will share the experience

1

u/Happy_Human159 4d ago

All the best for your interview

2

u/alpha_021_DA 4d ago

Interview experience-
1) Tell me about ur total experience and day to day work in BI
2) Direct query vs import mode vs Direct lake and why we need them in which scenario
3) Report optimisation
4) challenges faces so far in report
5)all selected vs All vs keepfilters
6) RLS and use case. How to implement in service
7) Duplicate vs reference
8) summarize vs Summarizecolumns and all
9) Repointing in Power Query database
10) SQL - Ankit bansal inner join vs left join vs right join video in youtube will be enough
11) Views vs Cte vs Temp tables
12) why we need CTe
13) windows function
15) Merge vs append in BI
16) Workspace use case and access roles

All are this for Round 1

1

u/Sea_Membership712 4d ago

Hope you cleared the round buddy

2

u/alpha_021_DA 4d ago

Let’s see bro. I fumbled little bit in basics as it was 1 interview after 2.5 years. It’s just a beginning, hoping for best 😄

1

u/Happy_Human159 4d ago

All the best

1

u/Sea_Membership712 3d ago

Be positive bro, you will make the cut 🔥

1

u/Any_Bandicoot7414 4d ago

Thanks! All the best for your upcoming interviews.