-
Data Extraction
- Can Power BI connect to live data sources? If yes, how?
- How do you connect Power BI to different data sources?
- How do you deal with multiple data sources in Power BI?
- How do you import data into Power BI?
- How do you integrate Power BI with external APIs?
- How would you handle real-time data streaming in Power BI?
- What are custom connectors in Power BI?
- What is the difference between direct query and import mode in Power BI?
- What is the difference between DirectQuery and Live Connection in Power BI?
-
Data Transformation
- How do you clean data using Power Query?
- How do you handle different time zones in Power BI reports?
- How do you handle missing or null values in Power BI?
- How do you handle unstructured data in Power BI?
- How do you work with dataflow and Power BI?
- How does Power BI perform data transformation?
- What is a parameter in Power BI, and how can it be used?
- What is a Power Query in Power BI?
- What is Power BI Query Folding?
- What is Power Query Editor and what role does it play?
-
Data Modeling
- Explain the concept of calculation groups in Power BI.
- Explain the concept of many-to-many relationships in Power BI.
- Explain the concept of row-level security in Power BI.
- Explain the difference between a calculated column and a measure in Power BI.
- Explain the difference between a data model and a report in Power BI.
- How do you implement row-level security (RLS) in Power BI?
- How do you perform error handling in Power BI DAX?
- How do you use DAX to create a date table?
- What are calculated columns and calculated measures in Power BI?
- What are relationships in Power BI?
-
Data Visualization
- 02. What are the different types of filters in Power BI?
- 03. What is a dynamic title in Power BI?
- Can you explain the concept of slicers in Power BI?
- Explain how you would use Power BI to display geographical data.
- Explain the concept of drill-downs in Power BI.
- How can you change the visualization type in Power BI?
- How do you implement bookmarks in Power BI?
- How would you use drill-through in Power BI?
- What are bookmarks in Power BI?
- What are Power BI themes?
-
Dashboard Building
- Can you explain the importance of Power BI Service Gateway?
- Explain the components of Power BI.
- Explain what Power BI gateways are.
- How can you create a report in Power BI Desktop?
- How can you publish a report from Power BI Desktop to Power BI Service?
- How can you refresh data in Power BI?
- How do you create a Power BI dashboard from multiple reports?
- How do you export a report from Power BI?
- How do you handle multi-language reports in Power BI?
- How do you schedule data refresh in Power BI?
-
Performance Optimization
- 01. How do you handle large datasets in Power BI?
- Explain the usage of aggregation tables in Power BI.
- How do you handle performance issues when working with complex DAX expressions?
- How do you implement incremental data refresh in Power BI?
- How do you optimize large Power BI models?
- How do you optimize Power BI reports?
- How do you work with large datasets in Power BI without affecting performance?
- How does Power BI handle large datasets?
- How would you optimize a Power BI report for performance?
- How would you troubleshoot a performance issue in Power BI?
-
Project Knowledge
- Explain how to implement a multi-tier architecture in Power BI.
- Explain how you would implement audit logs in Power BI.
- Explain how you would integrate Power BI with Azure.
- Explain the role of Azure Machine Learning and how it integrates with Power BI.
- How can Power BI be integrated with SQL Server Analysis Services (SSAS)?
- How can you use Azure Data Lake with Power BI?
- How do you create and manage Power BI workspaces for teams?
- How do you ensure data security and governance in Power BI?
- How do you integrate Power BI with other Microsoft Power Platform tools (e.g., Power Apps, Power Automate)?
- How do you manage security and permissions for Power BI content?
- Domain Knowledge
- Basics
- Queries
- Joins
- Functions
- Subqueries
- DML
- DDL
- DCL/TCL
- Indexes and Performance
- Stored Procedures
- Views
- Window Funcions
- Date and Time
- Error Handling
- Best Practices
- Architecture
- Data Warehousing
- Distributed Systems
- Replication | Backup | Recovery
- Normalization
- Security
- Common Table Expression (CTE)
- Performance
- Modeling
- Admin
- Concurrency
- Asynchronous Programming
- Build System
- Collections
- Compilation
- Concurrency
- Conditional Statements
- Data Types
- Debugging & Profiling
- Dependency Injection
- Design Patterns
- Exception Handling
- FFI
- File Handling
- Flutter Animations
- Flutter Async Widgets
- Flutter Widgets
- Functional Programming
- Generics
- Internationalization
- Language Features
- Loop Control Statement
- Memory Management
- Mixins
- Networking
- Null Safety
- Object Oriented Programming
- Operators
- Package Management
- Performance Optimization
- Program Structure
- State Management
- Type Checking
- Type System
- Variables
- Web Programming
- Advanced Functions
- Built-in Functions
- Coding Standards
- Collections
- Comprehensions
- Concurrency
- Conditional Statements
- Data Types
- Environment Setup
- Exception Handling
- File Handling
- Functional Programming
- Functions
- Generators
- Introduction
- Iterators
- Loop Control Statement
- Memory Management
- Modules
- OOPS
- Operators
- Program Execution
- Type Hints