Introduction To Power Bi
Introduction to Power BI
- 1.
What is one method for creating a visual?
- A.
Drag a field from the Fields list onto the Model view canvas
- B.
Drag a field from the Fields list onto the Report view canvas
- C.
Drag a field from the Fields list onto the Data view canvas
- D.
Drag a field from the Fields list onto the Page Navigation
Correct Answer
B. Drag a field from the Fields list onto the Report view canvasExplanation
One method for creating a visual is to drag a field from the Fields list onto the Report view canvas. This suggests that the Report view canvas is specifically designed for creating visuals and allows users to easily create visual representations of data by dragging and dropping fields onto it.Rate this question:
-
- 2.
How do you get Power BI to separate date data into year, quarter, month, and day?
- A.
Open the Query Editor
- B.
Select the New Parameter button
- C.
Select the New Measure button
- D.
You don't need to do anything, it is automatic
Correct Answer
D. You don't need to do anything, it is automaticExplanation
Power BI automatically separates date data into year, quarter, month, and day without the need for any manual intervention. The software is designed to recognize and categorize date values into these different time periods, allowing users to easily analyze and visualize data based on these dimensions. This automation feature simplifies the process of organizing and aggregating date data, saving time and effort for the user.Rate this question:
-
- 3.
Which of these is false?
- A.
Power BI is a tool for visualizing your data and for storytelling
- B.
Power BI is interactive and you work with dashboards and reports to discover trends and insights.
- C.
Power BI is collaborative - you work from the same data (reports, apps, dashboards) with colleagues to collaborate and share
- D.
Power BI is another name for the reporting tools found in Excel and Microsoft Access
Correct Answer
D. Power BI is another name for the reporting tools found in Excel and Microsoft Access -
- 4.
The number 1 in the figure is:
- A.
Report view, or canvas
- B.
Pages tab
- C.
Ribbon
- D.
Visualizations pane
- E.
Fields pane
Correct Answer
C. RibbonExplanation
The number 1 in the figure refers to the Ribbon. The Ribbon is a graphical control element in the user interface of Microsoft Office applications, including Excel, Word, and PowerPoint. It is located at the top of the application window and contains tabs, groups, and commands that allow users to access various functions and features.Rate this question:
-
- 5.
The number 3 in the figure is:
- A.
Pages tab
- B.
Ribbon
- C.
Fields pane
- D.
Report view, or canvas
- E.
Visualizations pane
Correct Answer
A. Pages tabExplanation
The number 3 in the figure refers to the Pages tab. This tab is used to manage the different pages or sheets in a report or canvas. It allows users to create, edit, and navigate between pages, enabling them to organize and present their data effectively.Rate this question:
-
- 6.
"A collection of data that Power BI uses to create visualizations" is
- A.
Dashboard
- B.
Dataset
- C.
Report
- D.
Tile
- E.
Visualization
Correct Answer
B. DatasetExplanation
In Power BI, a dataset is a collection of data that is imported or connected to Power BI from various sources. This dataset is used as the foundation for creating visualizations, reports, and dashboards. A dashboard is a collection of visuals from different reports, a report is a collection of visuals based on a dataset, a tile is a single visual on a dashboard or report, and a visualization is an individual graphical representation of data.Rate this question:
-
- 7.
" A collection of visuals from a dataset, spanning one or more pages " is
- A.
Dashboard
- B.
Dataset
- C.
Report
- D.
Tile
- E.
Visualization
Correct Answer
C. ReportExplanation
A report is a collection of visuals from a dataset that can span one or more pages. It is a document that presents information and insights derived from the data in a structured format. A report typically includes various visualizations, such as charts, graphs, and tables, to represent the data in a meaningful way. Unlike a dashboard, which provides real-time data and interactive features, a report is usually a static document that is generated periodically to provide a snapshot of the data at a specific point in time.Rate this question:
-
- 8.
" A single-page collection of visuals built from a report " is
- A.
Dashboard
- B.
Dataset
- C.
Report
- D.
Tile
- E.
Visualization
Correct Answer
A. DashboardExplanation
A dashboard is a single-page collection of visuals built from a report. It provides a concise and visual representation of data, allowing users to quickly analyze and understand the information presented. Dashboards often include various visualizations such as charts, graphs, and tables, which are derived from the underlying dataset. By presenting the data in a visually appealing and easily understandable format, dashboards enable users to make informed decisions and gain insights from the data.Rate this question:
-
- 9.
A formula language used for creating transformations in Power BI Desktop main screen is called:
- A.
M
- B.
DAX
- C.
CAC
- D.
S
Correct Answer
B. DAXExplanation
DAX is the formula language used for creating transformations in Power BI Desktop main screen. DAX stands for Data Analysis Expressions and it is a collection of functions, operators, and constants that can be used to define custom formulas in Power BI. It allows users to manipulate and transform data in various ways, such as creating calculated columns and measures, filtering and aggregating data, and performing calculations based on specific conditions. DAX is specifically designed for working with tabular data models and is commonly used in Power BI and Excel Power Pivot.Rate this question:
-
- 10.
A query language used in Power Query and the Power Query Editor for Power BI Desktop is called:
- A.
M
- B.
DAX
- C.
CAC
- D.
S
Correct Answer
A. MExplanation
The correct answer is M. In Power Query and the Power Query Editor for Power BI Desktop, the query language used is called M. This language is used to transform and manipulate data, allowing users to extract, transform, and load data from various sources into their Power BI reports. M provides a wide range of functions and capabilities for data cleansing, shaping, and modeling, making it a powerful tool for data preparation and analysis.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jun 13, 2024Quiz Edited by
ProProfs Editorial Team -
Apr 24, 2020Quiz Created by
Engricardoguerre
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes