Upload Button Icon Add office photos

NSE.IT

Compare button icon Compare button icon Compare

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
  • 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
  • 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

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

Interview questions from similar companies

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)

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

Interview Questionnaire 

1 Question

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

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

I appeared for an interview before Nov 2016.

Interview Questionnaire 

2 Questions

  • Q1. Simple question name and all
  • 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

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.

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

Interview Questionnaire 

8 Questions

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

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.

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

Interview Questionnaire 

1 Question

  • Q1. 2+2÷2

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.

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

Interview Preparation Tips

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

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
  • Q2. Balance sheet Impact

Interview Preparation Tips

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

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
  • Q2. Yes complete business flow

Interview Preparation Tips

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

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with any topic and talk confidently with out stoping.

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 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
Cyient Interview Questions
3.6
 • 288 Interviews
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
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
Did you find this page helpful?
Yes No
write
Share an Interview