Lead Data Analyst

filter-iconFilter interviews by

Lead Data Analyst Interview Questions and Answers

Updated 3 Jul 2024

Popular Companies

search-icon

Q1. 1.Difference between loc and iloc in pandas. SQL queries 2.Pivot the table. 3.find the cummaltive sum of orders till the current day. Scenario based questions like - How will you address decline in revenue. Be...

read more
Ans.

loc and iloc are two methods in pandas used for selecting data from a DataFrame based on labels or integer index.

  • loc is label-based, meaning you specify the row and column labels to select data

  • iloc is integer index-based, meaning you specify the row and column indices to select data

  • Example: df.loc['row_label', 'column_label'] vs df.iloc[row_index, column_index]

Q2. What are the data relevant for any derivative transaction

Ans.

Data relevant for derivative transactions include underlying asset, contract terms, market price, expiration date, and counterparty information.

  • Underlying asset (e.g. stock, commodity, currency)

  • Contract terms (e.g. type of derivative, quantity, strike price)

  • Market price of the underlying asset

  • Expiration date of the contract

  • Counterparty information (e.g. name, creditworthiness)

Q3. Explain how a data is analysed

Ans.

Data analysis involves cleaning, transforming, and interpreting data to extract meaningful insights.

  • Data is collected from various sources such as databases, surveys, or sensors

  • The data is cleaned to remove errors, duplicates, and inconsistencies

  • Data is transformed and structured for analysis using tools like Excel, Python, or R

  • Statistical techniques and machine learning algorithms are applied to identify patterns and trends

  • Visualizations such as charts or graphs are created ...read more

Lead Data Analyst Jobs

Lead Data Analyst 8-12 years
KOCH BUSINESS SOLUTIONS INDIA PRIVATE LIMITED
3.5
Bangalore / Bengaluru
Lead Data Analyst 8-11 years
Epsilon Asia Group Of Companies
4.0
Bangalore / Bengaluru
Lead Data Analyst - Axial Data, Analytics, AI 4-7 years
AstraZeneca India Pvt. Ltd
4.1
Chennai
Are these interview questions helpful?
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.8
 • 565 Interviews
4.0
 • 223 Interviews
3.1
 • 115 Interviews
4.0
 • 93 Interviews
4.0
 • 90 Interviews
3.4
 • 81 Interviews
3.5
 • 35 Interviews
View all

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

Recently Viewed
SALARIES
Blinkit
INTERVIEWS
C5i
No Interviews
SALARIES
Blinkit
DESIGNATION
JOBS
C5i
No Jobs
SALARIES
Future Retail
SALARIES
Capgemini
SALARIES
Ceat Tyres
SALARIES
Blinkit
SALARIES
Tech Mahindra
Lead Data Analyst Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter