✅ 15 Power BI Interview Questions for Freshers 📊💻
1️⃣ What is Power BI and what is it used for?
Answer: Power BI is a business analytics tool by Microsoft to visualize data, create reports, and share insights across organizations.
2️⃣ What are the main components of Power BI?
Answer: Power BI Desktop, Power BI Service (Cloud), Power BI Mobile, Power BI Gateway, and Power BI Report Server.
3️⃣ What is a DAX in Power BI?
Answer: Data Analysis Expressions (DAX) is a formula language used to create custom calculations in Power BI.
4️⃣ What is the difference between a calculated column and a measure?
Answer: Calculated columns are row-level computations stored in the table. Measures are aggregations computed at query time.
5️⃣ What is the difference between Power BI Desktop and Power BI Service?
Answer: Desktop is for building reports and data modeling. Service is for publishing, sharing, and collaboration online.
6️⃣ What is a data model in Power BI?
Answer: A data model organizes tables, relationships, and calculations to efficiently analyze and visualize data.
7️⃣ What is the difference between DirectQuery and Import mode?
Answer: Import loads data into Power BI, faster for analysis. DirectQuery queries the source directly, no data is imported.
8️⃣ What are slicers in Power BI?
Answer: Visual filters that allow users to dynamically filter report data.
9️⃣ What is Power Query?
Answer: A data connection and transformation tool in Power BI used for cleaning and shaping data before loading.
1️⃣0️⃣ What is the difference between a table visual and a matrix visual?
Answer: Table displays data in simple rows and columns. Matrix allows grouping, row/column hierarchies, and aggregations.
1️⃣1️⃣ What is a Power BI dashboard?
Answer: A single-page collection of visualizations from multiple reports for quick insights.
1️⃣2️⃣ What is a relationship in Power BI?
Answer: Links between tables that define how data is connected for accurate aggregations and filtering.
1️⃣3️⃣ What are filters in Power BI?
Answer: Visual-level, page-level, or report-level filters to restrict data shown in reports.
1️⃣4️⃣ What is Power BI Gateway?
Answer: A bridge between on-premise data sources and Power BI Service for scheduled refreshes.
1️⃣5️⃣ What is the difference between a report and a dashboard?
Answer: Reports can have multiple pages and visuals; dashboards are single-page, with pinned visuals from reports.
Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c
💬 React with ❤️ for more!
Post #2249
1.38K
- ❤ 3