Definitions
Microsoft Power BI is primarily used for Business ............ and data ..................
Analytics , Visualization
............ .................. combine two or more queries by matching values in specified columns
Merge Queries
Type of data modeling in Power BI that Uses Data Analysis Expressions and similar to Excel formulas______
DAX
What are the first steps to connect to a data table on Wikipedia from Power BI Desktop?
Get Data > Web > Enter Web URL
"Power BI" stands for ?
Power Business Intelligence
DAX stands for ?
Data Analysis Expressions
Which is used to calculate the data in each row______
Calculated Colum
Data transformation feature in Power BI will enable us to do Data ................
Data Cleansing
We use an .............. Function to group by one or more columns
"Aggregate" Function
What file format (extension) is used for Power BI files?
pbix
In Power BI, what is a report?
A collection of visualizations, tables, and matrices organized on one or more pages
What is a way to filter data in Power BI in visualization?
Using a slicer
In the Power Query Editor, you have selected multiple columns. How do you set them all to the Whole Number data type?
Click Data Type Any and select Whole Number.
Which of the following illustrates a Many to One relationship?
1) Many banana trees planted in more than 1 garden
2) One banana tree having many bananas on the tree
3) Many gardens having no banana trees
4) Many banana trees planted in a garden
Many banana trees planted in a garden
................... ........................... takes a column and moves through the values in it to fill any null values in the next rows until it finds a new value. This process continues on a row-by-row basis until there are no more values in that column.
The " fill down" operation
A visual representation of data that provides an at-a-glance view of key metrics
What is a dashboard in Power BI?
Which feature that transforms in the ( Power Query Auditor) and allows you to combine multiple queries into one?
Append Queries
1) if you want to remove all spaces from the beginning and end of every text value in the field , you will use ?
2) f you want to remove all the control characters from the text value. This can include end of lines, tabs etc . you will use ?
1) Trim
2) Clean
One of your data columns includes the city, state, and postal code line of a mailing address. You need to separate the fields so you can access the geospatial elements for a map visualization. What transformation should you apply?
Split column
If there are several delimiters, the first split column is based on the delimiter farthest to the left and the second split column is based on the rest of the characters on its right. What is it called?
Left-most delimiter
A calculation that summarizes data in a table
What is a measure in Power BI?
You have a table, you have a field that gives you the CustomerGroup. You also have different prices applicable to that customer in the Tier 1 Price, Tier 2 Price, and Tier 3 Price fields. your goal is to create a new column with the name Final Price based on the value found in the CustomerGroup field. If the value in the CustomerGroup field is equal to 1, you want to use the value from the Tier 1 Price field; otherwise, you use the value from the Tier 3 Price.
what will you use?
Adding a conditional column
ETL Process in Power Bi is?
Extract: Connect to data Source , Extract Data from
Transform: Data Cleansing and Adding Columns and Fields
Load: Load Transformed Data and Create Reports
You want to access the underlying data for a specific data (Date) point in a visualization. What should you choose?
Expand /Collapse to next level
A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be___________
One to Many