WorksheetsMastering PowerBI Concepts
Total questions: 20
Worksheet time: 14mins
What is PowerBI used for
App Development
Data Analysis & Business Inteligence
Travel App
Social Media
What data sources can Power BI connect to?
SQL Server
Excel
SharePoint
Databricks
Google Drive
What does ETL stand for?
Extract, Transform, Load
Export, Transform, Load
Encrypt, Transfer, Log
Execute, Test, Launch
Which tool is used for data modeling in Power BI?
Power Query
Pivot Table
Power Pivot
Direct Query
Describe a best practice for data modeling in Power BI?
Use a Snowflake schema
Focus solely on data visualization
Flat file structure for
Use a Star schema design
Explain the role of the Power Query Editor in PowerBI.
Primarily for sharing data
Used for creating visual reports
Used for data transformation and preparation
A tool for coding and scripting
What is DAX used for
Visual
Calculation
Design and colour
Navigation
How can we establish relationships between tables?
Relationship between tables' key
Calculated column
Drag & drop
AI Suggested
What is the process for publishing a report to PowerBI Service?
Export the report as a PDF file.
Use Power BI Desktop to publish the report to Power BI Service.
Create a new report in Power BI Service without using Power BI Desktop.
Share the report via email directly from Power BI Desktop.
How do you share a report with others in PowerBI Service?
Post the report on social media
Email the report as an attachment
Use the 'Share' button in Power BI Service to send the report to others.
Print the report and distribute it physically
What are the benefits of using PowerBI Service for report sharing?
Real-time collaboration, access control, easy embedding and scheduled data refreshes.
Limited offline access
Increased report loading times
No data visualization tools
Is it possible to schedule data refresh in Power BI?
Yes, using the Power BI Service
No, data must be refreshed manually
No, Power BI does not support automatic refreshes
Yes, using Power BI Desktop
Which visual shows trend?
Line Chart
Scatter Plot
Bar Chart
Pie Chart
Which visual compares categories
Pie Chart
Line Chart
Bar Chart
Map
Which visual shows proportion-to-whole?
Which feature allows users to filter data in Power BI reports?
Bookmarks
Slicers
Drillthrough
Data Labels
Type of cardinality which does not require unique values in either table in a relationship
Many-to-Many
Many-to-One
One-to-One
One-to-Many
Tables containing observational or event data values and can contain several repeated values.
Data Model
Dimension Table
Primary key
Fact Table
Which one of the following visuals can be sorted?
Treemap
Bar chart
Filled map
Cards
If you click a tab at the bottom of a report, which of the following filters would apply to every visual you see?
Tab filter
Visual filter
Page filter
Power filter
