WorksheetsQuiz sur Power BI _Session 01
Total questions: 12
Worksheet time: 9mins
ASSAL, a data analyst at a retail company, is tasked with improving sales performance. She needs to define business intelligence (BI) and explain its relevance in modern data analysis to her team during a meeting. How can she effectively convey the importance of BI in making data-driven decisions?
Which of the following are the core components of Power BI? (Select all that apply)
Power BI Desktop
Power BI Service
Power BI Mobile
What types of files can be imported into Power BI?
Excel files
CSV files
Text files
SQL databases
Flat files
Which of the following can be found in both "Power Excel" and Power BI?
Query editing tools
DAX measures
Data modeling tools
All of these can be found in both "Power Excel" and Power BI
Which Power BI option should you turn off to manually build all table relationships from scratch?
Automatched
Autodetect new relationships after data is loaded
Parallel table loading
Auto Table/Time
Which set correctly lists the three core views you can switch between in Power BI Desktop?
D) Canvas, Schema, Transform
Report, Query, Dashboard
Dataset, Report, Model
Report, Data, Model
Canvas, Schema, Transform
n a typical Power BI workflow, which step happens after data is loaded but before you start building reports?
Table relationships are formed
User-level permissions are established
Parameters and roles are defined
Visual themes are applied
Which of the following tasks is NOT possible directly in Power BI Desktop?
Connect to data sources with more than 1,000,000 rows
Create relational data models
Build interactive reports and dashboards
Collaborate with other users in real-time
As ASSAL is preparing to create a Power BI Desktop report using data from an external source, what is the first recommended step he should take?
Create visualizations.
Publish the report to Power BI Service.
Connect to the data source.
Apply filters at the report level.
In Power BI Desktop, what is the role of the Power Query Editor?
Create relationships between tables.
Transform and clean the data.
Define DAX measures.
Design the user interface of the report.
What is the default file format in which you save a Power BI Desktop project?
.xlsx
.csv
.pbix
.pbit
ASSAL is working on a data analysis project and needs to clean and transform the data before loading it into her reporting tool. What tool should she use?
A graph creation software
A SQL database query tool
An extraction, transformation, and loading (ETL) tool
A project management tool
