Font size
WorksheetsPower Query & Power Bi Essential
Total questions: 30
Worksheet time: 25mins
Which of these is false?
Power BI is a tool for visualizing your data and for storytelling
Power BI is interactive and you work with dashboards and reports to discover trends and insights
Power BI is collaborative - you work from the same data (reports, apps, dashboards) with colleagues to collaborate and share
Power BI is another name for the reporting tools found in Excel and Microsoft Access
Number 1 in the figure is:
Report view, or canvas
Page tab
Ribbon
Visualizations pane
A collection of data that Power BI uses to create visualizations is?
Dashboard
Dataset
Report
Tile
Which feature in Power BI allows users to ask questions about data using natural language?
Power Query Editor
Power Automate
Power Apps
Q&A (Natural Language Q&A)
In Power BI, the BI stands for
Business Intelligence
Business Intellectual
Board Intelligence
Board Intellectual
________ is used to compare the values based on the share of the area occupied
Bar chart
Pie chart
Slicer
Card
_________ will be used to display single value of a parameter
Bar chart
Pie Chart
Card
Slicer
The dashboards are created in _________ window of Power BI
Report view
Data view
Model view
None of these
All the dashboard creating options in report view available in which pane?
Filter pane
Visualization pane
Data pane
None of these
Business Intelligence works like your company's personal data ______.
Detective
Suspect
Culprit
Accomplice
If you produce reports you need to download the desktop software?
True
False
What type of businesses can benefit from Power BI?
Large enterprises
Medium businesses
Small businesses
Business of all sizes
1. What is the main purpose of Power Query in Excel?
To create pivot tables
To get and transform data from various sources
To perform macros and VBA automation
To generate random data
2. Which of the following file types can be imported using Power Query? Choose multiple answers
Website
CSV
Excel files
3. How do you install Power Query in Excel?
It is an external software you download
It is part of the Excel ribbon in newer versions
It is included in Microsoft Word
It requires a browser extension
5. Which of the following is not a transformation type in Power Query?
Number
Date/Time
Macro
Text
6. What is one key benefit of using Power Query?
It replaces the need for Excel formulas
It simplifies data cleaning and transformation
It eliminates the use of Excel sheets
It provides graphic design tools
10. Which feature allows you to bring together data from multiple files in a folder?
Append Queries
Data Model
Combine Files
VLOOKUP
What is a life-changing feature of Excel that can save a ton of time?
Pivot Tables
Power Query
VLOOKUP
Conditional Formatting
Which tab on the ribbon in Excel contains the Power Query buttons?
Review
Insert
Home
Data
What is the initial step to remove specific columns in Power Query Editor?
Select the specified columns
Right-click and delete
Use the delete key on the keyboard
Filter and sort
What does Power Query do when removing blank rows from a dataset?
Deletes rows in the CSV file
Deletes columns in memory
Deletes rows in memory (Power Query)
Deletes columns in the CSV file
What feature of Power Query can be used to combine multiple CSV files into one table?
Combine and Transform Data
Split Column
Unpivot Columns
Merge
Please list down the functions or formulae you have been using in Excel. e.g., VLOOKUP, SUM, AVERAGE, etc.
Your name and position at your organization?
How do you feel today?
What is the primary tool used for data transformation within Power BI Desktop?
DAX Studio
Power Query Editor
Power BI Service
Report View
What does the acronym DAX stand for in the context of Power BI?
Data Access eXchange
Data Aggregation eXtension
Data Access eXchange
Data Analysis Expressions
In Power BI, which type of relationship is generally considered the most efficient and commonly used for connecting fact tables to dimension tables?
One-to-many relationship
Many-to-many relationship
One-to-one relationship
Bi-directional relationship
Referring to the picture given, what is the name of this view mode in Power BI Desktop?
Dashboard view
Report view
Charts view
Analytics view
