Data Preparation
Integrate all your data with Azure Data Factory - a fully managed, serverless data integration service. Visually integrate data sources with 100s of built-in, maintenance-free connectors at no added cost. Easily construct ETL and ELT processes code-free in an intuitive environment or write your own code. Then deliver integrated data to Azure Synapse Analytics to unlock business insights.
Storage & Processing
Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated options—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, transform, manage, and serve data for immediate BI and machine learning needs.
Semantic Layer
Power BI allows for creating a conceptual data model that contains all the relationships between the different data entities in the organization. It supports both multidimensional and tabular data modeling.
In other words, it represents all the business intelligence or rules in the model. Calculations are embedded in the model using either MDX or DAX languages.
Power BI allows for data ingestion from multiple data sources.
Visualaisation
Power BI is a unified self-service and enterprise analytics solution. It lets you visualize your data and share insights across your organization and embed them in your app or website. Azure Analytics and Power BI together provide insights at scale, allowing you to develop the data-driven culture needed to thrive in a fast-paced, competitive environment.
Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights.