top of page

Microsoft Power BI

This assessment is designed to test your knowledge and understanding of Microsoft Power BI, a business intelligence tool that enables users to connect, analyze, and visualize data from various sources. The assessment includes 20 multiple choice questions covering topics such as data modeling, visualization, formulas, and features of Power BI Desktop and Power BI Premium. The questions are intended to provide a pre-assessment of your knowledge level and help you identify areas where you may need to improve your skills.

1. What is Microsoft Power BI?

A. A social media platform

B. A music streaming service

C. A self-service analytics tool

D. A gaming console

Your answer:

2. What is the Power BI Desktop?

A. A web application

B. A mobile app

C. A Windows application

D. A macOS application

Your answer:

3. How do you connect to a data source in Power BI?

A. By selecting the ""Connect"" button in the Modeling tab

B. By selecting the "Get Data" button in the Home tab

C. By selecting the "Visualizations" button in the Home tab

D. By selecting the "Queries" button in the Modeling tab

Your answer:

4. What is a data model in Power BI?

A. A collection of visualizations

B. A collection of data sources

C. A collection of tables, columns, and relationships

D. A collection of formulas

Your answer:

5. What is a measure in Power BI?

A. A visual representation of data

B. A graphical element used to enhance a report

C. A calculation used to summarize or aggregate data

D. A filter used to hide or exclude data

Your answer:

6. What is a visual in Power BI?

A. A formula used to manipulate data

B. A data source used to connect to external systems

C. A graphical representation of data

D. A data model used to structure data

Your answer:

7. What is the difference between a slicer and a filter in Power BI?

A. A slicer is used to hide or exclude data, while a filter is used to select specific values

B. A slicer is used to select specific values, while a filter is used to hide or exclude data

C. A slicer is used to change the visualization type, while a filter is used to change the data source

D. A slicer and a filter are the same thing in Power BI

Your answer:

8. How do you create a calculated column in Power BI?

A. By selecting the "New Visual" button in the Modeling tab

B. By selecting the "New Column" button in the Modeling tab

C. By selecting the "New Measure" button in the Modeling tab

D. By selecting the "New Table" button in the Modeling tab

Your answer:

9. What is DAX in Power BI?

A. A formula language used to create calculated columns, measures, and tables

B. A visualization type used to display data

C. A data source used to connect to external systems

D. A tool used to create and manage dashboards

Your answer:

10. How do you create a measure in Power BI?

A. By selecting the "New Visual" button in the Modeling tab

B. By selecting the "New Column" button in the Modeling tab

C. By selecting the "New Measure" button in the Modeling tab

D. By selecting the "New Table" button in the Modeling tab

Your answer:

Related Courses

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

GRC-101: An Analytical Journey with Microsoft Power BI

RM3,300.00

ILT/VILT

Empower team members to discover insights hidden in your data with Microsoft Power BI courses.

 

Microsoft Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of Microsoft Power Platform.

 

Gain expertise to amplify your insights and the value of your data with GRC's custom-developed Power BI course.

 

Training Duration: 3 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • SBL-Khas Claimable

 

Download Course Outline

 

Looking for function and formula for Power BI, may visit Conquering DAX 2019 or may check out the entire Power Platform training series and blogs at Honing Your Skills On Microsoft Power Platform.

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

GRC-101FT: An Analytical Journey with Microsoft Power BI [Fastrack]

RM2,700.00

ILT/VILT

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of the Microsoft Power Platform.

 

 

Training Duration: 2 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • SBL-Khas Claimable

 

Download Course Outline

 

Looking for function and formula for Power BI, may visit Conquering DAX 2019 [Fastrack] or may check out the entire series and blogs at Honing Your Skills On Microsoft Power Platform

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

PL-300T00: Microsoft Power BI Data Analyst

RM2,800.00

ILT/VILT