Tekskills Data Analyst Interview Questions and Answers

Q1. Explain recent 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 patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer
Q2. Cloud technologies used
Ans. 
Various cloud technologies like AWS, Azure, and Google Cloud are commonly used for data analysis.
• AWS (Amazon Web Services)

• Azure (Microsoft Azure)

• Google Cloud Platform
Answered by AI
Add your answer

Performance based questions

Q1. General questions about SQL ( Using Group By, Rank, Dense Rank, Views, Limit, Aggregates)
Add your answer
Q2. Tasks in Power BI ( How you will transform data to visualize it)
Ans. 
In Power BI, data transformation involves cleaning, shaping, and modeling data to create visualizations.
• Import data from various sources such as Excel, SQL databases, or online services

• Clean and transform data using Power Query Editor

• Create relationships between different data tables

• Use DAX formulas to calculate new columns or measures

• Design visualizations like charts, graphs, and tables to present insights
Answered by AI
Add your answer
Q3. What visualizations you use for different forms of data and contexts?
Ans. 
I use a variety of visualizations such as bar charts, line graphs, scatter plots, and heat maps depending on the type of data and context.
• Bar charts are useful for comparing categories of data

• Line graphs are great for showing trends over time

• Scatter plots help in identifying relationships between variables

• Heat maps are effective for visualizing large datasets and identifying patterns
Answered by AI
Add your answer