Answer:
Relationships connect tables through common columns.
Example:
Customers → CustomerID
Orders → CustomerID
Benefits:
✔ Enables cross-filtering
✔ Supports data modeling
73. What is Star Schema?
Answer:
A data model where one Fact Table is connected to multiple Dimension Tables.
Example:
Fact Sales
├─ Date
├─ Product
└─ Customer
Benefits:
✔ Better performance
✔ Easier reporting
74. What is Snowflake Schema?
Answer:
An extension of Star Schema where dimensions are further normalized.
Example:
Sales → Product → Category
Benefits:
✔ Reduced redundancy
Drawback:
❌ More complex queries
75. What are Slicers?
Answer:
Slicers are visual filters.
Users can interactively filter reports.
Examples:
✔ Region
✔ Product
✔ Year
76. What are Bookmarks?
Answer:
Bookmarks save the current report view.
Used for:
✔ Navigation
✔ Show/Hide visuals
✔ Storytelling
77. What is Drill-Through?
Answer:
Drill-through allows users to navigate from summary data to detailed data.
Example:
Country Sales → Customer Details
78. Explain Row-Level Security (RLS)
Answer:
RLS restricts data visibility based on users.
Example:
Sales Manager - East can only see East region data.
Benefits:
✔ Security
✔ Controlled access
79. What are KPIs?
Answer:
KPIs (Key Performance Indicators) measure business performance.
Examples:
✔ Revenue
✔ Profit
✔ Customer Retention
✔ Conversion Rate
80. Difference Between Dashboard and Report
Feature | Dashboard | Report
Pages | Single page | Multiple pages
View | Summary view | Detailed analysis
Platform | Service only | Desktop & Service
Focus | High-level metrics | Detailed insights
81. What is Data Modeling?
Answer:
Data Modeling is the process of organizing tables and relationships.
Goals:
✔ Improve performance
✔ Simplify analysis
✔ Ensure accuracy
82. Explain CALCULATE()
Answer:
CALCULATE() modifies filter context.
Example:
Total Sales East =
CALCULATE(
SUM(Sales[Amount]),
Sales[Region] = "East"
)
One of the most important DAX functions.
83. Explain FILTER()
Answer:
FILTER() returns a filtered table.
Example:
FILTER(Sales, Sales[Amount] > 1000)
Often used inside CALCULATE().
84. Explain ALL()
Answer:
ALL() removes filters.
Example:
Total Sales =
CALCULATE(
SUM(Sales[Amount]),
ALL(Sales)
)