Northern Trust Operating Services Associate Consultant Interview Questions and Answers

Markets offer dynamic and challenging environments that require constant adaptation and innovation.

• Markets provide opportunities for growth and expansion

• Competition in markets drives innovation and efficiency

• Markets offer diverse career paths and opportunities for personal development

A bond is a debt security that represents a loan made by an investor to a borrower.

• Bonds are issued by corporations, municipalities, and governments to raise capital.

• They have a fixed interest rate and a maturity date when the principal is repaid.

• Bonds are generally considered less risky than stocks but offer lower potential returns.

• Investors can buy and sell bonds on the secondary market.

• Examples of bonds include U.S....read more

Fund Accounting is a specialized accounting system used by non-profit organizations and government agencies to track and manage funds.

• It involves tracking and reporting on the financial activity of specific funds or grants.

• It ensures that funds are used for their intended purposes and that financial reports are accurate and transparent.

• Examples include tracking donations to a non-profit organization or managing governm...read more

LOD stands for Level of Detail. It is a technique in Tableau that allows users to compute values at a different level than the view.

• LOD expressions can be used to aggregate data at a higher level than the view, or to compute values at a lower level than the view.

• There are three types of LOD expressions: FIXED, INCLUDE, and EXCLUDE.

• FIXED LOD expressions compute values using a specified set of dimensions, regardless of t...read more

Hyper is a data engine used by Tableau to process large amounts of data quickly.

• Hyper is an in-memory data engine that can process billions of rows of data.

• It allows for faster data analysis and visualization.

• Hyper can handle complex queries and calculations.

• Tableau uses Hyper as its default data engine since version 10.5.

• Hyper can also be used as a standalone database.

• Hyper supports various data sources including CSV,

Parameters in Tableau are dynamic inputs that allow users to change values in a visualization.

• Parameters can be used to filter data, change calculations, and control the appearance of a visualization.

• They can be created by right-clicking on a field or by using the 'Create Parameter' option in the 'Analysis' menu.

• Examples of parameters include allowing users to select a date range, adjusting the size of a chart, or chan...read more