Live SQL Interview of a Fresher | Power BI Interview😲

[@saurabhMaratha]

i have finished your Power bi dax interview questions playlist and i was really impressed plus shocked to know that in interview the level of DAX is really high and I Learned what DAX can do this is all because of your Playlist Keep making such videos I am going finish all of your videos related SQL and Power bi

[@learnwidgiggs]

Great job!

[@sarihaddu]

Could you give me the link to the Power Bi Dax video you are talking about?

[@saurabhMaratha]

@@sarihaddu check his playlist

[@Thetradersclub_]

Best of luck harshit bro, you are doing great, just never stop learning.❤

[@harshit_dataanalyst]

Thanks

[@amanahmed6057]

Harshit be confident ✌️✨

[@harshit_dataanalyst]

Thanks shashank bhai for inviting me

[@learnwidgiggs]

Always welcome!

[@navajiskhan9305]

Hi harshit, you are so good in SQL.... Would you like to share your resources/website/ yt channel what you are following to prepare for SQL questions

[@aditjain6580]

Very useful interview session. Thank you for conducting this session for us sir. Harshit will also definitely get a job very soon. He is doing really well.

[@harshit_dataanalyst]

Thanks for appreciation

[@learnwidgiggs]

Hope so.

[@MahammedKareemulla]

its better to add asked questions into description. will helpfull to all.

[@jioguru5435]

That's what I am waiting for. Thank you very much!

[@learnwidgiggs]

Glad I could help!

[@madhusudhanreddyt2838]

for the candidates and votes query…there is no need to again use the max function you already got candidate wise month wise total vote share in the cte..next step you can use a top function and write query as select top 1 candidateid, votemonth, votecount from cte order by votecount desc;..reason is he want to get the only candidate who got max vote share month wise…

[@DevakrishnaGadupudi]

The answer given in the video is wrong, but if we use Top(1) for CandidateID also we get only the candidateID having highest number of votes, it won't show month wise right?

[@sarbajitmitra4238]

I think the left join answer will be total of 9 records. 7 records from table1 and A,B common records from table2. Harshit a very well interview, I am learning so much from you, keep going hope we will get a Data Analyst job soon.

[@vibhudawar7029]

Shouldn't it be 7 only? Records that match will match, else unique records in the left table will come. I believe that in left join, after joining left, all the records of only left table will come So this should be: A, B, B, C, null, D, E only. Since left table has these records only.

[@sarbajitmitra4238]

@@vibhudawar7029 But the concept is like your left table will be printed as it is plus the matching records from the right table and vice versa. ?

[@harshit_dataanalyst]

8

[@sunidhas]

@@vibhudawar7029 A has 2 matches . So it should be 8

[@nishantbahakar5626]

Thank you sir ❤ keep posting 👐

[@learnwidgiggs]

Thank you, I will.

[@sameerkale7282]

Can you please upload one for 4 years experienced person on SQL ?

[@beingrishi6450]

Shashank make a mock interview in Alteryx with some professional it's very important application tools who works in self service ETL tool

[@learnwidgiggs]

Noted.

[@RajeshManepalli-o8b]

where clause is use to filter on existing column where as having clause is used to filter on aggregated column

[@raghibelahi937]

Informative 💯👏

[@learnwidgiggs]

Glad you liked it!

[@sriharshas9970]

Execution will start from table then where clause, join, select

[@akshaygonjari6497]

Looks like he is reading the answers.. lol

[@sebakkarmakar975]

Sir i want to give a mock interview .. please sir conduct for a mock interview in sql for me

[@avishekmitra1175]

Presently I am working as a IT business analyst (requirements gathering, stakeholders management, project delivery etc.) but I want to switch my career in data/business analytics domain. I am very interested to learn SQL, Power BI, python etc. Is it good if I quit my job and started preparing for my dream job?

[@learnwidgiggs]

You should learn parallelly with your current job.

[@avishekmitra1175]

Thanks for your advice ​@@learnwidgiggs

[@PratibhaYadav-c8d]

anyone can explain the left join tale answer i didn't understand it ??

[@rangamharsha]

5:56. Left join Aa Aa Bb Bb Cnull Null null Dd Enull.. Any one correct me if i am wrong

[@praveenkumarrai101]

I think the query he has given to the question of having election table is wrong beacuse max with group by will give many all user_id but we need single hence row_number should be used.

[@debadattasamal2671]

Good one

[@learnwidgiggs]

Thank you!

[@ShrikantMaduri]

Shashank Bro can pls tell me from where I can learn the Power BI course.

[@sarihaddu]

If you want online or offline, there is one trainer in Hyd, clear explanation. Ping me if you need further details.

[@learnwidgiggs]

You can check out Codebasics course.

[@vasimshaikh5099]

is recuriters asked adv topic questions from freshers?

[@learnwidgiggs]

No.

[@sameerkale7282]

Bro what are various tools they are demanding with power bi ?

[@sdlfjlsdirnsfsi232qrlfn]

SELECT EXTRACT(month from VoteDate) as month ,Candidate_ID ,COUNT(voter_ID) as voter_count FROM Elections GROUP BY EXTRACT(month from VoteDate), Candidate_ID ORDER BY COUNT(voter_id) DESC;

[@Travel.is_fun]

Did you select this candidate for next round?

[@sahilpalri9916]

Acc to me ,In joins we will get 9 records Am i correct?

[@maheshs9963]

yes

[@mohanreddy007]

Learning Power BI and Sql can I get job as a fresher

[@karandiwan4160]

Yes

[@sparshgoyal3159]

Is this the level the interviewer ask in SQL interview?

[@learnwidgiggs]

To a fresher..yess

[@bezawadasujatha7327]

Sir please upload resume power bi courses for freshers

[@anuragdubey4524]

sir i also want to take your mock interview for sql please guide me

[@zaidnawali6543]

will microsoft fabric effect power bi job

[@prasanthkancharana]

how to say my power bi report is good?

[@hardiknaik9124]

T1 T2- inner join- num rec-8 A A A A B B B B C Null Null Null D D E Null

[@hardiknaik9124]

Cte doesn't store the data it is only for that instance like for that query run and temp tables actually store the data and it will get removed if you terminate SQL connection or server connection basically after disconnecting... correct if I'm wrong

[@hardiknaik9124]

Delete use to remove or delete particular record from dataset with where clause for specifying condition from where we want to delete that and if we do not use where clause with delete them it will delete all the records from the table... whereas truncate delete the all the records from the table without any condition and the table will remain same with schema.

[@hardiknaik9124]

WITH MonthlyVotes AS ( SELECT candidateID, MONTH(VoteDate) AS month, COUNT(VoterID) AS numvote, ROW_NUMBER() OVER(PARTITION BY MONTH(VoteDate) ORDER BY COUNT(VoterID) DESC) AS rank FROM election GROUP BY candidateID, MONTH(VoteDate) ) SELECT candidateID, month, numvote FROM MonthlyVotes WHERE rank = 1; Easy way just rank records partition by month in desc order

[@prasanthkancharana]

last interview board question

[@quartz9793]

Abe koi job nahi hai data analyst ka...faltu video mat dal🤦🤦

[@insidehead]

B

[@learnwidgiggs]

That was a typing mistake. Its B, null

[@insidehead]

@@learnwidgiggs THEN IT SHOULD GIVE 8 VALUES.

[@karankalimuthu8221]

@@insidehead can you explain how bro?

[@RakeshKumar-r7w5b]