Mastering PowerBI Concepts

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