DA 100 - Combined Data QUESTIONS &
ANSWERS 100% CORRECT
What is a Workspace? - with answers:Workspace = Sandbox
Workspaces offer the following benefits:
○Focused collaboration efforts. You can use workspaces to house reports and dashboards for
use by multiple teams.
○Ability to share and present reports and dashboards in a single environment.
○Assurance that the highest level of security is maintained by controlling who can access
datasets, reports, and dashboards.
What can the Admin workspace role do? - with answers:Add/remove other users
Publish, update, and/or share an app in a workspace
Create, edit, delete, and publish reports and content in a workspace
View and interact with reports and dashboards in a workspace
Configure data refreshes
What can the Member workspace role do? - with answers:Can complete all tasks that are
associated with admins but can't add or remove users
Cannot delete the workspace
Cannot update the metadata about the workspace
What can the Contributor workspace role do? - with answers:Cannot add or remove users
Cannot publish, update, or edit an app in a workspace unless given this ability by
admins/members
Can create, update, and publish content and reports within a workspace
Can schedule data refreshes
What can the Viewer workspace role do? - with answers:Cannot add or remove users
,Can only view a report or dashboard in a workspace
Can read data that is stored in workspace dataflows
What is an App? - with answers:App = Content Distribution
○Workspace is for collaboration, App is for distribution
You can add additional content such as SharePoint sites, PowerPoint and Forms
Think of it as a reporting pack
Currently only 1 app per workspace but this will probably be updated soon
What are usage metrics for? - with answers:Shows various metrics on the usage of your report,
including no. of views and how those people viewed the report
New Usage Metrics Report view can show metrics for all reports
You used to have to do this manually be downloading the .pbix and editing the power query
code
What workspace is needed for a deployment pipeline? - with answers:Premium Workspace
Feature
What is the development stage in the deployment pipeline? - with answers:The location in which
dashboard developers or data modelers can build new content with other developers. This stage
is first in the deployment pipeline.
What is the Test stage in the deployment pipeline? - with answers:Where a small group of users
and user acceptance testers can see and review new reports, provide feedback, and test the
reports with larger datasets for bugs and data inconsistencies before it goes into production.
What is the Production stage in the deployment pipeline? - with answers:Where an expansive
user audience can use tested reports that are reliable and accurate. This stage is the final one of
the deployment pipeline.
What is the data lineage view? - with answers:Shows the different data sources data sets reports
and dashboards and how they are linked together
, Also gives info about when datasets are last refreshed
What are dynamic reports in Power BI? - with answers:Dynamic reports are reports in which the
data can be changed by a developer according to user specifications.
One Report can be used for multiple purposes.
When are "What If Parameters" used and what are they? - with answers:Use what-if parameters
to run scenarios and scenario-type analysis on your data.
In its simplest form, you can use it as a factor to multiply forecast data by to show potential
growth.
You need to be careful as your data has to be set up in a specific way to get value out of this
feature.
Why are On Premise Gateways used for? - with answers:Connect to on-prem databases
○e.g. legacy systems
This will most likely be set up by IT, not the PwC team, but you need to know that it's available
and to pass on to IT how to configure it.
What are Power BI scheduled refreshes? - with answers:Data refreshes while you're asleep!
Only works for data in the cloud or data connected using the gateway.
Can't schedule refreshed for local excel files.
○Well, you can but it's not ideal and there are better options
What is Incremental refresh in Power BI? and why is it useful? - with answers:Incremental
refresh only pulls in the latest data or data that has changed since the last reload.
○E.g. latest sales vs HR changes
Quicker, more reliable, reduced consumption
What are the 2 ways of promoting a dataset> - with answers:Promotion, Certification
ANSWERS 100% CORRECT
What is a Workspace? - with answers:Workspace = Sandbox
Workspaces offer the following benefits:
○Focused collaboration efforts. You can use workspaces to house reports and dashboards for
use by multiple teams.
○Ability to share and present reports and dashboards in a single environment.
○Assurance that the highest level of security is maintained by controlling who can access
datasets, reports, and dashboards.
What can the Admin workspace role do? - with answers:Add/remove other users
Publish, update, and/or share an app in a workspace
Create, edit, delete, and publish reports and content in a workspace
View and interact with reports and dashboards in a workspace
Configure data refreshes
What can the Member workspace role do? - with answers:Can complete all tasks that are
associated with admins but can't add or remove users
Cannot delete the workspace
Cannot update the metadata about the workspace
What can the Contributor workspace role do? - with answers:Cannot add or remove users
Cannot publish, update, or edit an app in a workspace unless given this ability by
admins/members
Can create, update, and publish content and reports within a workspace
Can schedule data refreshes
What can the Viewer workspace role do? - with answers:Cannot add or remove users
,Can only view a report or dashboard in a workspace
Can read data that is stored in workspace dataflows
What is an App? - with answers:App = Content Distribution
○Workspace is for collaboration, App is for distribution
You can add additional content such as SharePoint sites, PowerPoint and Forms
Think of it as a reporting pack
Currently only 1 app per workspace but this will probably be updated soon
What are usage metrics for? - with answers:Shows various metrics on the usage of your report,
including no. of views and how those people viewed the report
New Usage Metrics Report view can show metrics for all reports
You used to have to do this manually be downloading the .pbix and editing the power query
code
What workspace is needed for a deployment pipeline? - with answers:Premium Workspace
Feature
What is the development stage in the deployment pipeline? - with answers:The location in which
dashboard developers or data modelers can build new content with other developers. This stage
is first in the deployment pipeline.
What is the Test stage in the deployment pipeline? - with answers:Where a small group of users
and user acceptance testers can see and review new reports, provide feedback, and test the
reports with larger datasets for bugs and data inconsistencies before it goes into production.
What is the Production stage in the deployment pipeline? - with answers:Where an expansive
user audience can use tested reports that are reliable and accurate. This stage is the final one of
the deployment pipeline.
What is the data lineage view? - with answers:Shows the different data sources data sets reports
and dashboards and how they are linked together
, Also gives info about when datasets are last refreshed
What are dynamic reports in Power BI? - with answers:Dynamic reports are reports in which the
data can be changed by a developer according to user specifications.
One Report can be used for multiple purposes.
When are "What If Parameters" used and what are they? - with answers:Use what-if parameters
to run scenarios and scenario-type analysis on your data.
In its simplest form, you can use it as a factor to multiply forecast data by to show potential
growth.
You need to be careful as your data has to be set up in a specific way to get value out of this
feature.
Why are On Premise Gateways used for? - with answers:Connect to on-prem databases
○e.g. legacy systems
This will most likely be set up by IT, not the PwC team, but you need to know that it's available
and to pass on to IT how to configure it.
What are Power BI scheduled refreshes? - with answers:Data refreshes while you're asleep!
Only works for data in the cloud or data connected using the gateway.
Can't schedule refreshed for local excel files.
○Well, you can but it's not ideal and there are better options
What is Incremental refresh in Power BI? and why is it useful? - with answers:Incremental
refresh only pulls in the latest data or data that has changed since the last reload.
○E.g. latest sales vs HR changes
Quicker, more reliable, reduced consumption
What are the 2 ways of promoting a dataset> - with answers:Promotion, Certification
