Amgen Business Analyst Interview Questions and Answers for Experienced

The CALCULATE function in DAX is used to apply filters to a calculation in a formula.

• CALCULATE function modifies the filter context for a calculation in DAX.

• It can be used to override existing filters or apply new filters.

• Example: CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'North')

Data structures are ways of organizing and storing data in a computer so that it can be accessed and used efficiently.

• Data structures define the way data is stored, accessed, and manipulated in a computer program.

• Examples of data structures include arrays, linked lists, stacks, queues, trees, and graphs.

• Choosing the right data structure is crucial for optimizing the performance of a program.

I managed a high CGPA through consistent hard work, effective time management, seeking help when needed, and staying organized.

• Consistent hard work by studying regularly and staying focused on academics

• Effective time management to balance studies, assignments, and extracurricular activities

• Seeking help from professors, tutors, or classmates when facing challenges

• Staying organized with study schedules, notes, and deadli