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.
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
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
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.
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.
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 ?
@@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.
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.
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"
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
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?
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??
@@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
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 ?
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!
@@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.
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
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
Just Superbbb Yarr.... Very Nice
Thank you 🙂
Fantastic share Shashank!!
Could we please be shared more of such live recorded interviews
very simple interiew ....awesome interviewer
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 👍
commulative = calculate(sum(sales[revenue]),filter(all(order[date]),order[date]
Awesome sir really helpful 🤩
🙂
She seems more like a CS grad. Look at her going full confident at SQL section (vs becoming hesitant at power bi DAX questions)
We need more videos like this
Keep creating such content...you deserve millions of subscribers!!
Thank you for appreciating 🙂
To split the currency and the amount...we can go to power query ,then go to split columns. And choose "digits to non-digit"
Very Good ..Some really good questions are there with some good difficulty level
Glad you liked it.
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 sir, if you can provide these questions and answers plz keep that link in description....
thanks in advance...
Hi Shashank, Thanks for the Great Video... Pls share the Answers for the interview questions...
Bro Try to do video for self introduction in Power bI
Noted 👍
Looking forward more videos like this
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
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 👍
Interview questions was awesome
There should be correct answers as a part of the video. At the end of the interview
Thanks sir
😊
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
Thank you Shashank bhai❤❤
Thanks a lot...!!!
😊
Basics are not clear in power bi she has 3.5 yrs looks like a fresher
The way of expressing herself is also not good "yeahhh'" they way she saying is very annoying
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
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.
Thanks helped alot 👍🙏🏼
Glad it helped
select * from(
select *,denserank() over(order by salary desc) rnk from table_Name) A
where rnk = 2
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)
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.
She is goving mock interview bro
Great video 👍
Thank you 🙂
Can you please do more video like this it is very much helpful to mee
Hopefully soon 😊
clustered index which is created on primary key column where as non clustered index which is performed on foreign keys i guess
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!
You should have a course for interview preparation. It will help a lot of ppl
Thanks for the suggestion
Very good interview, questions were very good standard, I liked her approach to solve each problem, thanks :)
Welcome 🙂
Thanks, Very Useful Video 🙌
Thank you!
Thank you sir
😊
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.
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.
Select max (salary) from employees where salary < (Select max(salary) from employees)
Is this query correct for 2nd highest salary??
Yess, will work
for measures aggregation is must
superb interview I watched so many mock but her knowledge is top notch
2nd highest salary:-
Select max(salary) from employee
Where
salary is missing
select max(salary) as 2nd_highest
From employee
Where salary < (select max(salary) From employee)
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
I want power bi videos pls
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
Please upload more interview videos
Will upload hopefully soon 🙂
After this interview
Interviewer: will get back to you. 😁
where is used to filter on existing column where as having is used to filter on aggregated data
Sir pls upload fresher interview for power bi
I will.
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
Q. Can we concatenate two diff column from diff tables ? if yes how, if no why?
Yeah using union dax u cN DO IT
How to install power bi in desktop windows 7 pe ek latest video banao
Sir please make record interview video for freshers
I will, stay tuned.
Will I get pdf or file definition of question asking in interview
Like any difference between this type question
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?
What was the package offered bro
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.
What she answered all of them are correct..?
80% correct
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.
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.
How can i give mock interview to you for sql and power bi
Is it for which company questions?
The mic she is speaking from alibaba useless power audio she is having but overall ❤️
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.
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
After every question she is talking more time than fresher hope she finds good answers 😂😂😂
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
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 👍
@kiranmai8773 sumx
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
How can we create measure for total sales and total cost?? Please reply
Using Sum() function
Power bi in trend??
Yess
Is cumulative dax function is correct??
There is no cumulative function in Dax but ya what she wrote will work to calculate the cumulative sales
Can we use YTD sales for cumulative for year wise sales right?
What as the package?
Please also share ryt ans of these questions
Noted.
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
Pls share power bi CV so i can update my CV
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) ..
Is she got selected?
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
Voice clarity not good and next time set person from you side make interview that one and good for job seekers.
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.
Is she selected??
great vdeo but not all answers are correct
YOU KNOW😅😅😅
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
these sound cracking is so annoying... but thanks for sharing
Yeah, somehow it cracked, sorry for that.
What is the experience of candidate
3.5 yrs
Ohk n did she get placed
😃
She is not thinking she is cheating 🤣🤣
u know 😆
jaan lay li larki ki
Give her a minute to think so that she can google 😂
Demo Interview