Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureEasy
A data analyst needs to visualize trends in sales data stored in an Azure Synapse Analytics dedicated SQL pool. They want to create interactive dashboards and reports that can be shared across the organization. Which Azure service is the most appropriate tool for this purpose?
- AAzure Stream Analytics
- BAzure Data Factory
- CPower BI
- DAzure Machine Learning
Show answer & explanationAnswer & explanation
Correct answer: C. Power BI
Power BI is Microsoft's leading business intelligence service for creating interactive dashboards and reports, and it integrates seamlessly with Azure data services like Azure Synapse Analytics.
Why the other options are wrong
- A. Azure Stream Analytics is for real-time stream processing, not for creating interactive dashboards from a data warehouse.
- B. Azure Data Factory is for data integration and orchestration, not for data visualization and reporting.
- D. Azure Machine Learning is for building, training, and deploying machine learning models, not for traditional business intelligence reporting.
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 variety of data sources, including Azure services.
- Enables creation of interactive dashboards and reports.
- Supports data modeling, transformation, and visualization.
Memory trick: Power BI gives you the 'power' to 'see' your data.