Satin Creditcare Network MIS Officer Interview Questions and Answers

1 hour coding test on intermediate python programming

Q1. Naaaghuuiii hgdtyhb uii7yfghh uyddbkiydd
Add your answer
Q2. NAahjuutyijhg guihhftu dfyikhh fujgx
Add your answer

Apptitude test conducted where there are 60 question in 60 min

Python, Verbal , Apptitude

Last one is interview round

Q1. Data frame making in python
Ans. 
Data frame making in Python involves creating a structured table-like data structure using the pandas library.
• Use the pandas library to create a data frame

• Data frames are 2-dimensional labeled data structures with columns of potentially different types

• Data frames can be created from dictionaries, lists, numpy arrays, or other data frames

• Example: df = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})
Answered by AI
Add your answer
Q2. Random forest basic questions
Add your answer

Q1. It was more related to my projects
Add your answer
Q2. Asked questions on PCA,KNN and Elbow method .
Add your answer

Q1. Asked SVM and Logistic regression, their applications and real life uses
Add your answer
Q2. Matrix formation of a knockout Tournament
Add your answer

Q1. Tell me about the types of join sql.
Ans. 
Types of join SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a 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 outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer
Q2. Tell about the dax function
Ans. 
DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.
• DAX functions are used to create calculated columns, measures, and calculated tables in Power BI and Excel.

• DAX functions include mathematical, logical, statistical, and text functions.

• Examples of DAX functions are SUM, AVERAGE, IF, RELATED, CALCULATE, etc.
Answered by AI
Add your answer

Q1. Introduction about ur self
Ans. 
I am a dedicated and detail-oriented MIS Officer with a strong background in data analysis and information management.
• Experienced in analyzing and interpreting complex data sets

• Proficient in database management and reporting tools

• Skilled in developing and implementing data quality processes

• Strong communication and problem-solving skills

• Certified in relevant software applications such as SQL and Excel
Answered by AI
Add your answer

Q1. Excel test with advanced skills
Add your answer

Q1. Introduction about self, previous company and etc.
Add your answer

Q1. Excel and Sql basic and advanced problems
Add your answer
Q2. How to use Vlookup ?
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Enter the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) in a cell

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

• table_array is the range of cells that contains the data

• col_index_num is the column number in the table_array from which to retr...read more
Answered by AI
Add your answer
Q3. How to use Splitting?
Ans. 
Splitting is a technique used to divide a string into multiple parts based on a specified delimiter.
• Use the split() method in programming languages like Python, JavaScript, or Java to split a string into an array of substrings.

• Specify the delimiter (e.g. space, comma, hyphen) as an argument to the split() method.

• Access the individual parts of the split string using array indexing.

• Combine splitting with other string man...read more
Answered by AI
Add your answer
Q4. How to use pivot ?
Ans. 
Pivot is a function used in data analysis to summarize and reorganize data.
• Pivot can be used to reorganize rows into columns or columns into rows based on a specific variable.

• It is commonly used in Excel or other spreadsheet software to create summary tables or reports.

• Pivot tables can help analyze large datasets and identify trends or patterns.

• Example: In Excel, you can use the PivotTable feature to summarize sales da
Answered by AI
Add your answer
Q5. How to use concatenation?
Ans. 
Concatenation is the process of combining two or more strings together.
• Use the + operator to concatenate strings in most programming languages.

• In SQL, use the CONCAT function to concatenate strings.

• Concatenation can also be done using string interpolation in some languages.
Answered by AI
Add your answer