Freelancer.com Data Analyst and Senior MIS Executive Interview Questions and Answers

Q1. I am interested for jobs Data Entry operator
Add your answer
Q2. How is possible google for my jobs I am very happy Thanksgiving
Add your answer
Q3. I needed for this job
Add your answer

Q1. 8 years Experience working from Data Entry operator
Add your answer
Q2. BNMU Madhepura District
Add your answer

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is 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.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. Big data , Optimization , Python basic , SQL intermediate
Add your answer
Q2. Find max and min number without sorting Joins related Big data handling Optimization question
Add your answer

Q1. Schema , python , sql
Add your answer
Q2. Case study sql and python based
Add your answer

Sales data from a leading manufacturer

Q1. Case studies, puzzle , Sql, guesstimate, projects
Add your answer

Q1. Puzzles, probability, work experience
Add your answer

Q1. Python, pyspark
Add your answer

Q1. Behavioral round
Add your answer

Q1. Can you tell me about yourself?
Add your answer
Q2. Can you provide details about your city?
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. What is your previous work experience?
Add your answer

Q1. Some computer tasks
Add your answer
Q2. Reading test
Add your answer

Assignment is structured accordingly to the real time work scenarios

Q1. Advanced power bi questions which includes dax queries total sales, running sales using different filter conditions, power bi service related questions etc...
Add your answer
Q2. Advanced questions of SQL queries etc...
Add your answer

Q1. How do you gain experience in data analysis?
Add your answer
Q2. What are your thoughts on the matter?
Add your answer
Q3. What is algorithm
Add your answer

Q1. What is a data structure?
Add your answer
Q2. What are the different types of data structures available?
Add your answer

Q1. How can you design an Azure Data Factory pipeline to copy data from a folder containing files with different delimiters to another folder?
Add your answer
Q2. Write a pyspark program that reads multiple csv files and creates a data frame with count of records against each file
Add your answer