Live Interview with a Tech M : Senior Data Analyst
Вставка
- Опубліковано 5 вер 2024
- Hello Everyone,
In this video I am sharing the live interview I had attanded for the Tech Mahindra
Interviewer asked me some SQL questions. If you are preparing for the interview, then consider watching this video for understanding, How Live interview feels like.
• Live Interview with a ...
also, check a playlist on my channel to watch other live interviews.
Thanks,
**************************************************************************
Connect with me on LinkedIn :
/ akshay-ba. .
**************************************************************************
TAGS:
#data analyst, how to become a data analyst, data analyst job, data analyst career,
#data analytics, data analyst with no experience, data analyst with no degree,
#data analyst interview, data analyst interview questions, and answers,
#data analyst interview questions, data analyst interview questions for beginners,
#data analyst phone interview, data analyst in-person interview, tableau interview questions,
#tableau interview questions and answers, tableau training
select
*,
dense_rank () over (order by amount desc) as dn_rnk,
rank () over (order by amount desc) as rnk,
row_number () over (order by amount desc) as row_number
from orders
order by amount desc
last question answer
helpful
in last question you should have taken order by clause then how will you find the max number windows function mostly use in order by clause
The interviewer was even more confused. 🤣🤣 How can customer_id and shipping_id be used to join two tables?.
🤪
How can you join two tables if the columns are not common, table joined based on primary key and foreign key concept, with due respect but what the interviewer mentioned the query at time of the video 21:32 i.e. not correct, clearly "Bretty Doe" has never ordered mousepad ,his customer id is 5 , pls someone correct me if I am wrong ,right query will be below SELECT c.first_name, c.last_name, od.item, od.amount, sh.status from Customers c left join Orders od on c.customer_id=od.customer_id
left join Shippings sh
on c.customer_id=sh.customer
where c.age > 25;
other question were easy but frist question did not understand actully what they wanted
How did you got the interview call for Tech M...??? Please help
Please reply!!
Upload tableau developer videos
What was interview feedback
shortlisted for next round
Why would any data engineer become a data analyst
It’s a roadmap
Data analyst to Data engineer
akshay @ I have sent message in email i think you didnt see that message even i am giving the interveiw i have 3 years experience as data engineer . your vids helps to lot great
Sorry brother, I will check your email , please help me with your subject line or something
Interviewers r idiots thy ask irrelvnt skills which r not mentioned in cv 😂😂😂