Pre Lunch Power BI

What does BI stand for in Power BI?

• Big Information

• Basic Intelligence

• Business Intelligence

• Business Insight

Name one tool used for data visualization in Power BI.

• Graphs

• Charts

• Maps

• Tables

What is the purpose of Power Query in Power BI?

• Power Query is used for creating visualizations in Power BI

• Power Query is designed for data storage in Power BI

• The purpose of Power Query in Power BI is to transform, clean, and shape data before loading it into the Power BI model.

• Power Query is primarily used for sharing reports in Power BI

How can you create relationships between tables in Power BI?

• Access the Query Editor > Merge tables to establish relationships

• Click on Visualizations tab > Link tables using drag and drop

• Navigate to Modeling tab > Manage Relationships > New > Define relationship by selecting related columns

• Go to Data tab > Create Relationships > Select tables and columns to relate

What is a measure in Power BI?

• A measure in Power BI is a unit of length

• A measure in Power BI is a calculation used for data analysis.

• A measure in Power BI is a type of musical notation

• A measure in Power BI is a cooking utensil

Explain the difference between calculated columns and measures in Power BI.

• Calculated columns are aggregate-level calculations stored in the data model, while measures are row-level calculations not stored in the data model.

• Calculated columns and measures are the same thing in Power BI.

• Calculated columns are row-level calculations stored in the data model, while measures are aggregate-level calculations not stored in the data model.

• Calculated columns are used for text data, while measures are used for numerical data in Power BI.

How can you share Power BI reports with others?

• You can share Power BI reports by engraving them on stone tablets

• You can share Power BI reports by sending them via carrier pigeon

• You can share Power BI reports by publishing them to the Power BI service or exporting them to PDF/PowerPoint.

• You can share Power BI reports by faxing them to recipients

What is the role of DAX in Power BI?

• DAX is used for data visualization in Power BI

• DAX in Power BI is used for creating custom calculations, measures, and aggregations in Power BI Desktop.

• DAX is used for creating animations in Power BI

• DAX is responsible for data storage in Power BI

What is the importance of data modeling in Power BI?

• Data modeling in Power BI is optional and not necessary

• Data modeling in Power BI has no impact on data accuracy

• Data modeling in Power BI is crucial for establishing relationships between data sources, optimizing performance, and ensuring accurate reporting.

• Data modeling in Power BI is only useful for visualizations

How can you schedule data refresh in Power BI Service?

• Manually refresh data every hour

• Use a third-party tool to schedule refresh

• Enable scheduled refresh in dataset settings and set the refresh frequency and time.

• Refresh data only when opening the report