The Smart Cube Senior Data Analyst Interview Questions and Answers

Q1. What projects are you working on?
Add your answer
Q2. Tell me about a time you struggled.
Add your answer

Q1. Hard DP level DSA question
Add your answer

Aptitude have some basic questions that many of us can solve easily not that much difficult.

Q1. Nothing much just simple questions about normal calculations, your Introduction, Be Frank keep smile and be confident.
Add your answer
Q2. They also checked your communication skills, grammar skills or some times they assign you to write formal letter or e-mails which could be pretty difficult sometimes be prepared for to that too.
Add your answer

A test designed to a determination a person ability in particular skill of field knowledge

Coding and decoding

Devolpment of a particular person group or situation over a period of time

Q1. Relating to a particular Subject art or carft or its techNical Terms
Add your answer

Is a situation faced when individuals collectively make a choice from alternative before them

A task or piEce of work allocated to someone a part of a job or course of study a home work assignment

Q1. InvolVoing or concerned with applied and industrial science
Add your answer

Coding interview test candidate technical knowledge coding ability creativity typically on a white board

Q1. Managing an organisation employees
Add your answer

Q1. Each player from one team is matched a single player from other team
Add your answer

The from are checked and returned to the census officer for coding

Q1. How good are you with numbers
Add your answer

Q1. Vlookup, pivot table, sumif, average, graphs
Add your answer

Q1. Do you know the role and responsibility of this position
Add your answer

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• 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 right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN...read more
Answered by AI
Add your answer
Q3. How to add date table in power bi
Ans. 
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
• Create a new table in Power BI with a list of dates

• Add columns for day, month, year, etc. for additional analysis

• Establish relationships between the date table and other tables in the data model
Answered by AI
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here

Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well.
Add your answer

Q1. What is the number of tourist per day in jaipur
Ans. 
The number of tourists per day in Jaipur varies depending on the season and events happening in the city.
• Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

• Events like festivals or cultural events can attract more tourists

• Historical sites like Amer Fort and Hawa Mahal are popular attractions

• Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions
Answered by AI
Add your answer