1. What does the DAX function SUM do?
Explanation: SUM adds up numeric values in a column.
Report for correction2. What is the default visual in Power BI?
Explanation: Table is the default visual used to display raw data in Power BI.
Report for correction3. What is drillthrough used for?
Explanation: Drillthrough lets users go from summary to detailed data views.
Report for correction4. Which visual shows KPI progress?
Explanation: KPI visuals show performance against targets.
Report for correction5. What feature allows user-level data security?
Explanation: Row-Level Security (RLS) restricts data visibility based on user roles.
Report for correction6. What is the first step in Power BI data prep?
Explanation: The first step is to bring in data from various sources.
Report for correction7. What does the DAX function COUNTROWS do?
Explanation: COUNTROWS returns the number of rows in a table.
Report for correction8. What is the purpose of bookmarks?
Explanation: Bookmarks save the current view, filters, and selections in a report.
Report for correction9. What is the Power BI service?
Explanation: Power BI service is the online platform for hosting and sharing reports.
Report for correction10. What is a calculated column?
Explanation: A calculated column is created using DAX based on existing data.
Report for correction11. Which license is needed to share reports?
Explanation: A Power BI Pro license is needed to share reports with others.
Report for correction12. What is used to refresh data?
Explanation: The Refresh button updates reports with new data.
Report for correction13. What visual is best for comparing parts of a whole?
Explanation: Pie charts show how different parts make up a whole.
Report for correction14. What is Power BI used for?
Explanation: Power BI is used for analyzing data and creating interactive reports.
Report for correction15. What type of relationship is default in Power BI?
Explanation: Power BI defaults to a one-to-many relationship when possible.
Report for correction16. What is a relationship in Power BI?
Explanation: Relationships link tables using common fields for data modeling.
Report for correction17. What does Power Query do?
Explanation: Power Query is used to connect, transform, and clean data.
Report for correction18. Which pane shows tables and fields?
Explanation: The Fields pane lists all tables and columns available for use.
Report for correction19. Which language is used in Power BI for measures?
Explanation: DAX (Data Analysis Expressions) is used for creating measures and calculations.
Report for correction20. What is a slicer used for?
Explanation: Slicers help users filter data across visuals.
Report for correction21. Which visual shows trends over time?
Explanation: Line charts are best for showing data trends over time.
Report for correction22. Which view is used to design reports?
Explanation: Report view is used to build and design visuals in Power BI.
Report for correction23. Which is a common file type in Power BI?
Explanation: Power BI Desktop files are saved in .pbix format.
Report for correction24. What is the desktop version called?
Explanation: Power BI Desktop is the free tool used for report building on PCs.
Report for correction25. Power BI is a product of which company?
Explanation: Power BI is developed and maintained by Microsoft.
Report for correction