Live SQL Interview of a Fresher | Power BI Interview😲

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

[@jioguru5435]

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

[@learnwidgiggs]

Glad I could help!

[@Thetradersclub_]

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

[@harshit_dataanalyst]

Thanks

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

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

[@user-wu5zo1th5o]

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

[@nishantbahakar5626]

Thank you sir ❤ keep posting 👐

[@learnwidgiggs]

Thank you, I will.

[@raghibelahi937]

Informative 💯👏

[@learnwidgiggs]

Glad you liked it!

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

[@sriharshas9970]

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

[@user-bj4fi3rp7k]

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

[@sameerkale7282]

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

[@debadattasamal2671]

Good one

[@learnwidgiggs]

Thank you!

[@Travel.is_fun]

Did you select this candidate for next round?

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

[@zaidnawali6543]

will microsoft fabric effect power bi job

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

[@bezawadasujatha7327]

Sir please upload resume power bi courses for freshers

[@prasanthkancharana]

how to say my power bi report is good?

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

[@anuragdubey4524]

sir i also want to take your mock interview for sql please guide 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

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

[@vasimshaikh5099]

is recuriters asked adv topic questions from freshers?

[@learnwidgiggs]

No.

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

[@user-br2yr2zj4v]

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.

[@sahilpalri9916]

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

[@maheshs9963]

yes

[@prasanthkancharana]

last interview board question

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

[@akshaygonjari6497]

Looks like he is reading the answers.. lol

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

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

[@user-in3br6dw1r]