Microsoft 365 FundamentalsDescribe core Microsoft 365 services and conceptsMedium

A small business uses Microsoft 365 and wants to gain insights into their sales data, customer feedback, and website traffic to make informed business decisions. They need a tool that can connect to various data sources, visualize data, and create interactive reports and dashboards. Which Microsoft 365 component provides this capability?

  1. AMicrosoft Power BI
  2. BMicrosoft Lists
  3. CMicrosoft Forms
  4. DMicrosoft Visio
Show answer & explanation

Correct answer: A. Microsoft Power BI

Microsoft Power BI is a business intelligence service that enables users to connect to various data sources, create interactive data visualizations, and build dashboards for informed decision-making.

Why the other options are wrong

  • B. Microsoft Lists is for tracking information and organizing work, not for deep data analysis and interactive dashboards.
  • C. Microsoft Forms is used for creating surveys and quizzes, not for advanced data analysis and visualization.
  • D. Microsoft Visio is a diagramming and vector graphics application, not a business intelligence tool.

Microsoft Power BI

A business intelligence platform that provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

  • Connects to hundreds of data sources.
  • Enables creation of interactive reports and dashboards.
  • Supports data modeling and transformation.

Memory trick: Power BI gives you 'Power' to see your 'Business Intelligence'.

More Describe core Microsoft 365 services and concepts questions