Meratransport.com Interview Questions and Answers

Q1. Micro service, angular http methods, transaction management actuator pod recycling, routers, two way binding, life cycle hooks
Add your answer

Knowledge of excel and advance excel

Q1. General questions
Add your answer
Q2. What is your current salary
Add your answer
Q3. What is your expected ctc
Ans. 
My expected CTC is based on my experience, skills, and the market rate for data analysts.
• My expected CTC is in line with industry standards for data analysts.

• I have taken into consideration my years of experience and expertise in data analysis.

• I am open to negotiation based on the overall compensation package offered by the company.
Answered by AI
Add your answer

Q1. First was Hr round, where he asked about myself, my experience, salary expectations, current salary.
Add your answer

Q1. Then the second round was with Arun Sir, who has asked advanced excel formulas, advanced google sheets formulas, SQL basics. And later told that will let you know, but haven't updated yet.
Add your answer
Q2. Dcount function ABS function Excel remove minus sign from integer using a formula.
Ans. 
Dcount function counts the number of unique values in a dataset. ABS function returns the absolute value of a number. To remove minus sign from an integer in Excel, use a formula like =ABS(A1).
• Dcount function counts unique values in a dataset

• ABS function returns absolute value of a number

• To remove minus sign from an integer in Excel, use formula like =ABS(A1)
Answered by AI
Add your answer
Q3. Filters Transfer data from 1 sheet to other Join , inner, outer, self, left right Along with the syntax Colene function in SQL Show top value show values between a date range Sumifs countifs
Ans. 
Answering questions related to data filtering, transferring, joining, and SQL functions for a Data Analyst role.
• To transfer data from one sheet to another, you can use functions like VLOOKUP or INDEX/MATCH in Excel.

• Different types of joins in SQL include INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, and SELF JOIN.

• Syntax for INNER JOIN: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Synta...read more
Answered by AI
Add your answer

Q1. All about excel and about your previous work experience
Add your answer

All about analytical and excel

Q1. Just salary discussion
Add your answer

Q1. Q1/- How to extract data from database
Ans. 
To extract data from a database, one can use SQL queries or programming languages like Python or R.
• Use SQL queries to extract data from a database

• Use programming languages like Python or R to extract data from a database

• Connect to the database using appropriate credentials

• Identify the tables and columns from which data needs to be extracted

• Write the query or code to extract the data

• Save the extracted data in a desired
Answered by AI
Add your answer
Q2. Q2/- What are the Tableau Datatypes
Ans. 
Tableau has 14 datatypes including string, integer, float, date, boolean, and more.
• Tableau has 14 datatypes

• String, Integer, Float, Date, Boolean, and more

• Data types can be changed in Tableau

• Data types affect how data is displayed and aggregated

• Examples: String - 'John Smith', Integer - 25, Float - 3.14, Date - 01/01/2021, Boolean - True/False
Answered by AI
Add your answer

Q1. Q1/- Related company example along with Excel
Add your answer
Q2. Q2.- Vlookup() copy record from one sheet to another sheet
Ans. 
Vlookup() is a function in Excel that can be used to copy records from one sheet to another based on a common identifier.
• The Vlookup() function searches for a value in the first column of a table array and returns a corresponding value in the same row from a specified column.

• The common identifier used in the Vlookup() function should be present in both the source and destination sheets.

• The Vlookup() function can be use...read more
Answered by AI
Add your answer

Dsa round was conducted

Q1. Anything related to past exp
Add your answer

Q1. Asked related to introduction and about previous company profile
Add your answer

Q1. Related to advanced excel
Add your answer

Q1. System design, binary search related questions
Add your answer

Q1. Basic Linked list, recursion question.
Add your answer