Data Analyst live Mock Interview | SQL | Power BI | Data Science - Must Watch!!
Vložit
- čas přidán 9. 02. 2024
- 🌟 Talentele Institute, Bhubaneswar: Your premier destination for Data Science & Analytics training!
👉 Rated No.1 in Bhubaneswar for Data Science and Analytics training with an impeccable placement record!
🏆 Proudly MSME Registered Company!
Courses Offered:
Data Analytics
Data Science
HR Data Analytics
Banking & Finance Analytics
Pharma Data Analytics
Business Analytics
Program Highlights:
👉 Comprehensive tools & program coverage: SQL, Tableau, Python, Advanced Excel & Power BI.
👉 Expertise in Data Analytics, Business Analytics, and Machine Learning techniques.
👉 Hands-on domain exposure: Marketing, Retail, Banking, Finance, HR, Sales.
👉 Real-life project-based learning with 4 industry-partnered capstone projects.
👉 Tailored resume building for enhanced job prospects.
👉 Step-by-step transition guidance by experienced professionals.
👉 Guaranteed 100% job assistance until you secure your dream job.
👉 Soft skills development: Master the art of stakeholder presentations.
👉 Mock interview sessions for real-world preparation.
🤴 Earn prestigious Data Science certificates & internship letters upon completion.
Faculty: Learn from industry experts, including Dell & Oracle employees currently serving as Data Science Managers.
For inquiries and admissions:
📞 Call or message us now: +91 7205617787
🌐 Visit our website: www.talentele.in
Unlock your potential in Data Science & Analytics with Talentele Institute!
#DataAnalytics
#DataScience
#BigData
#MachineLearning
#ArtificialIntelligence
#PredictiveAnalytics
#BusinessIntelligence
#DataMining
#DataVisualization
#AI
#Statistics
#Python
#RProgramming
#SQL
#DataDriven
#Analytics
#DeepLearning
#DataInsights
#DataEngineering
#DataAnalysis
#DataModeling
#DataPreprocessing
#DataQuality
#BusinessAnalytics
#DataManagement
#MachineLearningAlgorithms
#DataScientists
#DataStrategy
#DigitalTransformation
#IoT
#CloudComputing
#DataWarehousing
#DataIntegration
#DataSecurity
#DataGovernance
#DataLiteracy
#DataEthics
#DataInnovation
#DataCulture
#DataChallenges
#DataTrends
#DataFuturist
#DataSolutions
#DataVisualization
#DataPrivacy
#DataCollection
#DataEngineering
#DataOps
#DataTech
#DataCareer
Why i am getting nervous by seeing this video 😂
Same here brother 😵
Yes
He did excellent job.... Confidently he said what he practice 👌
Yes 🙌🏻🔥
Thanks for sharing this wonderful video
I think he did a brilliant job👍👍
We can use physical column of a table to filter using where....while aggregated column we use having though aggregated column can be used in where clause but that will required sub/nested query
I would like to give thank to entire Talentele teams for their good initiative. It will definitely help many students in preparing for their job interviews🎉🎉🎉🎉
Thanks a lot for your valuable feedback! 😊
Ama odia toka re...Great ❤
Having clause is used with aggregate function
Merge is same as JOIN
And its join horizontally and not vertically
For vertically we use UNION in SQL and append in power query
He asked it in power BI, for which we use merge query to join two tables horizontally and append query to merge two tables vertically
Excellent interview ❤🎉
Helpful Indeed !!! Thank you sir .
😊
Excellent interview 👍
Hey soumya ! Thanks 🙏🏻
Great Job
Thanks a lot 😊
Follow my CZcams channel for the SQL Pyspark DSA in python Oops in python Pandas scenarios based interview questions and answers preparation:
youtube.com/@dewithdhairy
He is definitely good at sql
Good job Shubrakant 🎉😊
Indeed ! 🎉😊
Sir can u provide experience resume for data analyst
I didn't receive any calls or emails from the recruiter for data analyst
i think aggreagate functions not used with where clause for using that functions we use having clause that's the main difference
yes
Itna easy interview hota hai kya. Ek mai hi hu kya i always face toughest questiom in all the interview
can you recall few tough questions which you find difficult in ur interview?
It's mock interview 😅😅 not real one , 😅
😂😂😂😂😂😂
We cannot use where with aggregate functions
He seems really nervous but handling this quite well...
Yes as a beginner he is a bit nervous but conceptually strong enough ! 😊
Data analytics ke job mile tho knowledge gain ho study kr tho lete hai but na training milte na jeldi job 🥲
Aggregate function not use with 'where' quary
Please currect 😊
👏
The candidate is undoubtedly a gem, has an exceptional SQL skill with a portfolio of over 500 independently completed assignments and completed numerous assignments in platforms like HackerRank and LeetCode. As the interview was scheduled abruptly, without prior notice, it's understandable that the candidate may have felt somewhat unprepared. Despite facing challenges, we believe in his talent and potential. However, we wish him the best to continue his journey of excellence!
We can use aggregate functions with a WHERE clause.
SELECT SUM(sales_amount)
FROM sales
WHERE sales_date >= '2024-01-01' AND sales_date
@@tastetrekntravel bro understand the question first...
You can't use aggregate function with where clause
Select name from Xyz
Where count(name) > 1 this gives an error
You can use aggregate function with having clause
We can use but depend on the question.
Ajitesh is my friend. Proud of u bro
Thanks ra 🙌🏻
@@ajitesh7356got job bro?
Dmmm that's so easy questions for him 😮
woah reaalyy??damn then how hard it would be??
Easiest sql interview ever 🙂↔️ I’ve attended zoho but they asked me to write query 😢 somehow I managed . I guess I’ll not select 😢
Don't worry bro, you'll get selected
@@DataAnalyst251rejected in technical round 🥹🤡
@Navz10 keep working hard, you'll get selected soon
@@DataAnalyst251😔😔😔😔😔😔
@@Navz10 i'M ALSO LOOKING FOR dATA JOB ONLY. ALL WE CAN DO I TRY AND WORK HARD, RESULTS ARE NOT IN OUR HAND
This much knowledge is enough for a DA technical interview .I mean we did not have to solve scenario base questions .I confused a lot into it.
You have to be an expert in direct and scenario based question, we have just asked basic questions to the candidate for screening.
@@talentelelearning2486 make a video on senerieo base questions
@@shohaibameer1043 noted ! 👍🏻
we cant use aggregate functions with where clause or next to where clause
You can use aggregate functions in the WHERE clause, but the data gets filtered first, and then it's going to pass through the WHERE clause. If you want to filter data right after an aggregate function, then use the HAVING clause
How many types of indexes we have in sql, can anybody give the ans of this question as it was mentioned in the interview
In SQL, there are various types of indexes used to optimize database performance:
1. Single-Column Index: Index created on a single column to speed up retrieval based on its values.
2. Composite Index: Index on multiple columns, aiding queries involving those columns.
3. Unique Index: Enforces uniqueness of values in indexed columns, preventing duplicates.
4. Clustered Index: Determines physical order of rows in a table, based on indexed column(s).
5. Non-Clustered Index: Creates separate structure for index keys and row pointers, not affecting row order.
6. Bitmap Index: Specialized for data warehousing, storing bitmaps for each unique value for fast retrieval.
7. Function-Based Index: Based on result of function applied to column(s), speeding up queries involving the function.
8. Spatial Index: Optimizes querying of spatial data types, aiding operations like distance calculations.
These index types may vary based on the specific database management system being used.
@@aaryantiwari2106🎉
It seems that he is not comfortable in sql, he needs to work hard, i wish him all the best anyways.
The candidate is undoubtedly a gem, has an exceptional SQL skills with a portfolio of over 500 independently completed assignments and completed numerous assignments in platforms like HackerRank and LeetCode. As the interview was scheduled abruptly, without prior notice, it's understandable that the candidate may have felt somewhat unprepared. Despite facing challenges, we believe in his talent and potential. However we wish him the best to continue his journey of excellence !
@@talentelelearning2486as he is from odisha...our main Lang is not English..so we are not comfortable in expressing our thoughts in English...
No he is good at SQL
@@madhupylahis basics are very strong
Is python required by data analyst?
I am searching for the data analyst role. I am having around 2 years experience. If there is any vacancy for the analyst role, please help me so that i can give you better interview. Thank you!
Literary bro you have no job after data analytics
I am searching job in Data analytics can any one help mi for this
Same here.... I have knowledge of Advance Excel, SQL and power query along with basic power bi
Its not good habit to ask format of any function in interview, someone can ask what that function does
Yes it is ! I have been in panel for more than a 15 years , in this question you can evaluate if the candidate has really used the function or just faking it. candidates those who have worked can confidently answer this question.
Groupby , then having.
🔥👍🏻
Daya analyst bane ke liye kaunsa course karna hotha hai
In order to become a data analyst you should learn Python/R, Power BI/ Tableau/ SAS , SQL/ NoSqL and heap of other stuff mate.
How to become data analyst with non coding background?
Learn SQL,EXCEL and POWERBI
@@DataAnalyst251 brother buy paython ka kya karege paythone bhi hai nja data analyst k liye
@@rks_rohit680 Python also needed, but first perfect SQL,EXCEL and PowerBI. If you're perfect then move to python
bhai ye jis company m data analystt ho gya vha k beda garg ho gya hoga
What is the minimum salary for freshers in india
It ranges between 3 lacs to 7lacs.
Is he selected
Is there Any institute in Kolkata who gave Data Analyst Training and placement?
Don't get into Fake Job Guarantee Programs ! There are many such institutes who are making false promises.
@@talentelelearning2486 any secured institution you know please suggest me
@@sayandutta_0184get in iift Kolkata
@@talentelelearning2486 yes sir right so please tell me from where can i learn data analyst..?
bhai 1 year ka experience he normlization nai pata? use define function nai banaya?😑😑
bhai itta bada hogya spellings nii aati 😑
@@heh-satyam finally someone noticed the spelling mistakes 😂
@@_jatin_Vaishnav329 😑
kya iss bhai ka selection hua tha?
Yes
BSC physics to IT 😂😂 everyone want to IT job
He needs to practice well , he doesnt know about normalisation in sql😂
Wanna give a try ? Ready for a mock interview ?
Bcoz he is from physics background and I think he skipped DBMS
is this staged?
SELECT SAL*12+SAL*12*0.20 HIKE
FROM EMPLOYEE
WHERE RATING= 1 ;
Like this we can write 3 separate queries.
Asking to update
@@user-bt4pz2jl6nyes
he was right using Update and case you can write a single query.