Technip Energies Interview Questions and Answers

I optimized the performance of the dashboard by streamlining data sources, improving data visualization, and implementing automated updates.

• Identified and removed unnecessary data sources to reduce load times

• Utilized data caching techniques to improve dashboard loading speed

• Implemented data visualization best practices to enhance user experience

• Set up automated data refresh schedules to ensure real-time updates

• Optimized queries and data processing to improve overall performan...read more

Types of joins in SQL with examples

• Inner Join: Returns rows when there is a match in both tables. Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Left Join: Returns all rows from the left table and the matched rows from the right table. Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id

• Right Join: Returns all rows from the right table and the matched rows from the left table. Example: SELECT * FROM table1 RIGHT JOIN table2 ON table...read more

I have worked on creating a custom sales performance chart for tracking monthly revenue

• Utilized Excel to create a custom chart with data from multiple sources

• Implemented color coding to highlight trends and outliers

• Added interactive features for easy data analysis

• Presented the chart to senior management for decision-making purposes

In Tableau, groups are used to combine related dimension members, while sets are used to create custom fields based on a condition.

• Groups in Tableau are used to combine related dimension members into higher-level categories. For example, grouping different product categories into a single 'Other' category.

• Sets in Tableau are used to create custom fields based on a condition. For example, creating a set of 'High Sales' based on products with sales above a certain threshold.

• Gro...read more

Tableau filters include context filters, extract filters, data source filters, and user filters. Execution order is top-down.

• Context filters are applied first and limit the data set for subsequent filters.

• Extract filters are applied next, filtering data before it is extracted into Tableau.

• Data source filters are applied after extract filters, limiting the data at the data source level.

• User filters are applied last, allowing users to further refine the data based on their pref...read more

Tree map displays hierarchical data using nested rectangles, while heat map visualizes data using colors.

• Tree map organizes data in a hierarchical structure with nested rectangles

• Heat map uses colors to represent data values on a matrix

• Tree map is useful for showing proportions within a whole, while heat map is good for visualizing patterns or correlations in data

UNION combines the results of two or more SELECT statements, while UNION ALL does the same but includes duplicates.

• UNION removes duplicates from the result set, while UNION ALL includes duplicates

• UNION is slower than UNION ALL because it has to perform an additional step to remove duplicates

• UNION requires the same number of columns in the SELECT statements, while UNION ALL does not have this requirement

Rank function assigns a unique rank to each row in the result set, while dense_rank function assigns a unique rank to each distinct row in the result set.

• Rank function leaves gaps in the ranking if there are ties, while dense_rank function does not leave gaps.

• Rank function is used to assign a unique rank to each row based on the specified order, while dense_rank function is used to assign a unique rank to each distinct row.

• Example: SELECT name, salary, RANK() OVER (ORDER BY s...read more