Infocepts Technologies Assistant Manager Interview Questions, Process, and Tips

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' ...read more

OLAP is used for analyzing historical data while OLTP is used for managing real-time transactional data.

• OLAP stands for Online Analytical Processing and is used for complex queries and data analysis.

• OLTP stands for Online Transactional Processing and is used for managing real-time transactional data.

• OLAP databases are optimized for read-heavy workloads while OLTP databases are optimized for write-heavy workloads.

• OLAP d...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, all...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

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

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...read more

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

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

• Optimize...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...read more