Licious Data Analyst Interview Questions and Answers

Q1. Basic Excel Questions
Add your answer
Q2. Medium and Basic SQL Questions
Add your answer
Q3. Resume based Question
Add your answer
Q4. Case Study Questions
Add your answer
Q5. Questions on Project
Add your answer

Q1. SQL base Question
Add your answer
Q2. About your projects
Add your answer

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

Number sires, clock, logic, arithmetic, geometry

Code test basic, ans the basic knowledge, write code

Q1. What is python?
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

• It emphasizes code readability and uses indentation to define code blocks.

• Python has a large standard library and a vibrant community of developers.

• Example: print('Hello, World!')

• Example: import pandas as pd
Answered by AI
View 1 more answer
Q2. What is python used for?
Ans. 
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
• Data analysis and visualization

• Web development (Django, Flask)

• Artificial intelligence and machine learning (TensorFlow, PyTorch)

• Automation and scripting

• Scientific computing (NumPy, SciPy)
Answered by AI
View 1 more answer
Q3. What type of language is python?
Ans. 
Python is a high-level programming language known for its simplicity and readability.
• Python is an interpreted language, meaning it does not need to be compiled before running.

• It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

• Python has a large standard library and a thriving community, making it versatile and widely used.

• Example: Python is used for web develop...read more
Answered by AI
Add your answer
Q4. What is oops in python?
Ans. 
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
• OOP allows for the organization of code into reusable components called classes.

• Classes can have attributes (variables) and methods (functions) associated with them.

• In Python, everything is an object, and classes can be defined using the 'class' keyword.

• Encapsulation, inheritance, and polymorph
Answered by AI
Add your answer
Q5. What is array in python?
Ans. 
An array in Python is a data structure that stores a collection of elements of the same type.
• Arrays can store elements such as integers, floats, or strings.

• Arrays are indexed starting from 0, with elements accessed using their index.

• Example: arr = ['apple', 'banana', 'cherry']
Answered by AI
Add your answer

Q1. Joins and basics
Add your answer

Netflix user churn case study,
Uber booking number reduce

SQL and Python data analysis questions

Q1. How do you match the data in different columns.
Ans. 
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
• Use string matching techniques like exact match, partial match, or fuzzy matching.

• Apply data cleaning and preprocessing techniques to standardize the data before matching.

• Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

• Consider using database join...read more
Answered by AI
Add your answer

Q1. SQl questions what is rank in sql
Add your answer

Case study on fuel and diesel consumption

Q1. Why porter and how
Add your answer

Q1. What’s your previous experience
Ans. 
I have 3 years of experience as a data analyst in the finance industry.
• Worked with large datasets to extract meaningful insights

• Performed data cleaning, transformation, and visualization

• Created and maintained dashboards and reports for stakeholders

• Conducted statistical analysis and built predictive models

• Collaborated with cross-functional teams to identify business opportunities
Answered by AI
Add your answer
Q2. What’s your skills for the current role
Ans. 
I have strong skills in data analysis, including proficiency in statistical analysis, data visualization, and programming languages such as Python and SQL.
• Proficient in statistical analysis techniques

• Skilled in data visualization using tools like Tableau

• Strong programming skills in Python and SQL

• Experience with data cleaning and preprocessing

• Ability to interpret and communicate insights from data

• Familiarity with machin...read more
Answered by AI
Add your answer