30+ MIS Analyst Interview Questions and Answers

Swiggy is an Indian food delivery company that operates through a website and mobile app.

• Swiggy was founded in 2014 and is headquartered in Bangalore, India.

• It partners with local restaurants to provide food delivery services to customers.

• Swiggy's business model is based on charging a commission fee from the restaurants for every order placed through their platform.

• It has expanded to over 500 cities in India and has over 200,000 restaurant partners.

• SQL queries are used to ret...read more

Query to find students with over 80 marks in English subject

• Use SELECT statement to retrieve data

• Filter the results using WHERE clause for marks greater than 80

• Include condition for English subject using AND operator

To start VBA code, create a new module and define a sub procedure.

• Open Microsoft Excel and press ALT + F11 to open the Visual Basic Editor

• In the Project Explorer, right-click on the workbook and select Insert > Module

• Define a sub procedure by typing 'Sub' followed by the name of the procedure

• Add the code inside the sub procedure

• Save the module and close the Visual Basic Editor

I know VBA and Python both.

• I have experience in writing VBA macros for automating tasks in Excel.

• I have also worked on Python scripts for data analysis and visualization.

• I am familiar with libraries like Pandas, NumPy, and Matplotlib in Python.

• I have used VBA to create user forms and automate data entry processes.

• I have written Python scripts for web scraping and data extraction.

Option Explicit is a statement used in VBA to force variable declaration while Option Base is used to set the lower bound of an array.

• Option Explicit is used to avoid undeclared variables in VBA code

• Option Base is used to set the lower bound of an array in VBA

• Option Explicit is recommended to be used in all VBA code

• Option Base is optional and defaults to 0 if not specified

• Example: Option Explicit Dim x As Integer x = 5 Example: Option Base 1 Dim arr(1 To 10) As Integer

Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.

• Rank function is used to determine the rank of a value in a list.

• It can be used to rank values in ascending or descending order.

• The syntax for the rank function is RANK(value, range, [is_ascending]).

Use a SQL query with JOIN to retrieve employees between specified dates.

• Use the JOIN keyword to combine data from two tables

• Specify the date range using the WHERE clause

• Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'

HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.

• HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.

• It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

• It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000...read more

The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• FROM: Specifies the tables from which data will be retrieved.

• WHERE: Filters the rows based on specified conditions.

• GROUP BY: Groups the rows based on specified columns.

• HAVING: Filters the groups based on specified conditions.

• SELECT: Retrieves the columns specified in the query.

• ORDER BY: Sorts the result set based on specified columns.

A pivot table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.

• Allows users to reorganize and summarize selected columns and rows of data

• Can perform calculations, such as sums, averages, counts, etc., on the summarized data

• Provides a dynamic way to view and analyze data from different perspectives

• Commonly used in Excel, Google Sheets, and other spreadsheet programs

An inventory management system is a software tool that helps businesses track and manage their inventory levels, orders, sales, and deliveries.

• Automates inventory tracking and management processes

• Provides real-time visibility into inventory levels

• Helps optimize inventory levels to prevent stockouts or overstocking

• Facilitates order management and fulfillment

• May include features like barcode scanning, serial number tracking, and reporting

• Examples: SAP Inventory Management, Orac...read more

Index and Match are functions in Excel used to lookup values in a table based on specific criteria.

• Index function returns the value of a cell in a table based on the row and column number provided.

• Match function returns the position of a value in a range.

• Index and Match functions are often used together to perform more flexible lookups than VLOOKUP or HLOOKUP.

• Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will return the value in the 3rd column of the row where 123 is foun...read more

Vlookup and Hlookup are functions in Excel used to search for a value in a table and return a corresponding value.

• Vlookup stands for vertical lookup and is used to search for a value in the first column of a table and return a value in the same row from a specified column.

• Hlookup stands for horizontal lookup and is used to search for a value in the first row of a table and return a value in the same column from a specified row.

• Both functions are commonly used in Excel for dat...read more

Conditional formatting is used in spreadsheets and databases to highlight data based on specified conditions.

• In Excel, conditional formatting can be used to highlight cells that meet certain criteria, such as values above or below a certain threshold.

• In databases, conditional formatting can be used to visually distinguish data that meets specific conditions, such as overdue tasks or high-priority items.

• Conditional formatting can help users quickly identify important informati...read more

