Upload Button Icon Add office photos

Filter interviews by

iSOCRATES Senior BI Analyst Interview Questions and Answers

Updated 17 Feb 2025

iSOCRATES Senior BI Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Aug 2024.

Round 1 - Technical 

(1 Question)

  • Q1. What are the fundamental skills and knowledge areas that a Business Intelligence (BI) analyst should possess?
  • Ans. 

    A BI analyst should possess skills in data analysis, data visualization, SQL, business acumen, and communication.

    • Strong data analysis skills to interpret and analyze complex data sets

    • Proficiency in data visualization tools like Tableau or Power BI

    • Advanced SQL knowledge for querying databases and extracting data

    • Understanding of business processes and acumen to translate data into actionable insights

    • Excellent communicati...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Please refrain from attending the interview, as it may waste your time.

Senior BI Analyst Jobs at iSOCRATES

View all

Interview questions from similar companies

Analyst Interview Questions & Answers

InMobi user image abishek saju

posted on 15 Dec 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Why do you want to work here
Round 2 - One-on-one 

(1 Question)

  • Q1. Explain your previous work experience

Analyst Interview Questions & Answers

Mediamint user image The student Of iter

posted on 19 Dec 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

It is easy to solve and understand.

Round 2 - Aptitude Test 

Simple to solve and easy to calculate

Round 3 - HR 

(2 Questions)

  • Q1. Can you tell me about yourself? What are your hobbies? What is digital marketing?
  • Q2. Ask me any questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for communication.

Analyst Interview Questions & Answers

WPP user image Anonymous

posted on 12 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Accountings based question
  • Q2. P2p cycle and invoicing process

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

2 hour test in which questions asked

Round 2 - Group Discussion 

Moonlighting or good carrer apth

Interview Preparation Tips

Interview preparation tips for other job seekers - good
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Prepare SQL and Pyspark well
  • Q2. Prepare well on SQL Joins
Round 2 - One-on-one 

(1 Question)

  • Q1. Read about Programmatic advertising

Market Analyst Interview Questions & Answers

Xdbs user image Pratiksha Prabhat Singh

posted on 6 Sep 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - HR 

(4 Questions)

  • Q1. Brief me about yourself?
  • Q2. Excel shortcut keys?
  • Q3. What do you know about B2B business?
  • Ans. 

    B2B business refers to transactions between businesses, rather than between a business and individual consumers.

    • B2B stands for business-to-business.

    • It involves the sale of products or services from one business to another.

    • B2B transactions often involve larger quantities and higher value compared to B2C transactions.

    • Examples include manufacturers selling products to retailers, or a software company providing services to

  • Answered by AI
  • Q4. Who is founder of XDBS?
  • Ans. 

    XDBS was founded by Kartik Anand.

    • Founded by Kartik Anand

    • Established in 2001

    • Specializes in providing sales and marketing solutions

  • Answered by AI
Round 2 - Technical 

(6 Questions)

  • Q1. What is LinkedIn profile
  • Ans. 

    LinkedIn profile is a professional networking platform where individuals can showcase their work experience, skills, and connect with other professionals.

    • Online platform for professionals to network

    • Users can create a profile with their work experience, skills, and education

    • Opportunity to connect with other professionals in the same industry

    • Can be used for job searching and recruitment purposes

  • Answered by AI
  • Q2. What are the filters use on LinkedIn
  • Ans. 

    LinkedIn filters include location, industry, company size, job title, and more.

    • Location filter allows users to search for professionals in specific geographic areas.

    • Industry filter helps users find professionals working in specific sectors.

    • Company size filter allows users to target companies based on their number of employees.

    • Job title filter helps users find professionals with specific job titles.

    • Other filters include...

  • Answered by AI
  • Q3. Tell me about titles
  • Q4. Show me shortcuts keys of excel? (On laptop they check how you use to type shortcuts keys)
  • Q5. Company work domain?
  • Q6. Why do you choose this company?
Round 3 - HR 

(6 Questions)

  • Q1. B2B business detail?
  • Ans. 

    B2B business refers to transactions between businesses, rather than between a business and individual consumers.

    • B2B businesses sell products or services to other businesses.

    • These transactions often involve larger quantities and higher value compared to B2C transactions.

    • Examples include wholesale suppliers, software companies selling to enterprises, and marketing agencies working with corporate clients.

  • Answered by AI
  • Q2. What is Marketing Research?
  • Ans. 

    Marketing research is the process of gathering, analyzing, and interpreting information about a market, product, or service.

    • It involves collecting data on consumer preferences, market trends, and competitor activities.

    • The data is then analyzed to identify opportunities and challenges in the market.

    • Marketing research helps businesses make informed decisions and develop effective marketing strategies.

    • Examples of marketin...

  • Answered by AI
  • Q3. Are you aware about companies facility?
  • Q4. Redy to Relocate?
  • Q5. Okay with Rotation Shits?
  • Ans. 

    Yes, I am okay with rotation shifts as a Market Analyst.

    • I am flexible and adaptable to different work schedules.

    • I understand the importance of covering different time zones in a global market.

    • I have experience working in shifts in previous roles.

    • I prioritize work-life balance and have strategies to manage shift work effectively.

  • Answered by AI
  • Q6. 6 working hours and 1 time meals will be provided. Thats all was discuss for final round .

Interview Preparation Tips

