Using CHATGPT for DATA ANALYST interview! 🧠💡

  Рет қаралды 16,300

codebasics

codebasics

10 ай бұрын

In this video, I have shared how you can use Chat GPT to conduct your data analyst job interview watch the video completely to get clarity.
ChatGPT Prompt:
Technical Interview:
1. SQL interview: Basic one
Prompt:
Conduct my SQL interview for a data analyst position
Ask questions one by one
Now ask me to write some SQL queries
2. SQL interview: Only Queries & Rating
Prompt: Take my SQL interview for a data analyst position. Ask only one question at a time. Ask me to write queries only, no theoretical questions please.
3. SQL interview: Difficulty Level
Prompt: Take my SQL interview for a data analyst position. Difficulty level should be HIGH. Ask only one question at a time.
4. Mixed Interview: Excel, SQL, Power BI
Prompt: Conduct my technical interview for a data analyst position. Ask questions on Excel, Power BI and SQL
5. Power BI Interview: Only Formulas
Prompt: take my power bi interview. ask questions on writing DAX formulas for a given use case
------------------------------------------------------------------------------------------------------------------------------------
Behavioral / Case study
Prompt 1 :
Conduct my Interview for a data analyst position. Ask case studies type questions, one by one
Prompt 2 :
Please conduct a behavioral mock-up interview with me, ask at least 5 questions.
I will give 3 Inputs based on which you ask questions
Input 1: Company Overview from their Linkedin page
------------------------------------------------------------
Input 2: Job Description
------------------------
Input 3: My Resume
------------------
Please ask behavioral questions, one by one.
Prompt 3 :
Ask some behavioral questions that are asked in data analyst interview conducted by a company called {Company Name}
------------------------------------------------------------------------------------------------------------------------------------
If you liked the video then share it with your friends and subscribe.
Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...

Пікірлер: 14
@chandrashekharbagul5825
@chandrashekharbagul5825 10 ай бұрын
Thank you sir for this wonderful information👍
@Milaar
@Milaar 10 ай бұрын
Thanks for the insight
@Neoneee8
@Neoneee8 Ай бұрын
I feel indian people working like computers 😅 really amazing😊 thanks for the information
@MrMajidparvez
@MrMajidparvez 10 ай бұрын
Thank you sir
@mahapeyuw5946
@mahapeyuw5946 10 ай бұрын
I thought of this but not to this detail. Thanks
@lijojacob12
@lijojacob12 10 ай бұрын
Thanks!
@namtutorial2742
@namtutorial2742 10 ай бұрын
Tx
@uma335
@uma335 9 ай бұрын
Sir how are you ..i'm a working mother and have 1.5year old kid with no career break ..I have total 10 Years of work experience in various technologies and currently working as an ETL developer and analyzing the issues as well in Vertica database ..i'm very much interested to do analysis using sql and lineage across the processes that exites me more to do .. but now i'm not able to decide between take path of data analyst and data scientist..can you help me in suggesting that ..i'm a silent follower of your channel from last 2 years ..but not able to take a serious note on learning yet due to the personal responsibilities..and now as my kid grown up little I wanted to kick start my learning again .. need your guidance on this 😊
@wasimbader5706
@wasimbader5706 10 ай бұрын
I need your help in data analyst course with u. One to one wen I am stuck
@vaibhavkarpe06
@vaibhavkarpe06 10 ай бұрын
As a mechanical engineer should I do data scienc or data analytics or anything else i am really confused. Is data science will be difficult for me or should i go for mba. Plz suggest me best IT course i am afraid of coding. Is coding difficult in data science
@codebasics
@codebasics 10 ай бұрын
Data analytics would be first option in my opinion. Data science learning curve is steep and requires a lot of coding. On the other hand I have seen many mechanical engineers become data analyst and building a successful career in the data industry. also once you are a data analyst, later on you can learn some extra skills and become data scientist too
@vaibhavkarpe06
@vaibhavkarpe06 10 ай бұрын
@@codebasics Thank you so much sir for taking time to reply me thanks a lot. Sir how about mba or should I go with data analytics only if first i complete my mba and then do data analytics or should I directly do data analytics. Does mba have any benefit in data analytics career. Will mba help to get more package or it is not needed.
@focus1007
@focus1007 8 ай бұрын
​@@vaibhavkarpe06no need to do MBA if u are interested in data analytics..as the basic criteria for this course is only graduation..so any graduate can become data analyst..if u have already decided to go for data analy..why to waste more time on studying mba..
@vaibhavkarpe06
@vaibhavkarpe06 8 ай бұрын
@@focus1007 yes bro thanks a lot
Data Analyst Roadmap 2023 🚀
0:43
codebasics
Рет қаралды 35 М.
That's how money comes into our family
00:14
Mamasoboliha
Рет қаралды 11 МЛН
How Many Balloons Does It Take To Fly?
00:18
MrBeast
Рет қаралды 139 МЛН
Этот Пёс Кое-Что Наделал 😳
00:31
Глеб Рандалайнен
Рет қаралды 4,2 МЛН
Data Analyst Skills Required | Job-Ready Checklist 🚀🚀
11:01
Data Analyst Job Interview - Don't make these 7 mistakes
11:02
How to get data analyst job as a fresher in 2024
16:19
codebasics
Рет қаралды 186 М.
How to Become a Data Analyst in 2023 (Completely FREE!)
13:59
Alex The Analyst
Рет қаралды 1 МЛН
5 Projects for a Data Analyst Job | All Materials Included
7:16
codebasics
Рет қаралды 197 М.
That's how money comes into our family
00:14
Mamasoboliha
Рет қаралды 11 МЛН