Techzone Data Analyst Interview Questions and Answers

Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join.
Add your answer
Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level.
Ans. 
Create calculated fields in Tableau to dynamically adjust to changing table columns.
• Use calculated fields to reference specific columns by name instead of position.

• Utilize parameters to allow users to select which columns to display.

• Consider using custom SQL queries to dynamically adjust to changing table structure.
Answered by AI
Add your answer
Q3. Row level security
Add your answer
Q4. Tell me about your project
Ans. 
Developed a predictive model to forecast customer churn for a telecommunications company.
• Utilized machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model performance

• Collaborated with business stakeholders to understand key drivers of churn

• Achieved 85% accuracy in predicting customer churn
Answered by AI
Add your answer

Q1. Python string is changable or not
Ans. 
Python strings are immutable, meaning they cannot be changed once created.
• Python strings are immutable, so any operation that appears to modify a string actually creates a new string object.

• For example, when you use string concatenation or slicing, a new string is created instead of modifying the original string.

• To modify a string in Python, you would need to create a new string with the desired changes.
Answered by AI
Add your answer
Q2. Sql window function ?
Add your answer
Q3. Difference between having and where cause
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after the GROUP BY clause, WHERE is applied before

• HAVING can only be used with SELECT statement that contains a GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY depar...read more
Answered by AI
Add your answer
Q4. Sql union and union all
Add your answer
Q5. Python using remove duplicate value
Ans. 
Use Python's set() function to remove duplicate values from an array of strings.
• Convert the array to a set to automatically remove duplicates

• Convert the set back to a list if needed
Answered by AI
Add your answer

Q1. Difference between Sum and Sumx
Ans. 
Sum calculates the total of a column, while Sumx calculates the total of an expression evaluated for each row.
• Sum is used to calculate the total of a column in a table.

• Sumx is used to calculate the total of an expression evaluated for each row in a table.

• Sum: SUM('Table'[Column])

• Sumx: SUMX('Table', 'Table'[Column] * 2)
Answered by AI
Add your answer
Q2. How do u make groups and how bins are different from groups
Ans. 
Groups are created by categorizing data based on certain criteria, while bins are specific ranges used to group continuous data.
• Groups are created by categorizing data based on certain criteria, such as age groups or product categories.

• Bins are specific ranges used to group continuous data, such as age ranges or income brackets.

• Groups can be created based on qualitative data, while bins are used for quantitative data.

• E...read more
Answered by AI
Add your answer
Q3. Why do you prefer power bi over tableau
Ans. 
Power BI is preferred over Tableau for its seamless integration with Microsoft products and user-friendly interface.
• Seamless integration with Microsoft products like Excel, SharePoint, and Teams

• User-friendly interface with drag-and-drop functionality for easy data visualization

• Cost-effective solution for organizations already using Microsoft products

• Faster data processing and refreshing capabilities compared to Tableau

• ...read more
Answered by AI
Add your answer
Q4. Tell me about your roles and responsibilities
Ans. 
I have experience in data collection, analysis, and visualization to support decision-making.
• Collecting and cleaning data from various sources

• Analyzing data to identify trends and patterns

• Creating visualizations and reports to communicate findings

• Collaborating with stakeholders to understand business needs

• Using statistical tools and techniques to draw insights

• Presenting findings to non-technical audiences
Answered by AI
Add your answer

1st round was Coading round was there

Q1. Coading round was there
Add your answer
Q2. Coading round was there in the interview
Add your answer

Q1. I'm changing my domain because I don't see much scope for growth in my current domain and I want to make advantage of new opportunities for learning, creativity and success. Additional, I believe that the ...read more
Add your answer
Q2. I understand that being asked to work for an extended number of hours comes with a good reason in the first place, so I'm ok with it.
Add your answer
Q3. Over the year I have really upskilled my self. I believe based on the market standards for this particular role and my experience and skill set a salary range between 10000- 35000 would be fair and appreci...read more
Add your answer
Q4. Can you share more about the day to day responsibilities of this role?
Add your answer
Q5. If I am hired for this role, what would you want me to a achieve in my first two months?
Add your answer
Q6. No ma'am certainly not. Before coming here, I read the job description thoroughly and I have the right skills and qualification required for the role.
Add your answer
Q7. I believe a change in work environment with stimulate my creativity and drive for success.
Add your answer

Coding 2 questions java

Q1. Lot of questions based on resume Oops questions 2 basic coding
Add your answer

Q1. Basic questions
Add your answer

Q1. Sql questions checking ur knowledge
Add your answer
Q2. Self join questions about sql
Add your answer

Q1. Tell me about your self
Add your answer
Q2. If experienced, then Tell me about your previous job role and responsibilities of previous job role.
Add your answer
Q3. Tell me about your resume.
Ans. 
My resume showcases my experience in data analysis, including proficiency in SQL, Python, and data visualization tools.
• Proficient in SQL for data querying and manipulation

• Skilled in Python for data analysis and automation

• Experience with data visualization tools like Tableau and Power BI

• Strong analytical and problem-solving skills

• Previous projects include analyzing sales data to identify trends and patterns
Answered by AI
Add your answer
Q4. Tell me about your memorable Moment of life.
Ans. 
My memorable moment was when I graduated from college.
• Graduating from college after years of hard work

• Celebrating with family and friends

• Feeling a sense of accomplishment and pride
Answered by AI
Add your answer