No video

Using CHATGPT for DATA ANALYST interview! 🧠💡

  Рет қаралды 17,050

codebasics

codebasics

Күн бұрын

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.co...

Пікірлер: 14
@chandrashekharbagul5825
@chandrashekharbagul5825 11 ай бұрын
Thank you sir for this wonderful information👍
@Milaar
@Milaar 11 ай бұрын
Thanks for the insight
@mahapeyuw5946
@mahapeyuw5946 Жыл бұрын
I thought of this but not to this detail. Thanks
@MrMajidparvez
@MrMajidparvez 11 ай бұрын
Thank you sir
@calliest4r
@calliest4r 2 ай бұрын
I feel indian people working like computers 😅 really amazing😊 thanks for the information
@lijojacob12
@lijojacob12 11 ай бұрын
Thanks!
@uma335
@uma335 11 ай бұрын
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 😊
@namtutorial2742
@namtutorial2742 Жыл бұрын
Tx
@vaibhavkarpe06
@vaibhavkarpe06 11 ай бұрын
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 11 ай бұрын
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 11 ай бұрын
@@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 10 ай бұрын
​@@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 10 ай бұрын
@@focus1007 yes bro thanks a lot
@wasimbader5706
@wasimbader5706 Жыл бұрын
I need your help in data analyst course with u. One to one wen I am stuck
Data Analyst Roadmap 2023 🚀
0:43
codebasics
Рет қаралды 40 М.
Люблю детей 💕💕💕🥰 #aminkavitaminka #aminokka #miminka #дети
00:24
Аминка Витаминка
Рет қаралды 470 М.
Кадр сыртындағы қызықтар | Келінжан
00:16
Little brothers couldn't stay calm when they noticed a bin lorry #shorts
00:32
Fabiosa Best Lifehacks
Рет қаралды 20 МЛН
Magic? 😨
00:14
Andrey Grechka
Рет қаралды 20 МЛН
Data Analyst Mock Interview
17:45
Avery Smith | Data Analyst
Рет қаралды 7 М.
How I use SQL as a Data Analyst
15:30
Luke Barousse
Рет қаралды 822 М.
How to get data analyst job as a fresher in 2024
16:19
codebasics
Рет қаралды 196 М.
Data Analyst Skills Required | Job-Ready Checklist 🚀🚀
11:01
Data Analyst Job Interview - Don't make these 7 mistakes
11:02
Data Scientist Interview - Uber | AB Testing + SQL
48:15
DataInterview
Рет қаралды 20 М.
Люблю детей 💕💕💕🥰 #aminkavitaminka #aminokka #miminka #дети
00:24
Аминка Витаминка
Рет қаралды 470 М.