AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Reliance Smart Data Analyst Interview Questions and Answers
Reliance Smart Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Job Portal and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. About past experience
- Q2. Data analyst project
(1 Question)
- Q1. Salary question
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
(4 Questions)
- Q1. How do you setup a Dark Store?
- Ans.
Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.
Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.
Optimize the layout of the store for efficient picking, packing, and shipping of orders.
Implement inventory management systems to track stock levels accurately and prevent stockouts.
Train staff on order f...
- Q2. How do joins work in the simplest manner?
- Ans.
Joins combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
- Q3. Write a basic query explaining the order of execution?
- Ans.
The order of execution in a query determines the sequence in which operations are performed.
1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
2. The FROM clause specifies the tables involved in the query.
3. The WHERE clause filters the rows based on specified conditions.
4. The GROUP BY clause groups the rows that have the same values into summary rows.
5...
- Q4. Difference between Group By and Distinct?
- Ans.
Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.
Group By is used with aggregate functions like COUNT, SUM, AVG, etc.
Distinct is used to retrieve unique values from a column or set of columns.
Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.
Interview Preparation Tips
- SQL
- joins
- window functions
Skills evaluated in this interview
I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
I applied via Walk-in and was interviewed in Feb 2020. There was 1 interview round.
Interview Questionnaire
6 Questions
- Q1. How can maintain business analyst
- Ans.
To maintain as a business analyst, one should continuously update skills, stay informed about industry trends, and actively engage with stakeholders.
Continuously update skills through training, certifications, and attending industry conferences.
Stay informed about industry trends, new technologies, and best practices.
Actively engage with stakeholders to understand their needs, gather requirements, and provide valuable ...
- Q2. How can grown business.
- Ans.
To grow a business, focus on market research, customer satisfaction, innovation, and effective marketing strategies.
Conduct thorough market research to identify opportunities and target audience.
Ensure customer satisfaction by providing high-quality products/services and excellent customer support.
Encourage innovation and adapt to changing market trends.
Develop effective marketing strategies to reach and attract potent...
- Q3. How can created ticket size.
- Ans.
Ticket size can be increased by implementing strategies to upsell and cross-sell products or services.
Analyze customer data to identify opportunities for upselling and cross-selling
Train sales teams to effectively communicate and promote additional products or services
Offer incentives or discounts for customers who purchase larger ticket sizes
Implement targeted marketing campaigns to promote higher-priced products or s...
- Q4. Customers entry analysis
- Q5. In store tribal
- Q6. Inventory management
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Sep 2023. There were 2 interview rounds.
Case study on Dmart financials
(2 Questions)
- Q1. How soon can you join
- Q2. Immediately I can join
Interview Preparation Tips
Selected
(2 Questions)
- Q1. Basic info and stuff etc
- Q2. Basic details and info about previous organisation
(1 Question)
- Q1. Related to previous experiences by HOD
(1 Question)
- Q1. Current reporting manager interaction
(1 Question)
- Q1. Package etc discussed, which is finalised
(2 Questions)
- Q1. Knowledge of financials
- Q2. Knowledge of ratings
(2 Questions)
- Q1. Reason for move from current
- Q2. Career ambitions in the domain
Thunder
(1 Question)
- Q1. Have you worked in databricks
- Ans.
Yes, I have worked in Databricks for data engineering projects.
I have experience using Databricks for data processing and analysis.
I have utilized Databricks for building and optimizing data pipelines.
I have worked with Databricks notebooks for coding and collaboration.
I have used Databricks clusters for scalable data processing.
I have integrated Databricks with other tools like Apache Spark for big data processing.
Selected
I applied via Recruitment Consulltant and was interviewed before May 2022. There were 3 interview rounds.
(2 Questions)
- Q1. SAP basis and database (oracle) question
- Q2. IT Network related question
(1 Question)
- Q1. Personal detail,salary negotiations and documents verification
Interview Preparation Tips
I applied via Naukri.com
(2 Questions)
- Q1. Ddaaff ffff fffdf
- Q2. Fdffffff dfff dfdff dfdf
Interview Preparation Tips
Reliance Smart Interview FAQs
Recently Viewed
INTERVIEWS
Reliance Retail
No Interviews
SALARIES
Reliance Retail
No Salaries
SALARIES
Reliance Retail
No Salaries
DESIGNATION
JOBS
Emcure Pharmaceuticals
No Jobs
JOBS
Reliance Retail
No Jobs
INTERVIEWS
Reliance Retail
No Interviews
DESIGNATION
INTERVIEWS
Reliance Retail
No Interviews
SALARIES
Conneqt Business Solutions
Tell us how to improve this page.
Reliance Smart Interviews By Designations
- Reliance Smart Senior Associate Interview Questions
- Reliance Smart Department Manager Interview Questions
- Reliance Smart Assistant Manager Interview Questions
- Reliance Smart Retail Store Manager Interview Questions
- Reliance Smart Account Assistant Interview Questions
- Reliance Smart Customer Service Associate Interview Questions
- Reliance Smart Data Analyst Interview Questions
- Reliance Smart Team 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
Reliance Smart Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
|
Department Manager
205
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Store Manager
145
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Customer Service Associate
114
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Store Manager
89
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Cashier
66
salaries
| ₹0 L/yr - ₹0 L/yr |
Big Bazaar
Spencer's Retail
DMart
Future Retail
- Home >
- Interviews >
- Reliance Smart Interview Questions >
- Reliance Smart Data Analyst Interview Questions
