Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

NSE.IT

Compare button icon Compare button icon Compare
3.6

based on 1.2k Reviews

Play video Play video Video summary

Filter interviews by

NSE.IT BI Analyst Interview Questions and Answers

Updated 22 Apr 2023

NSE.IT BI Analyst Interview Experiences

1 interview found

BI Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Apr 2023

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

I applied via Naukri.com and was interviewed before Apr 2022. There were 2 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 - Technical 

(3 Questions)

  • Q1. How would you shows any aggregation on whole data row by row in SQL. Example if I want total sales as a new column in existing table as a result.
  • Ans. 

    To show aggregation on whole data row by row in SQL, you can use the OVER() function with appropriate window specification.

    • Use the OVER() function to perform aggregation on the entire data set

    • Specify the window specification to define the scope of aggregation

    • Add the aggregated result as a new column in the existing table

    • Example: SELECT *, SUM(sales) OVER() AS total_sales FROM table_name

    • Answered by AI
    View 1 more answer
  • Q2. Difference between functions and store procedures?
  • Ans. 

    Functions return a single value while stored procedures execute a set of SQL statements.

    • Functions are used to perform calculations and return a single value while stored procedures are used to execute a set of SQL statements.

    • Functions can be used in SELECT, WHERE, and HAVING clauses while stored procedures cannot.

    • Functions can be called from within stored procedures while stored procedures cannot be called from within ...

    • Answered by AI
    Add your answer
  • Q3. What does All function does in dax?
  • Ans. 

    ALL function in DAX returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied.

    • ALL function can be used to remove filters from a table or column.

    • It can also be used to remove filters from a specific column in a table.

    • ALL function can be combined with other functions like CALCULATE to perform complex calculations.

    • Example: CALCULATE(SUM(Sales[Amount]), ALL(Sales[Prod...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Topics to prepare for NSE.IT BI Analyst interview:
  • Windows function SQL
  • Dax
  • Joins in sql
Interview preparation tips for other job seekers - Overall interview in NSEIT was good, and of course interview questions depends on interviewer to interviewer, but make sure you go through basics to advance interview questions before appearing for technical interview in NSEIT.

Skills evaluated in this interview

Top trending discussions

View All
Career Growth
2w
dreamyjaadu
Verified Icon
·
works at
Wipro
Career suggestion
I have 7 YOE. from Delhi Current CTC - 9.25LPA + 75K varriable. Working Skillset is Kubernetes and Openstack. Current - 100% WFH 1. NTT Data- Noida Hybrid CTC -18 LPA + 2.5L variable. what is current value in market for Kubernetes skillset? How can I negotiate to get better offer?
Got a question about NSE.IT?
Ask anonymously on communities.

Interview questions from similar companies

Associate Interview Questions & Answers

Infosys user image Anonymous

posted on 2 Oct 2017

I appeared for an interview before Oct 2016.

Interview Questionnaire 

1 Question

  • Q1. 1. Self introduce. 2. Can do night shift 3. Can go Jaipur if needed 4. Why appoint you 5. What you give to company 6. Some financial question (bookish)
    • Add your answer

Interview Preparation Tips

Round: HR Interview
Experience: After hr round, then aptitude test which was simple to crack, then operations manager interview, then they keep me waiting till 9 pm to declare That I am selected.
Tips: Go for 11 & 12 class financial management or finance book
Go through about share, debenture, mutual fund, banking system etc.

Round: Test
Experience: Aptitude is easy to crack and at last you have to write essay.
Duration: 1 hour
Total Questions: 60

Associate Interview Questions & Answers

Wipro user image Anonymous

posted on 12 May 2018

Interview Questionnaire 

1 Question

  • Q1. They will ask about basic Google and YouTube process
    • Add your answer

Interview Preparation Tips

Round: Group Discussion
Experience: We have to be good in communication skill .as well as they expect us to be more confidential behaviour

Round: Telephonic client round
Experience: They will ask you behavioural questions simply like spell it name , and process based some questions

Associate Interview Questions & Answers

Wipro user image Anonymous

posted on 22 Nov 2017

I appeared for an interview before Nov 2016.

Interview Questionnaire 

2 Questions

  • Q1. Simple question name and all
    • Add your answer
  • Q2. Why u want to join wipro
  • Ans. 

    I want to join Wipro because of its reputation for innovation and career growth opportunities.

    • Wipro is known for its cutting-edge technology solutions

    • I am impressed by Wipro's commitment to employee development

    • I believe Wipro will provide me with a challenging and rewarding work environment

    • Answered by AI
    Add your answer

Interview Preparation Tips

Round: HR Interview
Experience: I got selected. And called to the office. For documentation. And then after a day I received one more call from higher authority for another interview. But it was a telephonic one. Next day I received call to come and collect offer letter
Tips: Be confident. Try to be normal. Do not show off much. English communication should be good.

Associate Interview Questions & Answers

Tech Mahindra user image Anonymous

posted on 30 Jul 2020

I applied via Walk-in and was interviewed before Jul 2019. There was 1 interview round.

Interview Questionnaire 

8 Questions

  • Q1. My self
    • View 20 more answers
  • Q2. What is your qualification
    • View 8 more answers
  • Q3. Are you fresher or experience
    • View 6 more answers
  • Q4. If you are experienced
    • Add your answer
  • Q5. So tell me about your experience on which profile
    • Add your answer
  • Q6. Why old job left
    • Add your answer
  • Q7. What is the reason came on this company
    • Add your answer
  • Q8. Are you satisfied 24*7 shift
    • View 1 more answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Its so simple, when you go for the interview so please refresh your mind and be confidently go for the interview. Please go through the job description throughly word by word and recheck your resume to ensure that you are a best fit for the position.

Business Analyst Interview Questions & Answers

Infosys user image Anonymous

posted on 16 Feb 2021

I applied via Naukri.com and was interviewed before Feb 2020. There were 7 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 2+2÷2
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was a technical one but was majorly a stress test. It lasted for about 1 hour 10 minutes. The interviewer wanted to test both my knowledge and communication skills. Most of the questions asked to me were related to my B.Tech curriculum i.e. computer science related topics. He stressed a lot on the basics related to my project topic. Luckily I was able to answer most of the questions correctly. I tried to answer each question with examples and also used props on the table (like pens, paperweights, pen stands etc.) to explain my theories. It was my first offcampus interview, and I think I did pretty well for a fresher. You need to stay calm and should apply presence of mind. Please go through the job description thoroughly word-by-word and recheck your resume to ensure that you are a best-fit for the position.

Associate Interview Questions & Answers

Wipro user image Anonymous

posted on 22 Oct 2021

I applied via Recruitment Consultant and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Communication and interpersonal and Team handle qualities
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be frank and say loudly what u r going to say be positive

Business Analyst Interview Questions & Answers

Infosys user image Anonymous

posted on 13 Oct 2021

I applied via Company Website and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. General known about finance and basic skill about reports
    • Add your answer
  • Q2. Balance sheet Impact
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Bold and confident answer

Business Analyst Interview Questions & Answers

Infosys user image Anonymous

posted on 25 Nov 2021

I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. More about business structure
    • Add your answer
  • Q2. Yes complete business flow
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - To be clear on business solutions

Associate Interview Questions & Answers

Tech Mahindra user image Anonymous

posted on 24 Mar 2021

I applied via Naukri.com and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Talk about any topic for atleast 3mins
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with any topic and talk confidently with out stoping.
More about working at NSE.IT

NSE.IT Interview FAQs

How many rounds are there in NSE.IT BI Analyst interview?
NSE.IT interview process usually has 2 rounds. The most common rounds in the NSE.IT interview process are Resume Shortlist and Technical.
What are the top questions asked in NSE.IT BI Analyst interview?

Some of the top questions asked at the NSE.IT BI Analyst interview -

  1. How would you shows any aggregation on whole data row by row in SQL. Example if...read more
  2. What does All function does in d...read more
  3. Difference between functions and store procedur...read more

Tell us how to improve this page.

NSE.IT Interviews By Designations

Interview Questions for Popular Designations

NSE.IT BI Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 796 Interviews
Hexaware Technologies Interview Questions
3.5
 • 712 Interviews
Cyient Interview Questions
3.6
 • 288 Interviews
Newgen Software Technologies Interview Questions
3.7
 • 183 Interviews
View all

Fast track your campus placements

Mumbai University Placement Questions
1 Interview
Atharva College of Engineering, Mumbai Placement Questions
1 Interview
JIS College of Engineering, Kolkata Placement Questions
1 Interview
Vivekanand Education Society's Institute of Technology, Mumbai Placement Questions
1 Interview
View all

NSE.IT BI Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
NSE.IT Salaries in India
Associate System Analyst
831 salaries
unlock blur

₹3 L/yr - ₹13.7 L/yr

IT Supervisor
224 salaries
unlock blur

₹1.2 L/yr - ₹3.6 L/yr

System Analyst
192 salaries
unlock blur

₹5 L/yr - ₹17.5 L/yr

Associate Test Analyst
186 salaries
unlock blur

₹2.5 L/yr - ₹10 L/yr

Associate
164 salaries
unlock blur

₹1 L/yr - ₹7.8 L/yr

Explore more salaries
Compare NSE.IT with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview