Statistics - performance metrics, Why GBM, why not xgboost , Differences between GBM and xgboost Then bias, overfitting ,underfitting, Regularisation , Lasso regression( explain). ... Followed by extended questions
Data Interview Questions
133,160 data interview questions shared by candidates
Why do you want to work here?
What is the largest number you cannot make with some comibnation of the numbers 6, 9, and 20?
Based on my experience in different projects and analytical functions in SQL
You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month
write a code in R/SQL: Given a table with three column, (id, category, value) and each id has 3 or less category (price, size, color). Now, how can I find those id's for which the value of two or more category matches to one another? For eg: ID1 (price 10, size M, color Red), ID2 (price 10, Size L, Color Red) , ID3 (price 15, size L, color Red) Then the output should be two rows: ID1 ID2 and ID2 ID3
- What is over-fitting? How do you avoid it? - What types of regularization do we have? Which one is simpler to use? L1 or L2? - Explain decision trees? What are different metrics to classify dataset? - What is bagging? - We have two models, one with 85% accuracy, one 82%. Which one do you pick? - What is p-value and how can we use it?
Tell me about your self? What is Data Warehousing?
The interview was highly focused SQL questions such as finding the third high, finding the newest one.
1. Tell us about yourself 2. What is the Difference between analog and digital system. 3.Between analog and digital which one do we use to Start up the system. 4. What is kW and kVA 5.Explain the Building Management Systems operation. 6.What is PDU. 7.Why do you think UPS are very essential to our network because they are expensive and they can only last for 20 seconds. 8. Explain N+1, 2N and N-1. 9.Mention three components that are in the UPS, AHU,Chillers,Cooling Towers and VFDs. 10. Why do we need to synchronize/parallel the Generators. 11. Explain Variable Frequency Drive (VFD)operation. 12. Explain the process that the Chillers use to heat fro the building. you must know the operation of the chiller here. 13.Explain a Difficult situation that was out of your role where you had to make a decision , what was the outcome. 14. How do you deliver results?
Viewing 831 - 840 interview questions