Power BI & Tableau Exam Questions &
Answers (Grade A+)
What are the parts of Microsoft self-service business intelligence
solution? -
correct answer ✅Microsoft has two parts for Self-Service BI
Microsoft has two parts for Self-Service BI -
correct answer ✅Excel BI Toolkit and Power BI
Excel BI Toolkit -
correct answer ✅It allows users to create an interactive report by
importing data from different sources and model data according to
report requirement.
Power BI -
correct answer ✅It is the online solution that enables you to share
the interactive reports and queries that you have created using the
Excel BI Toolkit.
What is self-service business intelligence? -
correct answer ✅SSBI is an approach to data analytics that enables
business users to filter, segment, and, analyze their data, without
the in-depth technical knowledge in statistical analysis, business
intelligence (BI).
,Power BI & Tableau Exam Questions &
Answers (Grade A+)
SSBI has made it easier for end users to access their data and create
various visuals to get better business insights.
Anybody who has a basic understanding of the data can create
reports to build intuitive and shareable dashboards.
What is Power BI? -
correct answer ✅Power BI is a cloud-based data sharing
environment. Once you have developed reports using Power Query,
Power Pivot and Power View, you can share your insights with your
colleagues. This is where Power BI enters the equation. Power BI,
which technically is an aspect of SharePoint online, lets you load
Excel workbooks into the cloud and share them with a chosen
group of co-workers. Not only that, but your colleagues can interact
with your reports to apply filters and slicers to highlight data. They
are completed by Power BI, a simple way of sharing your analysis
and insights from the Microsoft cloud.
What does the Power BI features allow you to do: -
correct answer ✅Share presentations and queries with your
colleagues.
Update your Excel file from data sources that can be on-site or in
the cloud.
,Power BI & Tableau Exam Questions &
Answers (Grade A+)
Display the output on multiple devices. This includes PCs, tablets,
and HTML 5-enabled mobile devices that use the Power BI app.
Query your data using natural language processing (or Q&A, as it is
known).
What is Power BI Desktop? -
correct answer ✅is a free desktop application that can be installed
right on your own computer. Power BI Desktop works cohesively
with the Power BI service by providing advanced data exploration,
shaping, modeling, and creating report with highly interactive
visualizations. You can save your work to a file or publish your data
and reports right to your Power BI site to share with others.
What data sources can Power BI connect to? -
correct answer ✅Files:
Content Packs:
Connectors
Files: data source in Power BI -
correct answer ✅Data can be imported from Excel (.xlsx, xlxm),
Power BI Desktop files (.pbix) and Comma Separated Value (.csv).
, Power BI & Tableau Exam Questions &
Answers (Grade A+)
Content Packs: data source in Power BI -
correct answer ✅It is a collection of related documents or files
that are stored as a group. In Power BI, there are two types of
content packs, firstly those from services providers like Google
Analytics, Marketo or Salesforce and secondly those created and
shared by other users in your organization.
Connectors data source in Power BI -
correct answer ✅to databases and other datasets such as Azure
SQL Database, and SQL Server Analysis Services, tabular data, etc.
What are Building Blocks in Power BI? -
correct answer ✅Visualizations:
Datasets:
Reports:
Dashboards:
Tiles:
Visualizations: The Building Blocks in Power BI -
correct answer ✅is a visual representation of data.
Answers (Grade A+)
What are the parts of Microsoft self-service business intelligence
solution? -
correct answer ✅Microsoft has two parts for Self-Service BI
Microsoft has two parts for Self-Service BI -
correct answer ✅Excel BI Toolkit and Power BI
Excel BI Toolkit -
correct answer ✅It allows users to create an interactive report by
importing data from different sources and model data according to
report requirement.
Power BI -
correct answer ✅It is the online solution that enables you to share
the interactive reports and queries that you have created using the
Excel BI Toolkit.
What is self-service business intelligence? -
correct answer ✅SSBI is an approach to data analytics that enables
business users to filter, segment, and, analyze their data, without
the in-depth technical knowledge in statistical analysis, business
intelligence (BI).
,Power BI & Tableau Exam Questions &
Answers (Grade A+)
SSBI has made it easier for end users to access their data and create
various visuals to get better business insights.
Anybody who has a basic understanding of the data can create
reports to build intuitive and shareable dashboards.
What is Power BI? -
correct answer ✅Power BI is a cloud-based data sharing
environment. Once you have developed reports using Power Query,
Power Pivot and Power View, you can share your insights with your
colleagues. This is where Power BI enters the equation. Power BI,
which technically is an aspect of SharePoint online, lets you load
Excel workbooks into the cloud and share them with a chosen
group of co-workers. Not only that, but your colleagues can interact
with your reports to apply filters and slicers to highlight data. They
are completed by Power BI, a simple way of sharing your analysis
and insights from the Microsoft cloud.
What does the Power BI features allow you to do: -
correct answer ✅Share presentations and queries with your
colleagues.
Update your Excel file from data sources that can be on-site or in
the cloud.
,Power BI & Tableau Exam Questions &
Answers (Grade A+)
Display the output on multiple devices. This includes PCs, tablets,
and HTML 5-enabled mobile devices that use the Power BI app.
Query your data using natural language processing (or Q&A, as it is
known).
What is Power BI Desktop? -
correct answer ✅is a free desktop application that can be installed
right on your own computer. Power BI Desktop works cohesively
with the Power BI service by providing advanced data exploration,
shaping, modeling, and creating report with highly interactive
visualizations. You can save your work to a file or publish your data
and reports right to your Power BI site to share with others.
What data sources can Power BI connect to? -
correct answer ✅Files:
Content Packs:
Connectors
Files: data source in Power BI -
correct answer ✅Data can be imported from Excel (.xlsx, xlxm),
Power BI Desktop files (.pbix) and Comma Separated Value (.csv).
, Power BI & Tableau Exam Questions &
Answers (Grade A+)
Content Packs: data source in Power BI -
correct answer ✅It is a collection of related documents or files
that are stored as a group. In Power BI, there are two types of
content packs, firstly those from services providers like Google
Analytics, Marketo or Salesforce and secondly those created and
shared by other users in your organization.
Connectors data source in Power BI -
correct answer ✅to databases and other datasets such as Azure
SQL Database, and SQL Server Analysis Services, tabular data, etc.
What are Building Blocks in Power BI? -
correct answer ✅Visualizations:
Datasets:
Reports:
Dashboards:
Tiles:
Visualizations: The Building Blocks in Power BI -
correct answer ✅is a visual representation of data.
