Tiger Analytics Senior Modeller Interview Questions and Answers

Top down approach is a problem solving or design strategy that starts with the larger overview and breaks it down into smaller components.

• Start with a broad overview of the problem or design

• Break it down into smaller components or sub-problems

• Address each component individually before integrating them back together

• Commonly used in software development, project management, and system design

Star schema is a denormalized schema with a single central fact table surrounded by dimension tables. Snowflake schema is a normalized schema with multiple interconnected dimension tables.

• Star schema is easier to understand and query due to denormalization.

• Snowflake schema saves storage space by normalizing data.

• Star schema is better for data warehousing and reporting, while snowflake schema is better for OLAP systems.

• ...read more

Design a data model for a customer relationship management system

• Identify entities such as customers, products, orders, and sales representatives

• Establish relationships between entities (e.g. a customer can place multiple orders)

• Define attributes for each entity (e.g. customer name, product price)

• Consider normalization to reduce redundancy and improve data integrity