Excitel Broadband Data Analyst Interview Questions and Answers

There was a question which say, write the string in the reverse order.

Q1. What are your strengths and weakness.
Ans. 
My strengths include strong analytical skills and attention to detail. My weakness is that I can be overly critical of my own work.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Overly critical of my own work
Answered by AI
Add your answer
Q2. Tell me about yourself
Ans. 
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
• Proficient in SQL, Python, and Excel for data analysis

• Skilled in data visualization using Tableau and Power BI

• Experience in conducting statistical analysis and creating predictive models

• Strong problem-solving and critical thinking skills

• Effective communication and presentation skills

• Ability to work collaborati
Answered by AI
Add your answer

Q1. 1) Resume explanation
Add your answer

Python and SQL coding test along with basic data science questions
Python was on basic syntax. SQL was on medium difficulty

Q1. Correlation vs causation Central limit theorem Support Vector Machines Confusion matrix Basics of Deep Learning - activation function, optimizers and initialisation techniques Z score, P value Differenc...read more
Add your answer

Q1. Questions about my background My hobbies and interests
Add your answer

Writting speed test of a paragraph

Q1. Can you automate dashobaord on excel on daily routine, Do you know proper formulation of dashboard.
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

Python and SQL Questions (Easy to Medium)

Q1. Project Work Discussion
Add your answer
Q2. SQL Coding (Can be with an online compiler)
Add your answer
Q3. Python Coding (Can be with an online compiler)
Add your answer
Q4. PySpark Coding (All the coding answers have to be submitted to the interviewer)
Add your answer
Q5. PySpark Joins, and Databricks, and Vanilla Spark difference
Add your answer

Q1. SQL 2 Questions (Easy to Medium) (Maybe on the compiler)
Add your answer
Q2. Python (Easy) (Maybe on compiler)
Add your answer
Q3. Scenario-based questions on the project
Add your answer

Q1. Basic questions about previous experience.
Add your answer

Q1. SQL questions Basic
Add your answer
Q2. SQL questions advanced
Add your answer

Based on your job description coding questions will be asked in different categories. If you are able to manage time. It is easy to crack

Q1. Optimization techniques in pyspark
Ans. 
Optimization techniques in pyspark involve partitioning, caching, and using efficient transformations.
• Partitioning data to distribute workload evenly

• Caching frequently accessed data to avoid recomputation

• Using efficient transformations like map, filter, and reduce

• Avoiding unnecessary shuffling of data
Answered by AI
Add your answer
Q2. Few coding questions. Find the first unique character in string
Add your answer

Q1. It is bit difficult for me. Mention your work experience
Add your answer