Crio.Do Data Analyst Intern Interview Questions and Answers

Verbal, logical, Quantative test

Q1. Self introduction
Add your answer

Q1. What is DAX and its use in power bi
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI for data modeling and analysis.
• DAX is used to create calculated columns and measures in Power BI.

• It allows for advanced data analysis, such as time intelligence functions (e.g., YEAR, MONTH).

• Example: A measure to calculate total sales could be defined as: Total Sales = SUM(Sales[Amount]).

• DAX supports filtering and context manipulation, enabling dyna...read more
Answered by AI
Add your answer
Q2. Role of power query in power bi
Add your answer

Any general knowledge topic

Q1. Tell me about yourself
Ans. My Name is Sujitha Rajendran.I have completed Master of Business Economics at Ethiraj College for women. I am from Namakkal district and searching for job opportunities now. My Father is a business man. My Mother is a home maker and My Brother is a Software Engineer
Answered by treasuredsangria
Add your answer
Q2. Strength and weakness
Add your answer
Q3. Short term and long term goal
Ans. 
Short term goal is to enhance data analysis skills, long term goal is to become a data science expert.
• Short term goal: Improve proficiency in SQL, Python, and data visualization tools

• Long term goal: Obtain advanced certifications in machine learning and AI

• Short term goal: Complete online courses on statistical analysis and data cleaning

• Long term goal: Lead data science projects and mentor junior analysts
Answered by AI
Add your answer
Q4. Why did you chosen this company?
Ans. My Strength is that I am not only a hard working person but also a smart working person. I am a quick learner and self motivational person. I am a good team player, good listener and good in time management
Answered by treasuredsangria
Add your answer
Q5. Why we want to hire you?
Add your answer
Q6. Salary discussion
Add your answer

SQL, Analytical, Maths

Q1. SQL qsn on some data
Add your answer
Q2. Qsn on LLMs in company
Add your answer

SQL two problem statements to be solved in 30 mins
Python two problem statements to be solved in 30 mins
Around 15 MCQ on stats and aptitude

Q1. Python, Excel, SQL and aptitude
Add your answer

Q1. Spark related questions
Add your answer
Q2. Previous projects done
Ans. 
Developed a real-time data processing system for a retail company to optimize inventory management.
• Designed and implemented data pipelines to ingest, process, and analyze large volumes of data

• Utilized technologies like Apache Kafka, Spark, and Hadoop for real-time processing

• Built dashboards and reports for stakeholders to monitor inventory levels and make data-driven decisions
Answered by AI
Add your answer

What is java and python example

What is meaning of c

What kind of coding used for c++