Credenca Data Solutions Private Limited Interview Questions and Answers

1. SSIS based questions
2. SQL based questions

Q1. Tablueu filters asked in my interview
Ans. 
Tableau filters help refine data visualization by limiting the data displayed based on specific criteria.
• Types of filters: Dimension filters (e.g., filtering by 'Region'), Measure filters (e.g., filtering sales > $1000).

• Context filters: Set the context for other filters, e.g., filtering data for '2023' before applying other filters.

• Top N filters: Display only the top 'N' items based on a measure, e.g., top 10 produc...read more
Answered by AI
Add your answer

Q1. Sime Sql query and ETL part asked in ky interview
Ans. 
Understanding SQL queries and ETL processes is crucial for effective data analysis in Tableau.
• SQL queries are used to extract data from databases. Example: SELECT * FROM patients WHERE age > 30;

• ETL stands for Extract, Transform, Load, which is a process to move data from source to destination.

• In ETL, data is extracted from various sources, transformed into a suitable format, and then loaded into a data warehouse.

• Exa...read more
Answered by AI
Add your answer

Q1. Introduce yourself
Add your answer

Q1. Explain projects
Ans. 
Projects are specific tasks or assignments that require planning, execution, and completion within a defined timeframe.
• Projects involve a set of activities with a specific goal or outcome.

• They require resources such as time, budget, and manpower.

• Projects are typically temporary and have a defined start and end date.

• Examples: Developing a new BI dashboard, implementing a data warehouse, creating ETL processes.
Answered by AI
Add your answer

Q1. Management questions
Add your answer

Q1. Logic based questions like apti and simple coding
Add your answer
Q2. SQL based questions
Add your answer

General aptitude and logical reasoning questions asked

Q1. What is training? What is the term human capital ? How you can handle recruitment for 5 position at a time?
Add your answer
Q2. How you can handle recruitment for 5 Position at a time?
Ans. 
I would implement a structured approach to manage simultaneous recruitment effectively and efficiently.
• Prioritize roles based on urgency and impact on the organization.

• Utilize an Applicant Tracking System (ATS) to streamline applications.

• Create a clear timeline for each position, outlining key milestones.

• Leverage social media and job boards to widen the candidate pool.

• Conduct initial screenings in batches to save time ...read more
Answered by AI
Add your answer

Q1. What is talent acquisition, On how many position you can work at a time
Add your answer

Duration 30 min, Logical Reasoning

Q1. How you can conduct virtual Employee Engagement Activities
Ans. 
Virtual employee engagement activities can be conducted through online platforms and tools to keep employees connected and motivated.
• Organize virtual team building activities such as online games, quizzes, or virtual escape rooms

• Host virtual happy hours or coffee breaks for informal interactions

• Set up virtual recognition programs to acknowledge and appreciate employees' efforts

• Facilitate virtual training sessions or wo...read more
Answered by AI
Add your answer