Dish Network Data Scientist Interview Questions and Answers

DSA question Easy to Medium level

Q1. The concept-based, problem statement and projects worked on.
Add your answer

Q1. Mostly scenario based questions and some advanced topics
Add your answer

Numpy,pandas,data analysis

Q1. Explain projects u had worked
Add your answer

Coding on Computer vision, NLP and Recommendation system, any 1 could be picked and solved

Q1. Integration and differentiation, Machine learning math behind it
Add your answer
Q2. Linear regression assumptions, SVM model
Add your answer

Q1. Expectation from the role and compensation
Ans. 
Expectations include utilizing data to drive insights and decisions, contributing to business growth, and competitive compensation.
• Utilize data to drive insights and decisions

• Contribute to business growth through data-driven strategies

• Expect competitive compensation based on experience and skills
Answered by AI
Add your answer
Q2. Behavioral questions
Add your answer

Q1. Can you automate dashobaord on excel on daily routine, Do you know proper formulation of dashboard.
Ans. 
Yes, I can automate dashboards on Excel for daily routines and I am familiar with proper formulation of dashboards.
• I can use Excel functions like VLOOKUP, SUMIF, and PivotTables to create dynamic dashboards

• I can set up macros and scripts to automate data import and visualization

• I can design visually appealing charts and graphs to present data effectively

• I can schedule automatic updates and refreshes for the dashboard o
Answered by AI
Add your answer
Q2. How many years experience do you have in sql. Please provide solution for some sql technical questions. Or can you properly provide adhoc requirement by urgently analysing on compony database. There was s...read more
Add your answer

Easy Aptitude and SQL questions

Q1. Guesstimate question
Add your answer
Q2. SQL Joins and DSA
Add your answer

Q1. Difference between joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer
Q2. Window function
Add your answer

Q1. Write sql query in pythons
Ans. 
Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.
• Use libraries like pandas or sqlalchemy to execute SQL queries in Python

• Remember to establish a connection to the database before executing queries

• Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries
Answered by AI
Add your answer