Crown It Senior Analyst Interview Questions and Answers

Q1. Reasons for the drop in CPM
Ans. 
Possible reasons for drop in CPM include seasonality, changes in ad inventory, shifts in audience demographics, and increased competition.
• Seasonal fluctuations in advertising demand

• Changes in available ad inventory

• Shifts in audience demographics affecting targeting effectiveness

• Increased competition leading to lower bids
Answered by AI
Add your answer
Q2. Types of floor in GAM
Ans. 
Types of floors in GAM include carpet, hardwood, tile, and laminate.
• Carpet

• Hardwood

• Tile

• Laminate
Answered by AI
Add your answer

Q1. Difference between union and union all in SQL?
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. How to show top 5 in pandas?
Ans. 
To show top 5 in pandas, use the nlargest() function.
• Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

• For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
Answered by AI
Add your answer

Q1. If we have 3 numerical columns, which chart is a better representation these column?
Ans. 
A scatter plot is a better representation for 3 numerical columns.
• Use a scatter plot to show the relationship between the numerical columns.

• Scatter plots are effective for visualizing correlations and patterns in data.

• Each point on the plot represents a data point with values from all 3 columns.
Answered by AI
Add your answer

Q1. HOW TO DO BUDGETING or Forecating
Ans. 
Budgeting involves creating a financial plan for a specific period of time.
• Identify the time period for the budget

• Determine the sources of income

• Estimate expenses and allocate funds accordingly

• Regularly monitor and adjust the budget as needed
Answered by AI
Add your answer

Q1. What will you bring to org
Add your answer

Q1. SQL,Python,Machine Learning,Model based question
Add your answer

Q1. General question , previous company role and responsibility etc
Add your answer

Q1. Tell me about yourself Why joined
Ans. 
I am an experienced Senior Analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Business Analytics and have been working in the field for over 8 years.

• I have successfully led multiple projects where I utilized my analytical skills to identify trends and provide actionable insights.

• I am proficient in various data analysis tools such as SQL, Excel, and Tableau.

• I am highly de...read more
Answered by AI
Add your answer
Q2. Why you want to join
Ans. 
I want to join because I am passionate about data analysis and believe my skills and experience align well with the role.
• I have a strong background in data analysis and have successfully led projects in my previous roles.

• I am excited about the opportunity to work with a team of experienced analysts and learn from their expertise.

• I am impressed by the company's reputation in the industry and its commitment to innovation...read more
Answered by AI
Add your answer

Q1. Questions on vlook up, h-look up, pivot and if else condition
Add your answer
Q2. You must know how to use vlook up, h-look up and if-else condition
Add your answer

Excel file was give, used sumifs, countifs , index match formulas

Q1. Some basic Python ETL Questions, based on list,dictionary.
Add your answer
Q2. SQL Basics Question
Add your answer

Q1. Explain your projects
Add your answer