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

Interview Questionnaire 

1 Question

  • Q1. How to use visio
  • Ans. 

    Visio is a diagramming tool used to create flowcharts, diagrams, and other visual representations of data.

    • Start by selecting a template or creating a new document

    • Drag and drop shapes onto the canvas and connect them with lines or arrows

    • Add text, images, and other elements to enhance the diagram

    • Use the formatting tools to customize the appearance of the diagram

    • Save and export the diagram in various formats such as PDF o

  • Answered by AI

I applied via Campus Placement and was interviewed before Oct 2021. 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 

(2 Questions)

  • Q1. What are derivatives?
  • Ans. 

    Derivatives are financial contracts that derive their value from an underlying asset or security.

    • Derivatives can be used for hedging or speculation.

    • Examples include futures, options, swaps, and forwards.

    • Derivatives can be traded on exchanges or over-the-counter.

    • Derivatives can be complex and carry significant risk.

    • Derivatives played a role in the 2008 financial crisis.

  • Answered by AI
  • Q2. Different types of derivatives
  • Ans. 

    Derivatives are financial instruments whose value is derived from an underlying asset or security.

    • Futures contracts

    • Options contracts

    • Swaps

    • Forwards contracts

    • Credit derivatives

    • Interest rate derivatives

    • Currency derivatives

    • Commodity derivatives

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prep for basic questions related to finance and marketing.

Interview Questionnaire 

1 Question

  • Q1. Java c c++

I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Tell me something about yourself
  • Q2. Whats special you can orovide to this company
  • Q3. What are your long term plans ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident...dont bluff...reman calm

I applied via Campus Placement and was interviewed in Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Just go there

Interview Questionnaire 

1 Question

  • Q1. How ar you

Interview Preparation Tips

Interview preparation tips for other job seekers - good

I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Logical Reasoning Puzzle

Interview Preparation Tips

Interview preparation tips for other job seekers - Smile in between and be confident. No matter what you will be alive after the interview. People are ready to pay billions but can't afford a second more when it is all over.

I applied via Company Website and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic details, About TCS, regarding work ex, and personality trails.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep all that is mentioned in your resume, share all relevant information, be honest and informative about everything.

Interview Questionnaire 

1 Question

  • Q1. Tell about your weaknesses

Interview Preparation Tips

Interview preparation tips for other job seekers - Share your weaknesses as positively. Eg: I'm trust everyone so it's my weakness. Tell it in positive way.
From beginning to end eye contact is an important factor.
Be confident and genuine.

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