Live SQL Interview of a Fresher | Power BI Interview😲

Рет қаралды 20,594

5 ай бұрын

Harshit Srivastava Power BI Interview Video Link:
• Live Interview of a Fr...
-------------------------------------
Codebasics Data Analyst Bootcamp Link:
codebasics.io/bootcamps/data-...
-------------------------------------
Topmate Link to book call 1:1 - topmate.io/learnwidgiggs
-------------------------------------
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 : / learnwidgiggs
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

Пікірлер: 67

@user-wu5zo1th5o 5 ай бұрын

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

@Thetradersclub_ 5 ай бұрын

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

@harshit_dataanalyst 5 ай бұрын

Thanks

@saurabhMaratha 5 ай бұрын

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 5 ай бұрын

Great job!

@sarihaddu 5 ай бұрын

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

@saurabhMaratha 5 ай бұрын

@@sarihaddu check his playlist

@jioguru5435 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

Glad I could help!

@madhusudhanreddyt2838 5 ай бұрын

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…

@nishantbahakar5626 5 ай бұрын

Thank you sir ❤ keep posting 👐

@learnwidgiggs 5 ай бұрын

Thank you, I will.

@raghibelahi937 5 ай бұрын

Informative 💯👏

@learnwidgiggs 5 ай бұрын

Glad you liked it!

@aditjain6580 5 ай бұрын

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 5 ай бұрын

Thanks for appreciation

@learnwidgiggs 5 ай бұрын

Hope so.

@user-bj4fi3rp7k 4 ай бұрын

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

@debadattasamal2671 5 ай бұрын

Good one

@learnwidgiggs 5 ай бұрын

Thank you!

@sriharshas9970 5 ай бұрын

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

@sameerkale7282 5 ай бұрын

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

@sarbajitmitra4238 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

@@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 5 ай бұрын

@sunidhas 2 ай бұрын

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

@harshit_dataanalyst 5 ай бұрын

Thanks shashank bhai for inviting me

@learnwidgiggs 5 ай бұрын

Always welcome!

@navajiskhan9305 5 ай бұрын

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

@praveenkumarrai101 5 ай бұрын

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.

@bezawadasujatha7327 5 ай бұрын

Sir please upload resume power bi courses for freshers

@zaidnawali6543 5 ай бұрын

will microsoft fabric effect power bi job

@beingrishi6450 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

Noted.

@Travel.is_fun 3 ай бұрын

Did you select this candidate for next round?

@avishekmitra1175 5 ай бұрын

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 5 ай бұрын

You should learn parallelly with your current job.

@avishekmitra1175 5 ай бұрын

Thanks for your advice @@learnwidgiggs

@prasanthkancharana 5 ай бұрын

how to say my power bi report is good?

@anuragdubey4524 5 ай бұрын

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

@vasimshaikh5099 5 ай бұрын

is recuriters asked adv topic questions from freshers?

@learnwidgiggs 5 ай бұрын

No.

@prasanthkancharana 5 ай бұрын

last interview board question

@user-br2yr2zj4v 5 ай бұрын

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

@sarihaddu 5 ай бұрын

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

@learnwidgiggs 5 ай бұрын

You can check out Codebasics course.

@akshaygonjari6497 4 ай бұрын

Looks like he is reading the answers.. lol

@sahilpalri9916 5 ай бұрын

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

@maheshs9963 4 ай бұрын

yes

@sdlfjlsdirnsfsi232qrlfn 5 ай бұрын

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;

@mohanreddy007 5 ай бұрын

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

@karandiwan4160 4 ай бұрын

Yes

@sparshgoyal3159 4 ай бұрын

Is this the level the interviewer ask in SQL interview?

@learnwidgiggs 4 ай бұрын

To a fresher..yess

@hardiknaik9124 5 ай бұрын

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

@hardiknaik9124 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

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