AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
WinZO
Compare
Filter interviews by
WinZO Senior Data Analyst Interview Questions and Answers
WinZO Senior Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Approached by Company and was interviewed in Dec 2023. There was 1 interview round.
Intermediate SQL Topics - Window Function, Subquery, Joins
Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);
1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
(2 Questions)
- Q1. Write a sql query
- Ans.
SQL query to retrieve employee names and their salaries from a table
Use SELECT statement to retrieve data
Specify the columns you want to retrieve (employee names and salaries)
Specify the table name where the data is stored
- Q2. Formula of vlookup
- Ans.
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Based on my CV, they assigned me a task related to data migration.
(2 Questions)
- Q1. Project reviews
- Q2. Attendance regarding
I applied via Recruitment Consulltant and was interviewed in Dec 2022. There were 2 interview rounds.
(3 Questions)
- Q1. Details about the projects in your resume
- Q2. MYSQL codes in window function
- Ans.
MYSQL window functions allow for calculations across rows in a result set.
Window functions are used to perform calculations across rows in a result set
They are used with the OVER() clause
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()
They can be used to calculate running totals, moving averages, and more
- Q3. Mostly questions related to cricket tables which was told to be assumed
Interview Preparation Tips
Interviewer was a young girl she didn't gave any data or material.
Everything was assumption assume tables and she asked me to code in paper
never had such experience.
Skills evaluated in this interview
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL based questions
- Q2. Guesstimate on estimating # users on the application
- Ans.
Estimate the number of users on the application based on market research, user demographics, and industry trends.
Consider the total addressable market (TAM) for the application
Analyze user demographics and behavior to estimate adoption rate
Look at industry benchmarks and competitor data for reference
Use surveys, focus groups, and user feedback to gather insights
Consider factors like market saturation, growth potential,
Selected
I applied via Approached by Company and was interviewed before Mar 2022. There were 3 interview rounds.
The aptitude test was not that difficult.
The coding test was of moderate difficulty
Interview Preparation Tips
- SQL
- Python
I applied via Job Fair and was interviewed in May 2024. There were 2 interview rounds.
(1 Question)
- Q1. SQL query for root,leaf and other nodes Spark Optimizations Python Coding questions
(1 Question)
- Q1. About Project,Spark Questions, Optimizations, OOPS Concept. SQL Questions
I applied via Naukri.com and was interviewed before Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Machine Learning
(1 Question)
- Q1. Machine Learning
Approach check for multiple case studies
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Jan 2022. There were 4 interview rounds.
Coding skills in Python, Spark/Scala are a must.
Python, Spark, Scala, Terraform
(2 Questions)
- Q1. Why are you changing the job
- Q2. What is your strong suite
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Jul 2023. There were 3 interview rounds.
Cultural discussion and briefing on job description
SQL logic test and pipeline design
Interview Preparation Tips
- SQL
- ETL
WinZO Interview FAQs
Tell us how to improve this page.
WinZO Interviews By Designations
- WinZO Senior Software Development Engineer Interview Questions
- WinZO Marketing Manager Interview Questions
- WinZO Senior Product Manager Interview Questions
- WinZO Product Manager Interview Questions
- WinZO Senior Devops Engineer Interview Questions
- WinZO Senior Data Analyst Interview Questions
- WinZO Principal Engineer Interview Questions
- WinZO Software Development Engineer Intern Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Show more
WinZO Senior Data Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Product Manager
16
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
QA Engineer
8
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Developer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Graphic Designer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Mpl
Dream11
Mobile Premier League
Rummy Circle
- Home >
- Interviews >
- WinZO Interview Questions >
- WinZO Senior Data Analyst Interview Questions
