AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Sarvagram Fincare
Compare
Filter interviews by
Sarvagram Fincare Data Analyst Interview Questions, Process, and Tips
Top Sarvagram Fincare Data Analyst Interview Questions and Answers
- Q1. What is data base and data warehouse
- Q2. windows functions in SQL and use of Lag function
- Q3. What is DAX in power bi
Sarvagram Fincare Data Analyst Interview Experiences
2 interviews found
(5 Questions)
- Q1. Windows functions in SQL and use of Lag function
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to perform calculations on a set of rows related to the current row in a query result.
The LAG function is a window function that allows you to access data from a previous row in the result set.
Example: SELECT employee_id, salary, LAG(salary) OVER (ORDER BY hire_date) AS prev_salary FR
- Q2. Nested for loop for list example
- Ans.
Nested for loop used to iterate through a list of items
Use a for loop to iterate through the main list
Inside the first loop, use another for loop to iterate through each item in the sublist
Example: for item in main_list: for sub_item in item: print(sub_item)
- Q3. What is data base and data warehouse
- Ans.
A database is a collection of structured data organized for easy access, while a data warehouse is a centralized repository for storing and analyzing large volumes of data.
Database is used for transactional processing and storing current data.
Data warehouse is used for analytical processing and storing historical data.
Database is typically used for day-to-day operations.
Data warehouse is used for decision-making and bu...
- Q4. Which are Joins in sql
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the righ...
- Q5. What is DAX in power bi
- Ans.
DAX (Data Analysis Expressions) is a formula language used in Power BI to create custom calculations and aggregations.
DAX is similar to Excel formulas but designed for more complex data analysis tasks
It can be used to create calculated columns, measures, and calculated tables in Power BI
DAX functions include aggregation functions like SUM, AVERAGE, and COUNT, as well as logical functions and date functions
Example: CALC...
Skills evaluated in this interview
Rohit Dudhal
Selected
(1 Question)
- Q1. SQL Basics details
Top trending discussions
Interview questions from similar companies
I applied via itvedant and was interviewed in Aug 2024. There was 1 interview round.
(1 Question)
- Q1. What are types of joins in SQL
- Ans.
Types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: returns rows when there is a match in both tables
Left join: returns all rows from the left table and the matched rows from the right table
Right join: returns all rows from the right table and the matched rows from the left table
Full outer join: returns rows when there is a match in either table
Skills evaluated in this interview
I applied via Walk-in and was interviewed in Oct 2024. There was 1 interview round.
SQL questions were asked
I applied via Walk-in and was interviewed before Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Job role, salary, dpoc
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Sammaan Capital Limited
Anonymous
posted on 6 Dec 2020
I applied via Campus Placement and was interviewed in Nov 2020. There were 6 interview rounds.
Interview Questionnaire
3 Questions
- Q1. General knowledge questions
- Q2. Company details
- Q3. Who do work
- Ans.
Business Analysts work with various stakeholders to analyze business processes and identify opportunities for improvement.
Business Analysts work with stakeholders from different departments to gather requirements and understand business needs.
They analyze data and conduct research to identify trends and patterns.
They document business processes and create models to visualize workflows.
They collaborate with IT teams to ...
Interview Preparation Tips
Harsh Jain
(2 Questions)
- Q1. Tell me about yourself
- Q2. Tell me about the projects you have worked on
(2 Questions)
- Q1. Tell me about yourself
- Q2. Why do you want to join BofA?
Selected
I applied via Referral and was interviewed in Jul 2024. There were 3 interview rounds.
Logical reasoning with mathematics and interpretation
LC easy and medium questions based on stack and dp
(1 Question)
- Q1. General questions about how I work, hobbies
Ashis Kumar Sahoo
Selected
I appeared for an interview before Feb 2023.
(3 Questions)
- Q1. What is the sdlc process?
- Ans.
SDLC stands for Software Development Life Cycle, a process used by software development teams to design, develop, and test high-quality software.
SDLC is a structured process that consists of several phases including planning, analysis, design, implementation, testing, and maintenance.
Each phase has its own set of activities and deliverables that must be completed before moving on to the next phase.
Examples of SDLC mode...
- Q2. What is agile methodologies
- Ans.
Agile methodologies are a set of principles and practices that prioritize flexibility, collaboration, and iterative development in project management.
Focus on adaptive planning and continuous improvement
Emphasize collaboration between cross-functional teams
Prioritize delivering working software in short iterations
Encourage frequent feedback and adaptation to changes
Common frameworks include Scrum, Kanban, and Extreme P
- Q3. Difference between agile and waterfall
- Ans.
Agile is iterative and flexible, while waterfall is sequential and rigid.
Agile involves continuous feedback and adaptation, while waterfall follows a linear approach.
Agile allows for changes throughout the project, while waterfall requires detailed planning upfront.
Agile promotes collaboration and communication among team members, while waterfall has distinct phases with limited interaction.
Agile is better suited for p...
(1 Question)
- Q1. Why you want to join our organization?
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2021. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Basic HR Questions
- Q2. Advanced SQL
- Q3. Power BI Questions, DAX
Interview Preparation Tips
Sarvagram Fincare Interview FAQs
Tell us how to improve this page.
Sarvagram Fincare Interviews By Designations
- Sarvagram Fincare Data Analyst Interview Questions
- Sarvagram Fincare Branch Relationship Officer Interview Questions
- Sarvagram Fincare Relationship Officer Interview Questions
- Sarvagram Fincare MIS Executive Interview Questions
- Sarvagram Fincare Branch Credit Officer Interview Questions
- Sarvagram Fincare Backend Developer Interview Questions
- Sarvagram Fincare Senior Software Engineer Interview Questions
- Sarvagram Fincare Farm Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Sarvagram Fincare Data Analyst Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Sarvagram Fincare Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Branch Relationship Officer
96
salaries
|  ₹1.9 L/yr - ₹4 L/yr |
|
Branch Manager
50
salaries
| ₹3.5 L/yr - ₹8.6 L/yr |
|
Branch Credit Manager
42
salaries
| ₹3 L/yr - ₹8 L/yr |
|
Branch Credit Officer
40
salaries
| ₹2.5 L/yr - ₹4.2 L/yr |
|
Credit Manager
20
salaries
| ₹3.2 L/yr - ₹7 L/yr |
Home Credit Finance
Kogta Financial India Limited
Sammaan Capital Limited
Hero FinCorp
- Home >
- Interviews >
- Sarvagram Fincare Interview Questions >
- Sarvagram Fincare Data Analyst Interview Questions
