Construindo um Data Warehouse Moderno com Azure Synapse Analytics

Nessa sessão você irá aprender a mais nova e promissora ferramenta da Microsoft para construção de um Data Warehouse Moderno fim a fim. O Azure Synapse Analytics é a mais nova proposta da Microsoft para competir com o BigQuery e indo mais além para construção fim a fim de pipeline de dados. Embarque nessa sessão para aprender a como reduzir o tempo de criação e melhorar seus pipelines de forma exponencial.

Transcript

4. SIDNEY OLIVEIRA CIRQUEIRA BIG DATA
5. Microsoft Learn Student Ambassador | Microsoft Certified in Data & AI | Big Data & Machine Learning Student | Data Engineer at CI&T, currently focused on data engineering and artificial intelligence solutions in the Microsoft Azure environment. Mini-Biografia https: github.com/sidneyocirqueira/azure-synapse-analytics /sidneycirqueira /sidneyoliveiracirqueira/
6. PATROCINADORES_ Agradecemos a confiança e o investimento realizado pelos Patrocinadores do MVPConf LATAM 2020. Sem a participação deles o evento não aconteceria. Nosso muito obrigado!!!
7. Lar de Idosos Nossa Senhora da Conceição Aracaju - SE Retiro dos Idosos Universina Carrera Machado Santo Ângelo - RS Associação Comunitária Fênix Jacareí - SP Rede Feminina de Combate ao Câncer Três Lagoas - MS Associação de Pais e Amigos dos Excepcionais – APAE de Farroupilha Farroupilha - RS Lar da Criança Ninho de Paz São Paulo - SP Abrigo Bom Pastor Cornélio Procópio - PR BENEFICIADAS POR VOCÊ_ Estas foram as entidades beneficiadas com a doação que você realizou no ato da sua inscrição no MVPConf LATAM 2020. Sem a sua participação o evento não aconteceria e não poderíamos impactar a vida de tantas pessoas. Nosso muito obrigado!!!
8. WHAT IS?
9. Big data Experimentation Fast exploration Semi-structured Data science OR Relational data Proven security & privacy Dependable performance Structured Business analytics Data lake Data warehouse Businesses are forced to maintain two critical, yet independent analytics systems
10. Azure meets these challenges with a single service to provide limitless analytics Ease of use Fast exploration Quick to start Proven security Airtight privacy Dependable performance Welcome to limitless Data warehousing & big data analytics—all in one service
11. _ Limitless analytics service that brings together enterprise data warehousing and Big Data analytics with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.
12. Azure Synapse Analytics Snowflake Standard Amazon Redshift Google BigQuery per byte $33 $103 $48 …$564 94% less TPC-H benchmark comparison Price-performance | Lower is better * GigaOm TPC-H benchmark report, January 2019, “GigaOm report: Data Warehouse in the Cloud Benchmark With the best price-performance in the business Up to 14x faster and costs 94% less than other cloud providers A breakthrough in the cost of enterprise analytics
13. Building a Modern Data Warehouse Unified experience Analytics runtimes On-premises data Cloud data SaaS data Streaming data Azure Data Factory Azure Databricks (Prep-only) Azure Data Lake Storage Code-free data ingestion from 85+ data integration connectors Leader in the Magic Quadrant for Business Intelligence and Analytics Platforms* Up to 14x faster and costs 94% less than other cloud providers High performance data lake available in all 54 Azure regions Power BI Ingest & Prep Store Model & Serve Visualize Azure SQL Data Warehouse
14. Limitless analytics service with unmatched time to insight Azure Synapse Unified experience Azure Synapse Studio Integration Management Monitoring Security Analytics runtimes SQL Azure Data Lake Storage Azure Machine Learning On-premises data Cloud data SaaS data Streaming data Power BI
15. Azure Synapse Analytics features
16. Azure Synapse Link
17. DEMO
18. • Synapse Analytics(workspaces): https://docs.microsoft.com/en-us/azure/synapse-analytics/overview-what-is • Synapse Analytics(SQL DW): https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/ • Modern Data Warehouse: https://azure.microsoft.com/en-in/solutions/architecture/modern-data-warehouse/ • MPP Architecture: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel- processing-mpp-architecture • Product: https://azure.microsoft.com/en-us/services/synapse-analytics/ • Synapse Link: https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link • Benchmark Cloud DW: https://azure.microsoft.com/en-us/services/synapse-analytics/compare/ • Synapse Analytics Toolkit: https://azure.microsoft.com/en-us/resources/azure-synapse-analytics-toolkit/ Azure Synapse Link Azure Synapse Link References