Modern Analytics Academy - Acquisition and Storage

Data Acquisition & Storage explores the role of data storage and integrating data into our applications and reporting systems. Relational systems, data ingestion, real-time/hot path/cold path factors all play a role in architecting an analytical solution.

In Data Acquisition and Storage we’ll look at the nuances of how to integrate source systems to move data into Azure for long term retention and analysis. Technologies include Azure Data Lake, Azure Cosmos DB, Azure Event Hubs, and Azure Synapse Analytics. more »

“Vignette” Sessions

Our ongoing Modern Analytics Academy series, which we’ve called “vignettes”, dive into topical areas related to analytics. For a complete list of sessions, visit the vignette page. The following vignettes are related to acquisition and storage:

In this vignette video, solution architect Armando Marrero looks at building out a data warehouse in Microsoft Fabric based off our real-time analytics lab (https://aka.ms/lakehouselab) by building a pipeline to do data ingestion from the KQL database, and aggregate the data into a simple dimensional model. more »
Interested in learning more about the evolution of data warehousing, data meshes, and data lakehouse? In this Partner Showcase, we talk with Dremio about their data lakehouse platform, and how it can accelerate time to insight. more »
This deployment accelerator demonstrates how to use Azure Synapse Analytics with the extensive family of Azure Data Services to build a modern data platform that's capable of handling the most common data challenges in an organization. more »
In this Microsoft Partner Showcase, we're joined by Shaun Van Staden from Starburst. Shaun gives us insight into data meshes, their typical challenges, and demos how Starburst can accelerate development of analytical workloads. more »
Azure Synapse Link for Dataverse •
Real time analytics is important in today's digital world and that's where Synapse Link for Dataverse can help connect Microsoft Dataverse to Azure Synapse Analytics for accelerate time to insight. In this session, we will explore how Synapse Link for Dataverse works, and how it can power near real time analytics on your business application data. more »
Azure Synapse Link for SQL •
Real time analytics is important in today’s digital world. If your transactional data is stored in SQL, Synapse Link for SQL can help turn the transactional data into near real time analytical data. In this session, we will learn how Synapse Link for SQL works and how to get started. more »
Real time analytics is important in today’s digital world and that’s where Synapse Link for Cosmos DB comes into the picture. In this session, we will learn how Synapse Link for Cosmos DB helps to deliver near real time analytics on your transactional data. more »
Synapse Data Explorer •
This session will look at Azure Synapse Data Explorer. Azure Synapse Data Explorer provides customers with an interactive query experience to unlock insights from log and telemetry data. To complement existing SQL and Apache Spark analytics runtime engines, the Data Explorer analytics runtime is optimized for efficient log analytics using powerful indexing technology to automatically index free-text and semi-structured data commonly found in telemetry data. more »
Mike Shelton explores the basics of schema design in a SQL Pool (SQL DW). What is a star schema and why do we use it? more »