Freelancer.com Business Intelligence Analyst Interview Questions and Answers

Q1. Case studies, puzzle , Sql, guesstimate, projects
Add your answer

Q1. Puzzles, probability, work experience
Add your answer

Q1. Python, pyspark
Add your answer

Q1. Behavioral round
Add your answer

Q1. Question about Googlyness
Add your answer
Q2. Question about Google Lens, a RCA question
Add your answer

NER training using deep learning

Q1. Describe the approach taken for assignment
Ans. 
I approach assignments by breaking them down into smaller tasks, setting deadlines, and regularly checking progress.
• Break down the assignment into smaller tasks to make it more manageable

• Set deadlines for each task to stay on track

• Regularly check progress to ensure everything is on schedule

• Seek feedback from colleagues or supervisors to improve the quality of work
Answered by AI
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Tell me about yourself
Ans. 
I am a Senior Data Analyst with 5+ years of experience in analyzing complex data sets and providing actionable insights.
• 5+ years of experience in data analysis

• Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• Strong problem-solving skills and ability to communicate findings to non-technical stakeholders
Answered by AI
Add your answer
Q2. Asked about recent project
Add your answer
Q3. Types of join in sql
Ans. 
Types of join in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the 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 join: Returns ro
Answered by AI
Add your answer
Q4. Case when statement questions
Add your answer

Business Related case study, signed NDA

Q1. Count number of Parameters in BERT
Add your answer
Q2. 3 sum array problem
Add your answer

They gave a span of 3 days to build an AI-powered webapp

Q1. How would you go about learning a new skill
Add your answer
Q2. Experience in cloud technologies
Ans. 
I have experience working with cloud technologies such as AWS, Azure, and Google Cloud Platform.
• Experience in setting up and managing virtual machines, storage, and networking in cloud environments

• Knowledge of cloud services like EC2, S3, RDS, and Lambda

• Experience with cloud-based data processing and analytics tools like AWS Glue and Google BigQuery
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Project details and challenges faced in the project
Ans. 
Developed a predictive model for customer churn in a telecom company
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify key factors influencing churn

• Built and fine-tuned machine learning models to predict customer churn

• Challenges included imbalanced data, feature engineering, and model interpretability
Answered by AI
Add your answer

Q1. Complex Sql Questions and problems
Add your answer
Q2. Case study about segmentation and dashboarding
Add your answer

Q1. Sql windows function
Add your answer
Q2. Joint function, it's application and definition
Ans. 
Joint function refers to the movement and stability of joints in the body.
• Joint function involves the movement of bones at a joint.

• It also includes the stability provided by ligaments and tendons.

• Examples include the knee joint allowing bending and straightening of the leg.

• Another example is the shoulder joint allowing rotation and lifting of the arm.
Answered by AI
Add your answer
Q3. Windows function , definition, application
Add your answer
Q4. Simple coding test online
Add your answer
Q5. Some question on python, tableau
Add your answer