Physicswallah MIS Business Analyst Interview Questions and Answers

Row level security is a feature that restricts access to specific rows in a database based on the user's permissions.

• Row level security limits access to certain rows of data based on the user's role or permissions.

• It helps organizations ensure that sensitive data is only accessible to authorized users.

• For example, a healthcare organization may use row level security to restrict access to patient medical records based o...read more

I will share Power BI reports through email, shared folders, and scheduled data refreshes.

• Share reports via email with stakeholders

• Store reports in shared folders for easy access

• Schedule data refreshes to ensure reports are up-to-date

Calculated columns are calculated at the row level, while calculated measures are aggregated over a set of rows.

• Calculated columns are created at the individual row level in a table, using DAX formulas in Power BI or Excel.

• Calculated measures are created at the aggregate level, such as sum or average, and are used in measures like totals or averages in a pivot table.

• Calculated columns are stored in the data model, whil...read more

Files in Python can be read using the open() function to open the file and read() function to read the contents.

• Use the open() function to open a file in read mode: file = open('filename.txt', 'r')

• Use the read() function to read the contents of the file: content = file.read()

• Close the file after reading: file.close()

Standard deviation is a measure of the amount of variation or dispersion of a set of values.

• Standard deviation is calculated as the square root of the variance.

• It indicates how spread out the values in a data set are around the mean.

• A higher standard deviation means more variability in the data.

• A lower standard deviation means values are closer to the mean.

• For example, in a data set of test scores, a high standard devi...read more

Excel is a powerful spreadsheet software used for data analysis, reporting, and visualization.

• Excel allows users to organize data in rows and columns, perform calculations, and create charts and graphs.

• Features like pivot tables, conditional formatting, and data validation make it easier to analyze and present data.

• Excel also supports automation through macros and functions like VLOOKUP and SUMIF.

• It is widely used in b...read more

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

• Window functions are used to perform calculations on a specific subset of rows related to the current row.

• They allow you to perform calculations without grouping the rows into a single output row.

• Examples of window functions include ROW_NUMBER(), RANK(), and NTILE().

CTE query stands for Common Table Expression query, used in SQL to create temporary result sets.

• CTE query is used to simplify complex SQL queries by breaking them into smaller, more manageable parts.

• It allows for recursive queries, which can be useful for tasks like hierarchical data retrieval.

• CTE queries are defined using the WITH keyword followed by the query name and definition.

• They can be referenced multiple times ...read more

Left Join will have 12 columns, Inner Join will have 7 columns, Union will have 7 columns.

• Left Join combines all columns from both tables, resulting in 12 columns.

• Inner Join only includes columns that are common between the tables, resulting in 7 columns.

• Union combines the results of two or more SELECT statements, keeping the same number of columns as the original tables (7 columns).