London Stock Exchange Group Senior Business Analyst Interview Questions and Answers

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

The orbit of a planet is an ellipse with the sun at one of the foci.

• An ellipse is a closed curve with two foci.

• The sun is located at one of the foci of a planet's elliptical orbit.

• The shape of the orbit affects the planet's distance from the sun over time.

• Kepler's laws of planetary motion describe the elliptical nature of orbits.

Window functions like lag and lead are used to analyze data over a specific range or window.

• Lag function can be used to calculate the difference between current and previous values in a time series data.

• Lead function can be used to calculate the difference between current and future values in a time series data.

• Window functions can be used to calculate moving averages, cumulative sums, and other statistical measures.

• Fo...read more