Data Integration

• Data integration is the process of bringing data from different/multiple sources together to provide a single cohesive view.
• The process of combining data from multiple sources in order to support data analysis and other data-driven activities.
• Data Integration may involve combining data from different databases, file formats, or systems in order to create an unified view of the data
• The premise of data integration is to make data more freely available, easier to consume & process by systems and users

Data Warehouse

• A data warehouse is a type of database used for storing and managing large volumes of structured data for fast querying and analysis
• Data warehouse is optimized for reporting and data analysis rather than transactional processing
• A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools

Big Data Analytics

Analytics & Analytics Platform

• Analytics refers to the process of analyzing data to extract insights, trends, and patterns that can be used to inform business decisions. The process of breaking down and examining data in order to gain insights and understanding
• An analytics platform is a software or system that is used to collect, store, process, and analyze data. The purpose of an analytics platform is to provide insights and make data-driven decisions by turning raw data into actionable information

Big Data

• Big data refers to extremely large and complex sets of data that are difficult to process and analyze using traditional methods
• Big data refers to data that has following properties (3Vs):
  • Volume: huge data
  • Velocity: comes at high speed
  • Variety: different types of data

Big Data Analytics

• Big data analytics is the process of examining, cleaning, transforming, and modeling large sets of data to uncover hidden patterns, unknown correlations, and other insights
• The goal of big data analytics is to extract valuable insights from this large and complex data to drive business decisions

What is Azure Synapse?

• Azure Synapse is a limitless analytics service that brings together Data Integration, Enterprise Data Warehousing, and Big Data Analytics
• A cloud-based data analytics platform
• A fully-managed analytics service that enables organizations to ingest, prepare, manage, and serve data for business intelligence and machine learning needs

Notes:

• Azure Synapse Analytics is simply known as “Azure Synapse”
• Azure Synapse provides a unified experience for big data integration, data integration, and analytics by combining the power of Azure Data Factory, Azure Data Lake Storage, and Azure SQL Data Warehouse