Sarvagram Fincare Data Analyst Interview Questions, Process, and Tips

Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

• Window functions are used to perform calculations on a set of rows related to the current row in a query result.

• The LAG function is a window function that allows you to access data from a previous row in the result set.

• Example: SELECT employee_id, salary, LAG(salary) OVER (ORDER BY hire_date) AS prev_salary FR

Nested for loop used to iterate through a list of items

• Use a for loop to iterate through the main list

• Inside the first loop, use another for loop to iterate through each item in the sublist

• Example: for item in main_list: for sub_item in item: print(sub_item)

A database is a collection of structured data organized for easy access, while a data warehouse is a centralized repository for storing and analyzing large volumes of data.

• Database is used for transactional processing and storing current data.

• Data warehouse is used for analytical processing and storing historical data.

• Database is typically used for day-to-day operations.

• Data warehouse is used for decision-making and bu...read more

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the righ...read more

DAX (Data Analysis Expressions) is a formula language used in Power BI to create custom calculations and aggregations.

• DAX is similar to Excel formulas but designed for more complex data analysis tasks

• It can be used to create calculated columns, measures, and calculated tables in Power BI

• DAX functions include aggregation functions like SUM, AVERAGE, and COUNT, as well as logical functions and date functions

• Example: CALC...read more