Hungry Jack's Data Analyst Interview Questions and Answers

Q1. What is p value?
Ans. 
A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.
• A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

• A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.

• A p-value less than the significance level indicates st
Answered by AI
Add your answer
Q2. Tell the output a**2
Ans. 
The output of a**2 is the square of the value of a.
• The output is the value of a multiplied by itself

• For example, if a = 3, then the output would be 9 (3*3)
Answered by AI
Add your answer
Q3. Difference between append() and concat
Ans. 
append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.
• append() is a method used to add rows to a DataFrame.

• concat() is a function used to combine multiple DataFrames along a particular axis.

• append() modifies the original DataFrame, while concat() returns a new DataFrame.

• Example: df1.append(df2) vs pd.concat([df1, df2])
Answered by AI
Add your answer

Q1. What is data analysis?
Ans. 
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information, draw conclusions, and support decision-making.
• Data analysis involves examining raw data to find patterns, trends, and insights.

• It includes cleaning and organizing data, performing statistical analysis, and creating visualizations.

• Data analysis helps businesses make informed decisions, improve processes,...read more
Answered by AI
Add your answer
Q2. What stack have you worked with
Ans. 
I have worked with a variety of stacks including Python, SQL, Tableau, and Excel for data analysis.
• Python

• SQL

• Tableau

• Excel
Answered by AI
Add your answer

Q1. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot

• List is defined using square brackets [], tuple using parentheses ()

• Example: list - [1, 2, 3], tuple - (1, 2, 3)
Answered by AI
Add your answer
Q2. Nth highest salary
Ans. 
To find the Nth highest salary in a dataset, you can use SQL query with ORDER BY and LIMIT.
• Use SQL query with ORDER BY and LIMIT to sort the salaries in descending order and select the Nth row.

• For example, to find the 3rd highest salary in a table 'employees', you can use: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2, 1
Answered by AI
Add your answer

Q1. SQL Query of case when then statement
Ans. 
SQL query using CASE WHEN THEN statement
• Use CASE WHEN statement to create conditional logic in SQL queries

• Syntax: SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result3 END AS new_column_name FROM table_name

• Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS age_group FROM customers
Answered by AI
Add your answer
Q2. SQL Query of join
Ans. 
SQL query to join tables based on a common key
• Use JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to be joined in the ON clause

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Answered by AI
Add your answer

Q1. Difference between Sum and SUMX in DAX
Ans. 
SUM calculates the total of a column, while SUMX calculates the total of an expression evaluated for each row.
• SUM is used to calculate the total of a column in a table

• SUMX is used to calculate the total of an expression evaluated for each row in a table

• SUMX is often used with iterators like FILTER or RELATEDTABLE to perform calculations on a row-by-row basis
Answered by AI
Add your answer
Q2. How do you use Group By in Power Query?
Ans. 
Group By in Power Query is used to aggregate data based on a specific column or columns.
• Select the column(s) you want to group by

• Go to the 'Transform' tab and click on 'Group By'

• Choose the aggregation type and column to aggregate on

• Rename the new column if needed
Answered by AI
Add your answer

1hr test , basic apti questions .

American express discussion and economics

What are the company data analytics