The Smart Cube Analyst Interview Questions and Answers

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer

Q1. About yourself and Internship Experience
Add your answer
Q2. Guesstimate on what is prominent in your CV
Ans. 
My experience in financial analysis and data interpretation stands out in my CV.
• Extensive experience in financial analysis

• Strong skills in data interpretation and modeling

• Proven track record of making data-driven recommendations

• Proficiency in financial software and tools

• Completed projects that involved complex financial modeling
Answered by AI
Add your answer

Q1. What are the tools you used
Ans. 
I have used a variety of tools including Excel, SQL, Tableau, Python, and Power BI.
• Excel

• SQL

• Tableau

• Python

• Power BI
Answered by AI
Add your answer
Q2. Power Apps used for reporting and automation
Ans. 
Power Apps can be used for creating custom reporting and automating business processes.
• Power Apps can connect to various data sources to pull in data for reporting purposes.

• Users can create custom dashboards and reports using Power Apps to visualize data.

• Automation can be achieved by creating workflows and processes within Power Apps.

• Examples: Creating a Power App to track sales leads and generate reports, automating a
Answered by AI
Add your answer

Easy to medium level

Q1. Everything related to all the processes followed in a ML project like qs related to outliers, feature engg, l1, l2 regularization, multicollinearity and its detection, overfitting, cross validation and its...read more
Add your answer

Q1. Qs related to my resumes and business related qs
Add your answer

Q1. This was with the director there were two case studies he gave to solve
Add your answer

Q1. Basic behavioural qs
Add your answer

It was a altitude test.

Q1. It was a technical inyerview.
Add your answer

Q1. This was 2nd thechnical interview.
Add your answer

Q1. Final hr round. Job relayed discussion
Add your answer

Q1. Tell me about yourself
Add your answer