Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureEasy
A data analyst needs to create interactive dashboards and reports based on data stored in an Azure Synapse Analytics dedicated SQL pool. The dashboards should allow business users to filter data, drill down into details, and refresh automatically to show the latest information. Which Azure service is explicitly designed for data visualization and business intelligence in this context?
- APower BI
- BAzure Machine Learning
- CAzure Data Factory
- DAzure Monitor
Show answer & explanationAnswer & explanation
Correct answer: A. Power BI
Power BI is a business intelligence tool from Microsoft that allows users to connect to various data sources, including Azure Synapse Analytics, to create interactive reports and dashboards. It is designed for data visualization, exploration, and sharing insights with business users.
Why the other options are wrong
- B. Azure Machine Learning is for building, training, and deploying machine learning models, not for general business intelligence dashboards.
- C. Azure Data Factory is for data integration and orchestration, not for data visualization or interactive dashboards.
- D. Azure Monitor is for collecting, analyzing, and acting on telemetry from Azure and on-premises environments, primarily for operational monitoring.
Power BI
A business intelligence service 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, drill-down, and automatic refreshes.
Memory trick: Power BI gives you the power to see your data.