TTEC India Data Analyst Interview Questions and Answers

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

Data Science, ML, Python

Q1. Asked questions on ML
Add your answer
Q2. Asked questions on Project
Add your answer

Q1. Introduce yourself,why should we hire u
Add your answer

Basic questions on SQL, Python

What are the company data analytics

Q1. Which Visulization tool you used.
Ans. 
I have experience using Tableau and Power BI for data visualization.
• Tableau is a powerful data visualization tool that allows for interactive dashboards and storytelling.

• Power BI is another popular tool for creating interactive reports and visualizations.

• I have used both tools to create visually appealing and informative charts, graphs, and dashboards.
Answered by AI
Add your answer
Q2. Intermediate level Power bi Question
Add your answer