Live Recorded Interview | Power BI | Experience(2-4 yrs) | BIG 4 firm | 2022🔥

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ธ.ค. 2024

ความคิดเห็น • 195

  • @AkankshaSingh-mg1vr
    @AkankshaSingh-mg1vr 2 ปีที่แล้ว +32

    Now this is what we needed, very useful video indeed! 👍🏻

  • @mohitupadhayay1439
    @mohitupadhayay1439 2 ปีที่แล้ว +109

    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.

  • @ravireddy270
    @ravireddy270 2 ปีที่แล้ว +10

    Completely real time based questions.....Most Appreciated

  • @daXcel7448
    @daXcel7448 ปีที่แล้ว +8

    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

  • @indianparadisetrainer
    @indianparadisetrainer 2 ปีที่แล้ว +3

    Just Superbbb Yarr.... Very Nice

  • @varunas9784
    @varunas9784 5 หลายเดือนก่อน +1

    Fantastic share Shashank!!
    Could we please be shared more of such live recorded interviews

  • @mangaldeep9544
    @mangaldeep9544 2 ปีที่แล้ว +1

    very simple interiew ....awesome interviewer

  • @madhusudhanreddyt2838
    @madhusudhanreddyt2838 2 ปีที่แล้ว +8

    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

  • @SandeepSingh-cy4hw
    @SandeepSingh-cy4hw 3 หลายเดือนก่อน +1

    commulative = calculate(sum(sales[revenue]),filter(all(order[date]),order[date]

  • @nishthatank5954
    @nishthatank5954 2 ปีที่แล้ว +3

    Awesome sir really helpful 🤩

  • @Ali-ds5iy
    @Ali-ds5iy 2 ปีที่แล้ว +4

    She seems more like a CS grad. Look at her going full confident at SQL section (vs becoming hesitant at power bi DAX questions)

  • @heroraji
    @heroraji 2 ปีที่แล้ว +4

    We need more videos like this

  • @incredibleradhika4164
    @incredibleradhika4164 2 ปีที่แล้ว +4

    Keep creating such content...you deserve millions of subscribers!!

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +2

      Thank you for appreciating 🙂

  • @sahasransupanda8169
    @sahasransupanda8169 18 วันที่ผ่านมา

    To split the currency and the amount...we can go to power query ,then go to split columns. And choose "digits to non-digit"

  • @manishsathe8371
    @manishsathe8371 11 หลายเดือนก่อน

    Very Good ..Some really good questions are there with some good difficulty level

    • @learnwidgiggs
      @learnwidgiggs  11 หลายเดือนก่อน

      Glad you liked it.

  • @Prachi.motarwar
    @Prachi.motarwar ปีที่แล้ว +5

    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

  • @perfectionist6624
    @perfectionist6624 2 ปีที่แล้ว +8

    Hi sir, if you can provide these questions and answers plz keep that link in description....
    thanks in advance...

  • @letsexplore0075
    @letsexplore0075 ปีที่แล้ว +3

    Hi Shashank, Thanks for the Great Video... Pls share the Answers for the interview questions...

  • @powerbivisual
    @powerbivisual 2 ปีที่แล้ว +6

    Bro Try to do video for self introduction in Power bI

  • @sakshinaik05
    @sakshinaik05 2 ปีที่แล้ว +1

    Looking forward more videos like this

  • @HarshithaKumar-i5f
    @HarshithaKumar-i5f ปีที่แล้ว

    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

  • @sreemalapal
    @sreemalapal 2 ปีที่แล้ว +5

    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.

  • @mansikhandwe9284
    @mansikhandwe9284 3 หลายเดือนก่อน

    Interview questions was awesome

  • @Yog3shPatel
    @Yog3shPatel 9 หลายเดือนก่อน +2

    There should be correct answers as a part of the video. At the end of the interview

  • @Peaceful_World130
    @Peaceful_World130 2 ปีที่แล้ว +2

    Thanks sir

  • @lavanyapadma3024
    @lavanyapadma3024 2 ปีที่แล้ว +4

    Hi, can you please make more videos on DAX and python interview questions and if possible on ssas, thanks in advance

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      I have already uploaded few videos on DAX: th-cam.com/play/PLk-s1KYuT-PnTC_JnuLsZvCnhdUgd5puZ.html

  • @Thetradersclub_
    @Thetradersclub_ 9 หลายเดือนก่อน

    Thank you Shashank bhai❤❤

  • @vinayl910
    @vinayl910 2 ปีที่แล้ว +1

    Thanks a lot...!!!

  • @lalitkaushik1812
    @lalitkaushik1812 ปีที่แล้ว +15

    Basics are not clear in power bi she has 3.5 yrs looks like a fresher

    • @realsanish
      @realsanish 14 วันที่ผ่านมา +1

      The way of expressing herself is also not good "yeahhh'" they way she saying is very annoying

  • @shibayanbhowal2871
    @shibayanbhowal2871 2 ปีที่แล้ว +4

    Great video. Can you list out some more frequently asked questions in power bi and SQL interviews.

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      Please watch all the videos from the below playlist that I have already uploaded:
      th-cam.com/play/PLk-s1KYuT-Pk2a1mbFe-nH7BNVdQjsWVU.html

  • @sagarsharma12_
    @sagarsharma12_ ปีที่แล้ว +6

    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.

  • @Aeditya
    @Aeditya 2 ปีที่แล้ว

    Thanks helped alot 👍🙏🏼

  • @RajeshManepalli-o8b
    @RajeshManepalli-o8b 4 หลายเดือนก่อน

    select * from(
    select *,denserank() over(order by salary desc) rnk from table_Name) A
    where rnk = 2

  • @priyaagarwal4559
    @priyaagarwal4559 2 ปีที่แล้ว +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 ?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      1. Can use 'Column from examples' feature in power query
      2. Can't explain here

    • @priyaagarwal4559
      @priyaagarwal4559 2 ปีที่แล้ว +1

      @@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.

    • @Viky-ee4id
      @Viky-ee4id 4 หลายเดือนก่อน

      ​@@learnwidgiggscan I use split(Digit to non digit & non digit to digit)

  • @SonuSonu-uh2er
    @SonuSonu-uh2er 2 ปีที่แล้ว +5

    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.

    • @realsanish
      @realsanish 14 วันที่ผ่านมา

      She is goving mock interview bro

  • @geetasingh2701
    @geetasingh2701 2 ปีที่แล้ว

    Great video 👍

  • @sharathkumar1103
    @sharathkumar1103 2 ปีที่แล้ว +1

    Can you please do more video like this it is very much helpful to mee

  • @RajeshManepalli-o8b
    @RajeshManepalli-o8b 4 หลายเดือนก่อน

    clustered index which is created on primary key column where as non clustered index which is performed on foreign keys i guess

  • @vinayakkulkarni5407
    @vinayakkulkarni5407 2 ปีที่แล้ว +1

    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

  • @A-qd5vc
    @A-qd5vc ปีที่แล้ว +1

    You should have a course for interview preparation. It will help a lot of ppl

  • @koustavbag3907
    @koustavbag3907 2 ปีที่แล้ว

    Very good interview, questions were very good standard, I liked her approach to solve each problem, thanks :)

  • @Jit02
    @Jit02 2 ปีที่แล้ว

    Thanks, Very Useful Video 🙌

  • @piyushramkar9404
    @piyushramkar9404 2 ปีที่แล้ว

    Thank you sir

  • @starfish9928
    @starfish9928 ปีที่แล้ว

    thank you so very much for this video. But this itself feels like a technical round. Is there other technical round for this?

  • @pasupathi9954
    @pasupathi9954 2 ปีที่แล้ว +3

    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"

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      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.

  • @sanket565
    @sanket565 2 ปีที่แล้ว +2

    Select max (salary) from employees where salary < (Select max(salary) from employees)
    Is this query correct for 2nd highest salary??

  • @saurabhMaratha
    @saurabhMaratha 11 หลายเดือนก่อน +1

    for measures aggregation is must

  • @Saumyagrow
    @Saumyagrow 9 หลายเดือนก่อน

    superb interview I watched so many mock but her knowledge is top notch

  • @hiteshKumar-bd7pk
    @hiteshKumar-bd7pk 3 หลายเดือนก่อน

    2nd highest salary:-
    Select max(salary) from employee
    Where

    • @zenjiyt8381
      @zenjiyt8381 2 หลายเดือนก่อน

      salary is missing
      select max(salary) as 2nd_highest
      From employee
      Where salary < (select max(salary) From employee)

  • @RajeshManepalli-o8b
    @RajeshManepalli-o8b 4 หลายเดือนก่อน

    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

  • @welcomevlogs7838
    @welcomevlogs7838 2 ปีที่แล้ว +2

    I want power bi videos pls

  • @ganeshreddymotakatla6244
    @ganeshreddymotakatla6244 2 ปีที่แล้ว +1

    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

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      You need to create 3 roles and use userprinciplename()

    • @ganeshreddymotakatla6244
      @ganeshreddymotakatla6244 2 ปีที่แล้ว

      Can I have ur mail id pls, so that I can share sample dataset..ana explain clearly

  • @WORLDOFGANGSTER
    @WORLDOFGANGSTER 2 ปีที่แล้ว +1

    Please upload more interview videos

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      Will upload hopefully soon 🙂

  • @insidehead
    @insidehead 2 ปีที่แล้ว

    After this interview
    Interviewer: will get back to you. 😁

  • @RajeshManepalli-o8b
    @RajeshManepalli-o8b 4 หลายเดือนก่อน

    where is used to filter on existing column where as having is used to filter on aggregated data

  • @starsrocks06
    @starsrocks06 ปีที่แล้ว +2

    Sir pls upload fresher interview for power bi

  • @arjunk8259
    @arjunk8259 2 ปีที่แล้ว +1

    now a days openings for power BI was decreased, any reason behind it ?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      I think it is due to year end, Dec and mid Jan most of the people were on vacation so recruitment was less

  • @baijayantibehera2722
    @baijayantibehera2722 2 ปีที่แล้ว +1

    Q. Can we concatenate two diff column from diff tables ? if yes how, if no why?

    • @raviteja163
      @raviteja163 ปีที่แล้ว

      Yeah using union dax u cN DO IT

  • @ravihanwate.
    @ravihanwate. ปีที่แล้ว

    How to install power bi in desktop windows 7 pe ek latest video banao

  • @thesakshiskitchen6460
    @thesakshiskitchen6460 2 ปีที่แล้ว +1

    Sir please make record interview video for freshers

  • @jaikishanthakur3459
    @jaikishanthakur3459 ปีที่แล้ว

    Will I get pdf or file definition of question asking in interview
    Like any difference between this type question

  • @tejtabla8246
    @tejtabla8246 11 หลายเดือนก่อน

    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?

  • @varrenagavenkatasuresh1236
    @varrenagavenkatasuresh1236 2 ปีที่แล้ว +1

    What was the package offered bro

  • @azammd1934
    @azammd1934 2 ปีที่แล้ว +1

    i have a question ? the way the girl answered , is she was good at interview? as she skipped some questions

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      She answered 80% of the questions correctly..so it was good.

  • @seemagadge3425
    @seemagadge3425 2 ปีที่แล้ว +1

    What she answered all of them are correct..?

  • @nobody99186
    @nobody99186 2 ปีที่แล้ว

    I want to become a business analyst as a fresher. I have completed my mba in business analytics. How should I approach?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      I will make a video on this soon, stay tuned.

  • @NITIANShubham
    @NITIANShubham ปีที่แล้ว +2

    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

    • @learnwidgiggs
      @learnwidgiggs  ปีที่แล้ว +1

      Nothing specific, just revise the videos on this channel..you are good to go.

  • @longliveindia1637
    @longliveindia1637 2 ปีที่แล้ว

    How can i give mock interview to you for sql and power bi

  • @sandeepreddy7687
    @sandeepreddy7687 2 ปีที่แล้ว

    Is it for which company questions?

  • @Bangloreblogs
    @Bangloreblogs 2 ปีที่แล้ว +1

    The mic she is speaking from alibaba useless power audio she is having but overall ❤️

  • @mdsameersiddiqui5333
    @mdsameersiddiqui5333 2 ปีที่แล้ว

    Thnx sir, I have one question...I have experienced in power bi and Sql.. Will I get the job on the basis of that?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      Yes, you will get it if you have proper knowledge in both.

  • @pulukuriaparna7020
    @pulukuriaparna7020 2 ปีที่แล้ว +1

    Is it possible to get a job as a powerbi developer career gap with fresher?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      The bitter truth is You have to toil hard to get the job... but yes possible

  • @SyedAfroz3
    @SyedAfroz3 ปีที่แล้ว

    After every question she is talking more time than fresher hope she finds good answers 😂😂😂

  • @keerthanabethi7460
    @keerthanabethi7460 2 ปีที่แล้ว

    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??

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +2

      You can use "column from examples functionality" in power query

    • @keerthanabethi7460
      @keerthanabethi7460 2 ปีที่แล้ว

      By using split column---→by non digit yo digit. We can do right?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      @@keerthanabethi7460 It will not work in this case!

    • @thedatapros5221
      @thedatapros5221 2 ปีที่แล้ว +1

      @@learnwidgiggs Extract will work i think brother

    • @thandruphani
      @thandruphani 2 ปีที่แล้ว +1

      @@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

  • @xyz_1943
    @xyz_1943 ปีที่แล้ว +1

    In real time really interview questions like this sir? I know about 98 percent of answer u asked in this interview.....so ?

    • @learnwidgiggs
      @learnwidgiggs  ปีที่แล้ว

      Well done, you will succeed soon 👍

    • @xyz_1943
      @xyz_1943 ปีที่แล้ว

      @kiranmai8773 sumx

  • @sreemalapal
    @sreemalapal 2 ปีที่แล้ว +1

    What is the correct ans for this question - How to convert Snowflake schema to Star Schema?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      Can't explain this here in 2-3 lines

    • @sreemalapal
      @sreemalapal 2 ปีที่แล้ว

      @@learnwidgiggs can you make a video?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      @@sreemalapal will plan

    • @MOHAN-PYARA
      @MOHAN-PYARA ปีที่แล้ว

      simple answer is using merging we can do that

  • @saranvenkat6102
    @saranvenkat6102 2 ปีที่แล้ว

    How can we create measure for total sales and total cost?? Please reply

  • @DurgaPrasad-fo9iu
    @DurgaPrasad-fo9iu 2 ปีที่แล้ว +1

    Power bi in trend??

  • @saranvenkat6102
    @saranvenkat6102 2 ปีที่แล้ว

    Is cumulative dax function is correct??

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +2

      There is no cumulative function in Dax but ya what she wrote will work to calculate the cumulative sales

    • @abrahamvincent6272
      @abrahamvincent6272 ปีที่แล้ว

      Can we use YTD sales for cumulative for year wise sales right?

  • @varrenagavenkatasuresh1236
    @varrenagavenkatasuresh1236 2 ปีที่แล้ว

    What as the package?

  • @amishadagar4700
    @amishadagar4700 ปีที่แล้ว +1

    Please also share ryt ans of these questions

  • @gautam-b1w
    @gautam-b1w 2 ปีที่แล้ว +1

    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 ?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      Yes you can switch but to show yr exp as relevant exp you have to have deep knowledge as you are experienced

  • @iccstudio1106
    @iccstudio1106 ปีที่แล้ว

    Pls share power bi CV so i can update my CV

  • @vikassinghjayara510
    @vikassinghjayara510 6 หลายเดือนก่อน +3

    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!

    • @rangamharsha
      @rangamharsha 4 หลายเดือนก่อน +1

      Can we use split ( Digit to Non digit) ..

  • @ShubhashriBhintade-qz2br
    @ShubhashriBhintade-qz2br 6 หลายเดือนก่อน

    Is she got selected?

  • @meghab2910
    @meghab2910 2 ปีที่แล้ว +1

    what will be the answer for this questions? RS50000 and 4000$ how to convert into number

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      Use 'Columns from Example' functionality in Power Query Editor in Power BI

    • @meghab2910
      @meghab2910 2 ปีที่แล้ว

      @@learnwidgiggs i have try with this but using this only 1st value is changing rest of showing errors

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      Try to enter values in 3 to 4 records and then see

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      Otherwise you can see this video(watch from 20 mins) for more reference: th-cam.com/video/zv6RWIP9rpg/w-d-xo.html

  • @g.janardhanreddyjanardhan4478
    @g.janardhanreddyjanardhan4478 11 หลายเดือนก่อน

    Voice clarity not good and next time set person from you side make interview that one and good for job seekers.

  • @arjunk8259
    @arjunk8259 2 ปีที่แล้ว +1

    was she qualified for next round ?

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +2

      Sorry, can't disclose!

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว +1

      @@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.

  • @prajaktapawar5389
    @prajaktapawar5389 5 หลายเดือนก่อน

    Is she selected??

  • @Ishu_mehta_22
    @Ishu_mehta_22 3 หลายเดือนก่อน

    great vdeo but not all answers are correct

  • @bandarusrinivasarao2857
    @bandarusrinivasarao2857 ปีที่แล้ว

    YOU KNOW😅😅😅

  • @devushivagonda4902
    @devushivagonda4902 2 หลายเดือนก่อน

    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

  • @bilhanbel7591
    @bilhanbel7591 2 ปีที่แล้ว

    these sound cracking is so annoying... but thanks for sharing

    • @learnwidgiggs
      @learnwidgiggs  2 ปีที่แล้ว

      Yeah, somehow it cracked, sorry for that.

  • @sonuy5036
    @sonuy5036 2 ปีที่แล้ว

    What is the experience of candidate

  • @mangaldeep9544
    @mangaldeep9544 2 ปีที่แล้ว

    😃

  • @realsanish
    @realsanish 14 วันที่ผ่านมา

    She is not thinking she is cheating 🤣🤣

  • @vablestory2.0
    @vablestory2.0 ปีที่แล้ว

    u know 😆

  • @Ali-ds5iy
    @Ali-ds5iy 2 ปีที่แล้ว +1

    jaan lay li larki ki

  • @bvinod8338
    @bvinod8338 ปีที่แล้ว

    Give her a minute to think so that she can google 😂

  • @beingrishi6450
    @beingrishi6450 9 หลายเดือนก่อน

    Demo Interview