Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureEasy
A data analyst needs to create interactive dashboards and reports from sales data stored in an Azure Synapse Analytics dedicated SQL pool. The dashboards must allow business users to filter, drill down, and explore data with minimal latency. Which Azure service is best suited for building these interactive reports and dashboards?
- AAzure Databricks
- BAzure Stream Analytics
- CPower BI
- DAzure Data Factory
Show answer & explanationAnswer & explanation
Correct answer: C. Power BI
Power BI is a business intelligence service that allows users to create interactive visualizations and dashboards, connecting directly to various data sources like Azure Synapse Analytics dedicated SQL pool.
Why the other options are wrong
- A. Azure Databricks is for data engineering and machine learning, not primarily for end-user interactive reporting.
- B. Azure Stream Analytics is for real-time stream processing, not for building interactive dashboards.
- D. Azure Data Factory is for data integration and orchestration, not for data visualization.
Power BI
A business intelligence service by Microsoft 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 a wide range of data sources.
- Enables creation of interactive reports and dashboards.
- Supports data exploration, filtering, and drill-down.
Memory trick: Power BI makes data shine.