General
Type(s) of data sources is Power BI Desktop able to connect with?
What are local (on-premise) and hosted (cloud-based) sources.
The ETL tool used to shape, clean and transform data in Power BI.
What is Power Query?
How do you get Power BI to separate date data into year, quarter, month, and day?
What is you don't need to do anything, it is automatic.
Formula expression language that can be used in Power BI, also known as a functional language.
What is DAX?
Share dashboard to others in Power BI by specifying
What is the email of the recipient or group in Power BI Service.
The different views in Power BI Desktop
What is: Report View: Users can add visualizations and additional report pages and publish the same on the portal from here.
Data View: Data shaping can be performed through Query Editor tools.
Relationship View: Users can manage relationships between datasets in this view.
The language used in Power Query.
Includes your dashboards, reports, and datasets in PowerBI Service.
What is a Workspace?
The function that gives a difference between 2 dates based on the specified Date part.
What is DATEDIFF?
You want to delete a dataset but the Power BI service will not let you. What is the most likely cause?
What is the dataset is already being used in a published app.
The central table in a star schema.
What is a fact table?
A fact table that stores quantitative information for analysis, which is not normalized in most cases.
Dimension Tables:
It is a table in the star schema which helps you to store attributes and dimensions which describe objects that are stored in a fact table.
Changing data types, filtering rows, choose/remove columns, splitting a column into multiple columns, adding new columns ,etc. are examples of what?
What are common Power Query/Editor Transformations?
Purpose of the 'Get Data' icon.
What is a drop-down menu that appears and it shows all data sources from which data can be ingested. Data can actually be directly ingested from any source including files in Excel, CSV, XML, JSON, PDF, and SharePoint formats and databases such as SQL, Access, SQL Server Analysis Services, Oracle, IBM, MySQL, and much more. Also, Power BI datasets and Power BI data flows are compatible. Data can also be taken in from Azure and other online sources.
A calculating expression which allows calculation on data stored in a new column.
What is a Calculated Column?
The bridge between on-premises data sources and Azure cloud services.
What is a Gateway?
Created between two or more tables based on the cardinality between them.
What are relationships?
Relationships are created and managed using “Manage relationships” option.
Where to view the query that Power BI runs against data sources to import data.
What is Advanced Editor?
Helps you to capture the configured view of a report page
What is a bookmark?
What are MIN, MAX, COUNT, DISTINCTCOUNT, and AVG examples of?
What are DAX functions?
Restricts the data that users view and access based on filters.
What is Row-Level Security?
To configure row-level security, users can define rules and roles within Power BI Desktop and publish them to Power BI Service.
Building Blocks in Power BI
What are: Visualizations: Visualization is a visual representation of data.
Datasets: Dataset is a collection of data that Power BI uses to create its visualizations.
Reports: Report is a collection of visualizations that appear together on one or more pages.
Dashboards: Dashboard is single layer presentation of multiple visualizations.
Tiles: Tile is a single visualization in a report or on a dashboard.
The Applied steps section of the query settings pane.
What is where every transformation that is applied to your query is saved as a step.
When do you use drill-down?
What is when you want to access the underlying data for a specific data point in a visualization.
Used in aggregational calculations such as sum, average, minimum value, maximum value, counts, etc.
What are Measures?
What is Refresh now, or Schedule refresh options?