Live Recorded Interview | Power BI | Experience(2-4 yrs) | BIG 4 firm | 2022🔥
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- 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 : / shashank_nikumbh26
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
#powerbiinterview
#learnwidgiggs
Now this is what we needed, very useful video indeed! 👍🏻
🙂
0:56 : Append queries.
2:08 : Query Folding.
3:16 : Column from example.
7:48 : Limitations of Direct query mode.
8:48 : Star and Snowflake schema?
9:20 : How to convert Star to snowflake schema?
11:48 : Role playing dimensions?
11:55 : Use relationship DAX function.
12:32 : DAX queries?
12:55 : Cumulative total using DAX?
17:42 : Customizing chart.
19:23 : Relative vs Lookup value function
19:46 : Count vs Count rows function
20:00 : Try to understand
21:36 : Row context vs Filter context
22:30 : Decomposition tree use case
24:00 : Ways to share report to end user
24:55 : Row level security
25:11 : User principal name vs User name DAX function
Later, SQL part.
Thanks broo 🙏
Thanks buddy
thanks bro
For 3rd question replace values Also works
This helps more than the actual video! Thanks
Completely real time based questions.....Most Appreciated
Thanks!
The primary key doesn't stop us from dropping the table. We indeed can drop the table even if we have a primary key. If the primary key of the table is referenced by a constraint belonging to another table, then the table CAN'T be dropped
Right answer
Fantastic share Shashank!!
Could we please be shared more of such live recorded interviews
fiscal year question...you can create a new column with month number and set the month for april as 1 upto march as 12 and the sort the columns by month number...pretty simple
Yes, this will work 👍
She seems more like a CS grad. Look at her going full confident at SQL section (vs becoming hesitant at power bi DAX questions)
SQL Server
1. Difference between Primary Key & Unique Key.
2. Can you Drop a table having primary key in it.
3. How to extract First Name in a new column from Full Name.
4. Difference between UNION and UNIONALL
5. When do we use HAVING clause.
6. Difference between Clustered and Non Clustered index.
7. Have you heard about common table expressions.
Can you write a SQL query to delete duplicate records of a table using common table expressions.
8. If you have to take our 2nd highest salary from a Salary column using a sub query. How will you do it.
Basics are not clear in power bi she has 3.5 yrs looks like a fresher
Hi Shashank, Thanks for the Great Video... Pls share the Answers for the interview questions...
commulative = calculate(sum(sales[revenue]),filter(all(order[date]),order[date]
Was this the real time interview or some practice interview. I have never faced a interviewer so friendly even the camera is off,ahe says "wow" for a que.She is taking time to search.
Hi sir, if you can provide these questions and answers plz keep that link in description....
thanks in advance...
Just Superbbb Yarr.... Very Nice
Thank you 🙂
There should be correct answers as a part of the video. At the end of the interview
select * from(
select *,denserank() over(order by salary desc) rnk from table_Name) A
where rnk = 2
2nd highest salary:-
Select max(salary) from employee
Where
for 20200114 datatype to date, first in query editor we have to change its type to text then to date. Direct conversion is not possible
Yess
Hi Shashank Sir,What is the answer for ..1. there is a column with records Rs 1000, 5000$ ..how will you pickout number from the column ? 2.And how to convert start schema to snowflake schema ?
1. Can use 'Column from examples' feature in power query
2. Can't explain here
@@learnwidgiggs : Thanks for the answer. Your videos are really very good. Thanks a lot. For second question if possible to post a video on that question will be helpful.
@@learnwidgiggscan I use split(Digit to non digit & non digit to digit)
Hi, can you please make more videos on DAX and python interview questions and if possible on ssas, thanks in advance
I have already uploaded few videos on DAX: th-cam.com/play/PLk-s1KYuT-PnTC_JnuLsZvCnhdUgd5puZ.html
Bro Try to do video for self introduction in Power bI
Noted 👍
We need more videos like this
Very Good ..Some really good questions are there with some good difficulty level
Glad you liked it.
Keep creating such content...you deserve millions of subscribers!!
Thank you for appreciating 🙂
Too be frank, I can't explain these things but can perform. If I was in her place, I might have said that "it's hard for me to explain and let me do it on the power bi"
Yeah that's also fine, if you have power bi desktop downloaded on yr desktop then you could share the screen and explain the answers.
Awesome sir really helpful 🤩
🙂
clustered index which is created on primary key column where as non clustered index which is performed on foreign keys i guess
very simple interiew ....awesome interviewer
Select max (salary) from employees where salary < (Select max(salary) from employees)
Is this query correct for 2nd highest salary??
Yess, will work
Thank you for sharing this information, kindly share more videos like this, can you please share a video for fresher with respect to power BI
Noted
You should have a course for interview preparation. It will help a lot of ppl
Thanks for the suggestion
Great video. Can you list out some more frequently asked questions in power bi and SQL interviews.
Please watch all the videos from the below playlist that I have already uploaded:
th-cam.com/play/PLk-s1KYuT-Pk2a1mbFe-nH7BNVdQjsWVU.html
Interview questions was awesome
thank you so very much for this video. But this itself feels like a technical round. Is there other technical round for this?
There was one more.
Thank you Shashank bhai❤❤
Sir, nice interview feel like real interview, But pls give output interview result on which areas they need to work on, it will help for fresher, sir
Noted!
for measures aggregation is must
Question: Rs 1000
$5000
4000$
Text.Select([Column1],{"0".."9"})
Solution: Go to Add Column---->Custom Column----> write the above formula and then currency values will automatically remove from the new column. Output will look like:
1000
5000
4000
After that change the datatype accordingly.
Thanks!
Can we use split ( Digit to Non digit) ..
Can you please do more video like this it is very much helpful to mee
Hopefully soon 😊
Thank you Shashank i have cracked R1 interview of PWC watching your video, can you tell me in R2 which type of questions I can expect
Nothing specific, just revise the videos on this channel..you are good to go.
Hi Shashank..For the ques asked at 20:20, whats the correct ans for your question? To my understanding, it can be because of 2 reasons -
i. We need to check if interactions is enabled/disabled under 'Edit Interactions'.
ii. If the above is On, then we have to check if the relationship is correct between the two tables loaded.
Let me know if the above is correct.
Yes it's correct 👍
for date related we have to split by characters then we need to merge them and need to change the date as data type this is my approach
Sir please make record interview video for freshers
I will, stay tuned.
The mic she is speaking from alibaba useless power audio she is having but overall ❤️
Looking forward more videos like this
Hi bro,
I have a question on dynamic row level security.
There are three columns in same dataset like
Region manager ,district manager ,store manager.
Qn. Based on this three columns how can we create dynamic rls.whenever region manger logins he needs to his district details and stores manager details...like for others ..how is this possible
You need to create 3 roles and use userprinciplename()
Can I have ur mail id pls, so that I can share sample dataset..ana explain clearly
Thanks helped alot 👍🙏🏼
Glad it helped
Sir pls upload fresher interview for power bi
I will.
Hi Sir,
Thanks for the good content.
Did you get permission from Shivangi Mishra(Interviewee) to publish this recording of her interview on social media along with her photograph and name visible in chat box?
I hope that's legal?
where is used to filter on existing column where as having is used to filter on aggregated data
After this interview
Interviewer: will get back to you. 😁
Q. Can we concatenate two diff column from diff tables ? if yes how, if no why?
Yeah using union dax u cN DO IT
i have a question ? the way the girl answered , is she was good at interview? as she skipped some questions
She answered 80% of the questions correctly..so it was good.
now a days openings for power BI was decreased, any reason behind it ?
I think it is due to year end, Dec and mid Jan most of the people were on vacation so recruitment was less
Does data analytics hold much promise?
Absolutely yess
Thanks sir
😊
I want power bi videos pls
Thanks a lot...!!!
😊
Thanks, Very Useful Video 🙌
Thank you!
What she answered all of them are correct..?
80% correct
Very good interview, questions were very good standard, I liked her approach to solve each problem, thanks :)
Welcome 🙂
Will I get pdf or file definition of question asking in interview
Like any difference between this type question
I want to become a business analyst as a fresher. I have completed my mba in business analytics. How should I approach?
I will make a video on this soon, stay tuned.
Is it for which company questions?
Great video 👍
Thank you 🙂
Thnx sir, I have one question...I have experienced in power bi and Sql.. Will I get the job on the basis of that?
Yes, you will get it if you have proper knowledge in both.
How to install power bi in desktop windows 7 pe ek latest video banao
What was the package offered bro
What is the correct ans for this question - How to convert Snowflake schema to Star Schema?
Can't explain this here in 2-3 lines
@@learnwidgiggs can you make a video?
@@sreemalapal will plan
simple answer is using merging we can do that
Thank you sir
😊
superb interview I watched so many mock but her knowledge is top notch
Please upload more interview videos
Will upload hopefully soon 🙂
really a great learning from this video..i have experience at senior level in another domain ..but i wanted to switch to this field ..can i switch if i have good preparation..does age matter ?
Yes you can switch but to show yr exp as relevant exp you have to have deep knowledge as you are experienced
Is it possible to get a job as a powerbi developer career gap with fresher?
The bitter truth is You have to toil hard to get the job... but yes possible
In real time really interview questions like this sir? I know about 98 percent of answer u asked in this interview.....so ?
Well done, you will succeed soon 👍
Can you please tell me how to optimize this dax code. Calculate( [sum of sales], product = 'pen')
@@kiranmai8773 sumx
@@xyz_1943 thank you for replying....but as sumx as an iteration function ....as it performs eow by row opearation i think it takes more time ....are you sure about the answer
Voice clarity not good and next time set person from you side make interview that one and good for job seekers.
How can i give mock interview to you for sql and power bi
How can we create measure for total sales and total cost?? Please reply
Using Sum() function
Power bi in trend??
Yess
Can you explain the answer for question,, suppose column contains Rs.1000,$ 2000,,requires new column for only nums.. How wiil u do it in Power query editor??
You can use "column from examples functionality" in power query
By using split column---→by non digit yo digit. We can do right?
@@keerthanabethi7460 It will not work in this case!
@@learnwidgiggs Extract will work i think brother
@@thedatapros5221 no it has limitations because extract functions works like this for suppose if u extract the first character u will get the remaining characters but here u got one problem if got any blank in any one or more rows , you won't be getting correct values where as column from example it identifies the numerical values and extract them , simple . Ok
After every question she is talking more time than fresher hope she finds good answers 😂😂😂
what will be the answer for this questions? RS50000 and 4000$ how to convert into number
Use 'Columns from Example' functionality in Power Query Editor in Power BI
@@learnwidgiggs i have try with this but using this only 1st value is changing rest of showing errors
Try to enter values in 3 to 4 records and then see
Otherwise you can see this video(watch from 20 mins) for more reference: th-cam.com/video/zv6RWIP9rpg/w-d-xo.html
I recommend to learn how to take interview from foreigners straightforward this is what i need, can u? If any additional work we will train u, r u ready for that. But Indian interviews r like preparing for IAS Exams 😂 in real time all copy paste work
Pls share power bi CV so i can update my CV
Please also share ryt ans of these questions
Noted.
was she qualified for next round ?
Sorry, can't disclose!
@@sharathkumar7041 yes posted here so that people can have the real interview experience and test how much good is their preparation to switch... result does not matter here except for the individual who gave the interview.
What as the package?
these sound cracking is so annoying... but thanks for sharing
Yeah, somehow it cracked, sorry for that.
😃
great vdeo but not all answers are correct
Is she got selected?
Is she selected??
YOU KNOW😅😅😅
jaan lay li larki ki
What is the experience of candidate
3.5 yrs
Ohk n did she get placed
Demo Interview
u know 😆
Give her a minute to think so that she can google 😂
Sir i am not from the technical background and have been working in Civil Core engineering branch since 6 years but has a decent knowledge of Power Bi but didn't have any industry experience into the same , can i enter into the industry of Power Bi, as i always had an interest in data and visualisations??
Your valuable suggestions will help me to draft my further preparation for entry into this data analytics field
Firstly from yr comment I am assuming you have 6 yrs of experience, and you want to enter in data and analytics domain with some knowledge in power bi...so my thought is yess you can definitely enter into this analytics domain..but if you are thinking to show this 6 exp range with exp of power bi and data analytics then you have to have deep knowledge of power bi plus other skills also and proper strategy how you will show it as relevant with inclusion of working on different projects duration this 6 exp.
Also watch the below video to add more skills with this experience
th-cam.com/video/d3uG0dfwb1k/w-d-xo.html
@@learnwidgiggs thank you sir, now will start with SQL course. Can you please tell me the appropriate learning option so that it would be easy for me to learn SQL....?
I actually didn't get the idea to where to start learning SQL from basics as i am a noncoder
@@namangarg7875 You can learn from TH-cam only like there are many video series present..you need to figure out from which one you are able to understand and then complete all the videos to learn it.
bro issko hire karlo cute hai ladki