Used for:

✔ Percentages,

✔ Benchmarking

85. Explain Time Intelligence Functions

Answer:

Used to analyze data over time.

Common Functions:

TOTALYTD(), SAMEPERIODLASTYEAR(), DATEADD(), DATESYTD()

Examples:

✔ YTD Sales

✔ YoY Growth

✔ Monthly Trends

86. What is Incremental Refresh?

Answer:

Incremental Refresh loads only new or changed data.

Benefits:

✔ Faster refresh

✔ Better performance

✔ Reduced resource usage

Useful for large datasets.

87. Difference Between Import and DirectQuery

Feature | Import | DirectQuery

Data | Data stored in Power BI | Data remains in source

Speed | Faster | Slower

Performance | Better performance | Real-time data

Storage | Limited by memory | No large storage issue

88. Explain Power BI Gateways

Answer:

A Gateway connects on-premises data sources to Power BI Service.

Used for:

✔ Scheduled refresh

✔ Secure connectivity

89. How Do You Optimize Dashboards?

Answer:

Best Practices:

✔ Use Star Schema

✔ Remove unused columns

✔ Reduce visuals

✔ Use measures instead of columns

✔ Enable incremental refresh

✔ Optimize DAX

90. What Causes Slow Reports?

Common Reasons:

✔ Too many visuals

✔ Large datasets

✔ Complex DAX

✔ Poor relationships

✔ Excessive calculated columns

91. How Do You Handle Large Datasets?

Answer:

Techniques:

✔ Incremental Refresh

✔ Aggregation Tables

✔ Star Schema

✔ Data Reduction

✔ DirectQuery when needed

92. What are Custom Visuals?

Answer:

Additional visuals available from the Power BI Marketplace.

Examples:

✔ Sankey Chart

✔ Gantt Chart

✔ KPI Cards

✔ Advanced Maps

93. Explain Workspace Management

Answer:

Workspaces are collaborative environments in Power BI Service.

Used for:

✔ Development

✔ Testing

✔ Production

Benefits:

✔ Team collaboration

✔ Access management

94. How Do You Publish Reports?

Answer:

Steps:

1. Create report in Desktop

2. Click Publish

3. Select Workspace

4. Access report in Service

95. Explain Deployment Pipelines

Answer:

Deployment Pipelines help move reports between:

Development → Testing → Production

Benefits:

✔ Version control

✔ Safer deployments

✔ Better governance

🔥 Most Important Power BI Topics for Data Analyst Interviews

Recruiters frequently focus on:

✅ Data Modeling

✅ Relationships

✅ Star Schema

✅ DAX Functions

✅ CALCULATE()

✅ Measures vs Calculated Columns

✅ Power Query

✅ Row-Level Security

✅ Dashboard Design

✅ Performance Optimization

💡 Interview Tip:

For Power BI interviews, don't just explain features. Be prepared to discuss:

• A dashboard you built

• KPIs you tracked

• DAX measures you created

• Data model design decisions

• Business insights you delivered

Those real-world examples often matter more than theoretical definitions.

Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c

Double Tap ❤️ For Part-4 🚀