JUSPAY Data Analyst Interview Questions and Answers

Q1. Tell me brief about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets using SQL, Python, and R

• Skilled in creating insightful reports and dashboards using Tableau and Power BI

• Strong communication skills to present findings to stakeholders

• Certified in data analysis and machine learning techniques
Answered by AI
Add your answer
Q2. What are youre strenth and weekness
Ans. 
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Getting caught up in details (provide example)
Answered by AI
Add your answer

Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
Add your answer
Q2. Python Basics (data frame, data types, lamda, series etc)
Add your answer
Q3. SQL Functions (joins, limits, partitions, orders by and group by)
Add your answer
Q4. 3rd round was managerial round, where mostly non-technicial questions asked.
Add your answer

Q1. Excel and SQL based questions
Add your answer

Q1. Python and project based questions
Add your answer

Q1. SQL: left join, right join and inner join questions find out the latest entry for an user when they log in to a app Python: few basic questions on python like count the characters in a word. Linux: what co...read more
Add your answer

Q1. Why data? Why Tokopedia? Talk about bachelor's thesis?
Ans. 
Data analysis is crucial for making informed decisions. Tokopedia's vast data provides a great opportunity for analysis. My bachelor's thesis focused on data-driven insights.
• Data allows for informed decision-making and insights.

• Tokopedia's extensive data provides a valuable opportunity for analysis.

• My bachelor's thesis delved into data-driven insights and analysis.
Answered by AI
Add your answer

Q1. Walkthrough bachelor's thesis
Add your answer

Q1. General questions and sql questions
Add your answer

Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
Ans. 
Different types of Joins in SQL and the outputs when joining two tables with nulls.
• Types of joins in SQL include inner join, left join, right join, and full outer join.

• When joining two tables with nulls, the output depends on the type of join used.

• In an inner join, null values are excluded from the result.

• In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...read more
Answered by AI
View 1 more answer
Q2. Can you union tables with different datatypes.
Ans. 
Yes, but it requires careful handling of data types and potential conversion.
• Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.

• Data types should be compatible, otherwise conversion may be necessary.

• For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.

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

Q1. Given a data set, should write sql queries to answer a few questions
Add your answer
Q2. A few puzzles would be asked to evaluate the problem solving skills.
Add your answer

Q1. Business Case studies - try parctising profitablility and other cases
Add your answer

Q1. An Excel round will also be there if you apply for business analyst role.
Add your answer

Easy questions based on Logical Reasoning, Mathematics, English

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Q1. Tell me about yourself Tell me something from your resume Desribe your project
Add your answer