Filter interviews by
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' ...
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...
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...
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...
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...
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...
Top trending discussions
I am a dedicated and experienced professional with strong leadership skills and a passion for driving team success.
Experience in managing teams and achieving targets
Strong communication and interpersonal skills
Ability to analyze data and make strategic decisions
Knowledge of industry trends and best practices
Proven track record of problem-solving and conflict resolution
I can bring strong leadership skills, strategic thinking, and a proven track record of driving results to the team.
Demonstrate my ability to lead and motivate a team towards achieving goals
Utilize my strategic thinking to identify opportunities for growth and improvement
Leverage my past successes in driving results and exceeding targets
I applied via Naukri.com and was interviewed in Nov 2017. There were 4 interview rounds.
The length of all India roads is approximately 5.5 million kilometers.
The total length of all India roads is estimated to be around 5.5 million kilometers.
India has one of the largest road networks in the world.
The road network in India includes national highways, state highways, district roads, and village roads.
The length of national highways alone is over 100,000 kilometers.
The road infrastructure plays a crucial ro...
I was interviewed in Apr 2017.
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
I applied via Recruitment Consultant and was interviewed before Aug 2020. There was 1 interview round.
I applied via Referral and was interviewed before Jun 2021. There were 2 interview rounds.
I applied via Referral and was interviewed before Mar 2021. There were 3 interview rounds.
I applied via Referral and was interviewed before Sep 2021. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 14 reviews
Rating in categories
Senior Analyst
207
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Executive
203
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
149
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive Analyst
137
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive
121
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
HCLTech
Tech Mahindra