Capgemini Data Engineering Analyst Interview Questions and Answers

I worked on a data visualization tool for tracking sales performance.

• The tool was built using Tableau and SQL.

• It allowed users to view sales data by region, product, and time period.

• Users could also create custom dashboards and reports.

• The tool helped identify trends and opportunities for improvement.

• I collaborated with the sales team to ensure the tool met their needs.

Transposing a data set involves flipping rows and columns.

• Identify the data set to be transposed

• Create a new table with the columns and rows flipped

• Copy the data from the original table to the new table

• Transpose can be done using Excel, Python, R, SQL, etc.

• Example: Transposing a table of sales data to have products as rows and months as columns

Structured Query Language (SQL) is a programming language used to manage and manipulate relational databases.

• SQL is used to create, modify, and delete databases, tables, and data

• It is used to retrieve data from databases using queries

• SQL is used to perform operations on data such as sorting, filtering, and grouping

• Examples of SQL-based database management systems include MySQL, Oracle, and Microsoft SQL Server