Interview preparation tips for other job seekers - Search about company you are going to give interview. Basic details about company profile and it's work. Be confident ,they are coordinating with you and aslo every kind.
And aslo have patients because there are 1/2 people always sitting in between you who are HR Managers and they were observing you.
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jan 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Easy and simple quest during round one. Easy to crack

Round 3 - One-on-one 

(3 Questions)

  • Q1. Tell me abt yourself
  • Q2. Platforms knowledge and process related questions
  • Q3. Explain metrics used in Digital marketing's and main KPI
  • Ans. 

    Metrics used in digital marketing include CTR, CPC, CPA, and main KPI is ROI.

    • CTR (Click-Through Rate) measures the percentage of clicks on an ad compared to the number of impressions.

    • CPC (Cost Per Click) is the amount paid for each click on an ad.

    • CPA (Cost Per Acquisition) measures the cost of acquiring a customer through a specific campaign.

    • ROI (Return on Investment) is the main KPI, calculating the revenue generated

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Nil

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Little discussion on my project
  • Q2. Given a chessboard and the initial position of horse. If “n” is the number of steps the horse can make then what is probability that it goes out of board ?
  • Ans. 

    Probability of a horse going out of a chessboard in 'n' steps.

    • The total number of possible moves for a horse is 8.

    • The probability of going out of the board depends on the position of the horse.

    • For example, if the horse is at a corner, the probability of going out of the board is higher.

    • The probability can be calculated using combinatorics and geometry.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: They did not expect any code in this round. An algo or pseudo code is fine.



1) You are given 2 vessels with capacity M liters and N liters capacity and infinite supply of water. You need to find the minimum number of steps required to get P liters. Any of the below action is considered a step



     a) Filling vessel with water



     b) Emptying vessel



     c) Pouring water from one vessel to another vessel.



2) Given n sets each containing m integers. You need to create MinDiff set by picking exactly 1 element from each set. The difference between the maximum and minimum elements in the MinDiff set should be minimum.



eg: for the sets {30, 20, 10, 40},{ 22, 33, 44, 99},{ 16, 17, 18, 19} min diff set is {19, 20, 22}. Max and min elements in MinDiff set are 22 and 19 and their difference is 3.

Round: Technical Interview
Experience: 1) you will be given the binary representation of the numbers in the form of 2D array.eg: r1- 00001

r2- 00100

r3- 01010

r4- 00110

r5- 00111 This means the elements are 1, 4, 10 , 6 and 7.

A number “n” is given. Let us say that n can be formed by doing bitwise OR operation on rows of given matrix. What is the minimum number of rows that needs to be deleted from the matrix so that “n” can never be formed by doing the OR of the rows.

If n is 14(01110) then it can be formed by doing r2|r3 or r3|r4. You can prevent n formation either by deleting {r2,r4} or {r3}. But {r3} has least number of elements so it is the required set.2) Find the average of mid 50% of elements in the running stream of integersI have not cleared round-II so no further questions.

College Name: IIT GANDHINAGAR
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Basic questions about your previous experience
Round 3 - One-on-one 

(1 Question)

  • Q1. Excel and Data visualization questions. Depends on the role you are being hired for.

Interview Preparation Tips

Interview preparation tips for other job seekers - The staff is fun and comfortable. Interact without fear.

iSOCRATES Interview FAQs

How many rounds are there in iSOCRATES Senior BI Analyst interview?
iSOCRATES interview process usually has 2 rounds. The most common rounds in the iSOCRATES interview process are Technical and HR.
How to prepare for iSOCRATES Senior BI Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at iSOCRATES. The most common topics and skills that interviewers at iSOCRATES expect are SQL, Excel, Agile, Analytics and Business Intelligence.

Tell us how to improve this page.

iSOCRATES Senior BI Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

JustDial Interview Questions
3.5
 • 329 Interviews
R.R. Donnelley Interview Questions
3.9
 • 99 Interviews
3 Minds Digital Interview Questions
4.4
 • 64 Interviews
Publicis Interview Questions
3.7
 • 54 Interviews
Regalix Interview Questions
2.9
 • 44 Interviews
Xdbs Interview Questions
3.2
 • 39 Interviews
Denave Interview Questions
3.6
 • 39 Interviews
InMobi Interview Questions
3.5
 • 35 Interviews
View all
iSOCRATES Senior BI Analyst Salary
based on 4 salaries
₹11 L/yr - ₹17 L/yr
6% less than the average Senior BI Analyst Salary in India
View more details

iSOCRATES Senior BI Analyst Reviews and Ratings

based on 2 reviews

2.5/5

Rating in categories

1.0

Skill development

2.5

Work-life balance

3.5

Salary

1.0

Job security

1.7

Company culture

1.7

Promotions

2.5

Work satisfaction

Explore 2 Reviews and Ratings
Senior BI Analyst

Mysuru / Mysore

4-7 Yrs

Not Disclosed

Explore more jobs
Analyst
14 salaries
unlock blur

₹3 L/yr - ₹4.5 L/yr

Campaign Manager
8 salaries
unlock blur

₹7 L/yr - ₹9.2 L/yr

Business Intelligence Analyst
7 salaries
unlock blur

₹3.5 L/yr - ₹9.4 L/yr

Programmatic Campaign Manager
6 salaries
unlock blur

₹7.5 L/yr - ₹10 L/yr

Senior Campaign Manager
6 salaries
unlock blur

₹7.2 L/yr - ₹11 L/yr

Explore more salaries
Compare iSOCRATES with

Affle

3.1
Compare

InMobi

3.5
Compare

Komli Media

4.0
Compare

PubMatic

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview