WorksheetsPower BI
Total questions: 10
Worksheet time: 5mins
Which three tabs in the Query Editor contain data shaping and transformation tools?
Home, Transform, Add Column
Transform, Load, Add Column
Load, Transform, Analyze
Load, Design, Analyze
What is Power BI used for?
Data Visualization
Data Cleaning
Data Manipulation
Data Extraction
Tables containing observational or event data values and can contain several repeated values.
Data Model
Dimension Table
Primary key
Fact Table
A mature modeling approach which requires modelers to classify their model tables as either dimension or fact.
Snowflake Schema
Galaxy Schema
Star Schema
Star Cluster Schema
What are the three modalities of Power BI designed to let people create, share, and consume business insights in the way that serves them, or their role, most effectively?
Desktop, service, and Mobile apps.
Tiles, visualizations, and dashboards.
Reports, dashboards, and tiles.
Which of the following is TRUE ?
With FREE subscription, you can share your report to all users
DAX is a formula used in Power BI
Power BI Desktop is a software on the cloud
You cannot use logical expression in DAX
Which of the following is the right way to create new columns in Power Query editor?
Create Column from Examples
Create Column based on Condition
Create Column based on Index Number
All answers are correct
A/An ___ is a collection of dashboards and reports built to deliver key metrics to the Power BI consumers in your organization
app
dataflow
capacity
dataset
Which of the following is NOT a building block of Power BI?
Reports
Containers
Datasets
Dataflows
These are containers for dashboards, reports, workbooks, datasets, and dataflows in Power BI
Capacities
Power BI Service
Workspaces
Apps
