PBI Transformations/ ETL
The extract fuction in Power Query Editor works on which data type?
Text
This default Power BI visualisation shows values as progressively decreasing proportions amounting to 100% in total.
Funnel Chart
Calculate the number of people who left the organization in selected time period.
946
This software solution acts as a bridge to provide quick and secure data transfer between data that isn't in the cloud and several Microsoft cloud services.
Gateway
Which update bought the fuctionality to format the Data Labels using Conditional Formatting
1.July 2022
2.Aug 2022
3.Sep 2022
August 2022
These functions are the equivalent of Join and Union All respectively in SQL.
Merge and Append
This chart shows a running total as values are added or subtracted. It's useful for understanding how an initial value is affected by a series of positive and negative values.
Waterfall Chart
Show the department with most hires in selected time period using Card Visual
XYZT309
______ are a self-service, cloud-based, data preparation technology. ______ enable customers to ingest, transform, and load data into Microsoft Dataverse environments, Power BI workspaces, or your organization's Azure Data Lake Storage account.
Dataflows
This preview feature can allow users to dynamically change the measures or dimensions being analyzed within a report.
Field parameter
______ give you the flexibility to dynamically change the output of your queries depending on their value
Query Parameter
This default visualization helps you quickly summarize visuals and reports by providing relevant out-of-the-box insights that are customizable.
Smart Narratives
Calculate the total number of active employees.
3948
This feature help you understand the impact of your dashboards and reports. When you use this feature, you discover how those dashboards and reports are being utilized by end users.
Usage Metrics
You can now select rows in your _____ visual to cross highlight and cross filter other visuals in your report.
Multi Row card
________ is the ability for a Power Query's query to generate a single query statement to retrieve and transform source data. The Power Query mashup engine strives to achieve _______ whenever possible for reasons of efficiency.
Query Folding
This custom visual offers features such as the ability to view data related to the task and the hierarchy of data categories and to sort the data based on any data point contained in the task. The visual can be used by project managers to monitor projects as well as by users to view individual tasks and progress.
Gantt chart
Show the top 5 business units ranked by highest Voluntary terminations
Technology
Catalog
Category
Test Fashion Brand
Supply Chain Management
Organizations with Power BI Premium or Power BI Embedded can take advantage of this feature to speed up reports associated with a dataset. This feature instructs the Premium/Embedded capacity to use its local caching service to maintain query results, avoiding having the underlying data source compute those results.
Query Caching
With these update users got the ability to dynamically alter the m query parameters with which default visual.
Slicer