Add office photos
i
JPMorgan Chase & Co.
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
JPMorgan Chase & Co. Business Analytics Associate Interview Questions and Answers
JPMorgan Chase & Co. Business Analytics Associate Interview Experiences
1 interview found
Rahul Nayak
Selected
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What Projects have you worked on? Explain the projects and tools used.
- Q2. What is the use of parameters in Tableau?
- Ans.
Parameters in Tableau allow users to dynamically change the values of calculations, filters, and reference lines.
Parameters can be used to create dynamic filters that allow users to change the data displayed in a visualization.
Parameters can also be used in calculations to perform complex calculations based on user input.
Parameters can be used in reference lines to dynamically set thresholds or benchmarks for compariso
(2 Questions)
- Q1. Explain the differences between direct and indirect expenses?
- Ans.
Direct expenses are directly related to the production of goods or services, while indirect expenses are not directly tied to production.
Direct expenses can be easily traced to a specific cost object, such as raw materials or labor costs.
Indirect expenses are overhead costs that are necessary for the business to operate but are not directly tied to a specific product or service.
Examples of direct expenses include direc...
- Q2. Explain the balance sheet and P&L of banking firms/companies
- Ans.
Balance sheet shows a company's assets, liabilities, and equity at a specific point in time. P&L shows a company's revenues, expenses, and profits over a period of time.
Balance sheet includes assets (cash, investments, loans), liabilities (deposits, debt), and equity (common stock, retained earnings)
P&L shows revenues (interest income, fees), expenses (operating expenses, loan loss provisions), and profits (net income)
...
Skills evaluated in this interview
Interview questions from similar companies
Senior Analytics Consultant Interview Questions & Answers
Wells Fargo
Anonymous
posted on 28 Nov 2024
I applied via Company Website and was interviewed in Oct 2024. There were 2 interview rounds.
(4 Questions)
- Q1. Filters in Tableau
- Ans.
Filters in Tableau allow users to focus on specific data points within a visualization.
Filters can be applied to dimensions or measures to narrow down the data being displayed.
Users can use various types of filters such as quick filters, context filters, and data source filters.
Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.
Example: Applying a filter to show only
- Q2. Blending and joins in Tableau
- Ans.
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
Blending is used when data sources have a common field but different levels of granularity.
Joins are used when data sources have a common field and the same level of granularity.
Blending creates a virtual join, while joins physically combine the data.
Examples: Blending sales data from Excel with customer data ...
- Q3. LOD expressions in Tableau
- Ans.
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
LOD expressions include FIXED, INCLUDE, and EXCLUDE functions
FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level
INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization
EXCLUDE LOD expressions compute ...
- Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
- Ans.
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
TRUNCATE: removes all rows from a table without logging individual row deletions
DELETE: removes specific rows from a table and logs each row deletion
TRUNCATE is faster than DELETE as it does not log individual
(2 Questions)
- Q1. About my technical experience
- Q2. What will you do if you get the offer from multiple companies
Interview Preparation Tips
After the second round, I did not receive any feedback for several days, so I contacted HR to inquire about the status. They assured me they would provide an update, but I did not hear back. I reached out again and was told that I was not selected because I was "not technically strong." This reason seemed misleading, as the second round was not even technical in nature.
My impression is that my current salary expectations may have exceeded their budget for the role. Rather than acknowledging this, it seems they opted to cite a technical deficiency as the reason for my rejection, which I believe was not accurate.
Skills evaluated in this interview
(5 Questions)
- Q1. SQL queries regarding your project
- Q2. Pratice joining concepts
- Q3. Regarding end to end intercation with your project manager
- Q4. ETL process and tableau concepts
- Q5. Dashboard related to Tableau
Interview Preparation Tips
- Don't make you down at the time of interview.
- Answer what's real
Selected
I applied via Naukri.com and was interviewed before Sep 2023. There were 2 interview rounds.
Medium difficulty level. Good to go prepared with basics.
(2 Questions)
- Q1. Resume based questions like what and how did you do this
- Q2. Banking knowledge check like how bank works, different banking products etc
(2 Questions)
- Q1. SQL , Oracle SQL, distinct
- Q2. SQL, analytical SQL query
Selected
I applied via Referral and was interviewed before Sep 2022. There were 3 interview rounds.
(1 Question)
- Q1. Question related to BFSI - mostly from resume, collection startegy, Sas, project handling
(1 Question)
- Q1. Case studies related to collection, segmentation, market based questions in contact strategy
Senior Analytics Consultant Interview Questions & Answers
Wells Fargo
Anonymous
posted on 11 Dec 2024
I applied via Job Portal and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. What are your primary skills
- Ans.
My primary skills include data analysis, statistical modeling, programming, and problem-solving.
Data analysis
Statistical modeling
Programming
Problem-solving
- Q2. What is your core strength
- Ans.
My core strength lies in my ability to analyze complex data sets and derive actionable insights to drive business decisions.
Strong analytical skills
Ability to work with large data sets
Experience in data visualization tools like Tableau
Proven track record of using data to drive business strategy
I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.
(1 Question)
- Q1. Logistic regression, modeling experience, choosing best model, SQL.. Find the third transaction of customer from dataset
Interview Preparation Tips
Senior Analytics Consultant Interview Questions & Answers
Wells Fargo
PREM SINGH
posted on 14 Aug 2024
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
AML/KYC trigger and model related
I was interviewed in Jan 2024.
(1 Question)
- Q1. 1. Macro quoting functions in SAS 2. ways to create macro variable in Data step 3. date functions-intck() and intnx() 4.situational scenario based questions 5.Automatic variables in SAS
- Ans.
The interview questions cover topics such as macro quoting functions, creating macro variables, date functions, situational scenario-based questions, and automatic variables in SAS.
Macro quoting functions in SAS allow for the creation of macro variables with special characters.
Macro variables can be created in the data step using the %LET statement or by using the CALL SYMPUTX routine.
The date functions INTCK() and INT...
Interview Preparation Tips
- SAS
- SQL
Skills evaluated in this interview
JPMorgan Chase & Co. Interview FAQs
Tell us how to improve this page.
JPMorgan Chase & Co. Interviews By Designations
- JPMorgan Chase & Co. Associate Interview Questions
- JPMorgan Chase & Co. Software Engineer Interview Questions
- JPMorgan Chase & Co. Analyst Interview Questions
- JPMorgan Chase & Co. Software Developer Interview Questions
- JPMorgan Chase & Co. Senior Associate Interview Questions
- JPMorgan Chase & Co. Team Lead Interview Questions
- JPMorgan Chase & Co. Senior Software Engineer Interview Questions
- JPMorgan Chase & Co. Junior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Analytics Consultant Interview Questions
- Decision Analytics Associate Interview Questions
- Business Analytics Interview Questions
- IT (Data Analytics) Interview Questions
- Data Analytics Intern Interview Questions
- Analytics Engineer Interview Questions
- Business Analytics Manager Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
|
Associate
10.1k
salaries
|  ₹10 L/yr - ₹35.2 L/yr |
|
Team Lead
5.4k
salaries
| ₹5.5 L/yr - ₹16.5 L/yr |
|
Vice President
3.8k
salaries
| ₹20 L/yr - ₹68 L/yr |
|
Analyst
2.5k
salaries
| ₹6.3 L/yr - ₹25 L/yr |
|
Software Engineer
2.4k
salaries
| ₹11 L/yr - ₹35 L/yr |
Morgan Stanley
Goldman Sachs
TCS
Bank of America
Calculate your in-hand salary
- Home >
- Interviews >
- JPMorgan Chase & Co. Interview Questions >
- JPMorgan Chase & Co. Business Analytics Associate Interview Questions
