Utthunga Technologies Interview Questions, Process, and Tips for Experienced

Star Schema has a centralized fact table with denormalized dimensions; Snowflake Schema normalizes dimensions into multiple related tables.

• Star Schema features a single fact table connected to multiple dimension tables.

• Snowflake Schema normalizes dimension tables into multiple related tables, reducing redundancy.

• Example of Star Schema: Sales data with a fact table for sales and dimension tables for products, customers,...read more

DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and SQL Server for data modeling and analysis.

• DAX is used to create custom calculations in Power BI and Excel.

• It includes functions for filtering, aggregating, and manipulating data.

• Example: CALCULATE function allows you to modify filter context in calculations.

• DAX supports time intelligence functions like YEAR, MONTH, and DATEDIFF for date-...read more

var is function scoped, let is block scoped, const is block scoped and cannot be reassigned.

• var is function scoped, let is block scoped, const is block scoped and cannot be reassigned

• var can be redeclared and updated, let can be updated but not redeclared, const cannot be redeclared or updated

• Use const for values that should not change, use let for values that may change, use var sparingly