Live SQL Interview of a Fresher | Power BI Interview😲

Подписаться 54 тыс.

Просмотров 21 тыс.

50% 1

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

Опубликовано:

7 янв 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 67

@Thetradersclub_ 6 месяцев назад

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

@harshit_dataanalyst 6 месяцев назад

Thanks

@jioguru5435 6 месяцев назад

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

@learnwidgiggs 6 месяцев назад

Glad I could help!

@saurabhMaratha 6 месяцев назад

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 6 месяцев назад

Great job!

@sarihaddu 6 месяцев назад

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

@saurabhMaratha 6 месяцев назад

@@sarihaddu check his playlist

@madhusudhanreddyt2838 6 месяцев назад

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 6 месяцев назад

Thank you sir ❤ keep posting 👐

@learnwidgiggs 6 месяцев назад

Thank you, I will.

@user-wu5zo1th5o 6 месяцев назад

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

@raghibelahi937 6 месяцев назад

Informative 💯👏

@learnwidgiggs 6 месяцев назад

Glad you liked it!

@aditjain6580 6 месяцев назад

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 6 месяцев назад

Thanks for appreciation

@learnwidgiggs 6 месяцев назад

Hope so.

@user-bj4fi3rp7k 5 месяцев назад

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

@debadattasamal2671 6 месяцев назад

Good one

@learnwidgiggs 6 месяцев назад

Thank you!

@sarbajitmitra4238 6 месяцев назад

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 6 месяцев назад

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 6 месяцев назад

@@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 6 месяцев назад

@sunidhas 2 месяца назад

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

@sameerkale7282 5 месяцев назад

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

@sriharshas9970 6 месяцев назад

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

@beingrishi6450 6 месяцев назад

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

@learnwidgiggs 6 месяцев назад

Noted.

@praveenkumarrai101 6 месяцев назад

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.

@harshit_dataanalyst 6 месяцев назад

Thanks shashank bhai for inviting me

@learnwidgiggs 6 месяцев назад

Always welcome!

@navajiskhan9305 6 месяцев назад

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

@bezawadasujatha7327 6 месяцев назад

Sir please upload resume power bi courses for freshers

@zaidnawali6543 5 месяцев назад

will microsoft fabric effect power bi job

@vasimshaikh5099 6 месяцев назад

is recuriters asked adv topic questions from freshers?

@learnwidgiggs 6 месяцев назад

No.

@prasanthkancharana 5 месяцев назад

how to say my power bi report is good?

@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

@anuragdubey4524 6 месяцев назад

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

@Travel.is_fun 4 месяца назад

Did you select this candidate for next round?

@sdlfjlsdirnsfsi232qrlfn 6 месяцев назад

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;

@prasanthkancharana 5 месяцев назад

last interview board question

@user-br2yr2zj4v 6 месяцев назад

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

@sarihaddu 6 месяцев назад

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

@learnwidgiggs 6 месяцев назад

You can check out Codebasics course.

@akshaygonjari6497 4 месяца назад

Looks like he is reading the answers.. lol

@sahilpalri9916 6 месяцев назад

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

@maheshs9963 4 месяца назад

yes

@mohanreddy007 5 месяцев назад

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

@karandiwan4160 5 месяцев назад

Yes

@sparshgoyal3159 4 месяца назад

Is this the level the interviewer ask in SQL interview?

@learnwidgiggs 4 месяца назад

To a fresher..yess

@hardiknaik9124 6 месяцев назад

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

@hardiknaik9124 6 месяцев назад

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 6 месяцев назад

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 6 месяцев назад

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