HLOOKUP is a function in Excel used to search for a value in the top row of a table or an array, while a pivot table is a data summarization tool.

• HLOOKUP function searches for a value in the top row of a table or an array and returns a value in the same column from a specified row.

• Pivot tables are used to summarize, analyze, explore, and present data in a spreadsheet.

• HLOOKUP example: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• Pivot table example: Select...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.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• Use the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value is the value to search for in the first column of the table

• table_array is the range of cells that contains the data

• col_index_num is the column number in the table from which to retrieve the data

• range_lookup is optional and can be TRUE (approximate match) or FALSE (exact match)

Hookup is not a function in Excel, Vlookup searches for a value in the first column of a table and returns a value in the same row, Xlookup is an improved version of Vlookup.

• Hookup is not a function in Excel, it may refer to casual dating or connections outside of Excel.

• Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column.

• Xlookup is an improved version of Vlookup that allows for searching in any direction and ...read more

The total number of cities cannot be counted without specific data or context.

• The total number of cities can vary depending on the country, region, or dataset being considered.

• One would need a list of cities or a specific area of focus to accurately count the total number of cities.

• For example, the total number of cities in the United States is different from the total number of cities in India.

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.

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

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Use DELETE in SQL to remove records from a table.

• Use DELETE when you want to remove specific records from a table.

• Make sure to use a WHERE clause to specify which records to delete.

• Always be cautious when using DELETE as it permanently removes data.

• Example: DELETE FROM employees WHERE department = 'HR';

Pivot tables are a data summarization tool in spreadsheet software that allows you to reorganize and summarize selected columns and rows of data.

• Pivot tables are used to analyze, summarize, and present large amounts of data in a more manageable format.

• They allow users to group and summarize data based on specific criteria, such as categories or values.

• Users can easily rearrange and customize the layout of the data to suit their analysis needs.

• Pivot tables can perform calculat...read more

Handling situations requires clear communication, problem-solving skills, and the ability to remain calm under pressure.

• Assess the situation and gather information

• Identify potential solutions and weigh the pros and cons

• Communicate effectively with all parties involved

• Remain calm and focused

• Take action and monitor the situation for any changes

FMS stands for Facility Management System, which is a software solution used to manage and optimize the maintenance and operations of facilities.

• FMS helps in tracking and managing assets, equipment, and resources within a facility.

• It can schedule preventive maintenance tasks to ensure equipment is functioning properly.

• FMS can also track work orders, manage inventory, and provide reporting and analytics on facility operations.

• Some examples of FMS software include IBM TRIRIGA, ...read more

Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.

• Business analytics tool by Microsoft

• Used for visualizing and analyzing data

• Allows users to create interactive reports and dashboards

• Integrates with various data sources such as Excel, SQL databases, and cloud services

Media handling and storage condition is crucial for data integrity and longevity.

• Media should be handled with care to avoid physical damage.

• Storage conditions should be controlled for temperature, humidity, and light exposure.

• Regular backups should be taken to prevent data loss.

• Labeling and organization should be maintained for easy retrieval.

• Examples of storage media include hard drives, tapes, and optical discs.

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

• Types of SQL 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 right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL JOIN returns rows when there is a match in one of ...read more

Lookups are used to retrieve data from a table based on a specified criteria.

• Lookups are commonly used in databases to search for specific information.

• They can be used to retrieve values from a table based on a key or index.

• Lookups are essential in data analysis and reporting to fetch relevant data.

• Examples include VLOOKUP in Excel, INDEX MATCH functions, and SQL SELECT queries.

Index match formula is a powerful Excel function used to lookup values in a table.

• Index match is used to find a value in a table based on row and column criteria.

• It is more flexible and efficient than VLOOKUP function.

• Syntax: =INDEX(array, MATCH(lookup_value, lookup_array, 0))

SUMIF function adds up values based on a given condition in Excel.

• Used in Excel to sum values that meet a specific criteria

• Syntax: =SUMIF(range, criteria, [sum_range])

• Example: =SUMIF(A1:A10, ">10", B1:B10) will sum values in B1:B10 where corresponding value in A1:A10 is greater than 10

The question is asking about where I currently live.

• I currently live in New York City.

• I have been living in this city for the past 5 years.

• I live in a small apartment in Manhattan.