Data Governance

Microsoft Announces the General Availability of Azure Synapse Analytics and the Preview of Azure Purview

There was some exciting news from Microsoft today! At a digital conference, Satya Nadella, CEO of Microsoft, announced the general availability of Azure Synapse Analytics and the preview of Azure Purview, Microsoft’s new unified data governance service.

Why are these announcements so important? Because to thrive, businesses need to harness the power of their data.

One of the best ways to harness the power of your data is to remove data silos. While not a new concept, achieving this has been a constant challenge in the history of data and analytics, as many ecosystems continue to be complex and heterogeneous. Organizations must break down all silos to the get the most out  of data and analytics, in a consolidated, secure, and compliant manner. Azure Synapse Analytics and Azure Purview remove silos by creating a unified data analytics and governance service.

Now that we’ve given you an overview of the announcements, let’s break down the details of each Azure service.

What is Azure Synapse Analytics? Azure Synapse Analytics is a limitless analytics service that brings together traditional data warehousing and big data analytics – into one offering! Azure Synapse brings these two worlds together with a centralized experience to ingest, prepare, manage, and serve data for immediate BI and machine learning applications.

Azure Synapse Analytics Highlights

  • New cloud native distributed SQL engine
  • Deep integration with Spark
  • Flexible service query options – Serverless + Dedicated
  • Power BI + ML integration
  • Azure Synapse Link – Enables real-time data analytics with link to your operational database
  • TPC-H benchmark at PB scale
  • Native Row Level Security – This is not possible with Amazon Redshift, Google BigQuery
  • Citizen Data Scientist capabilities with direct ML integration
  • Code Management – Automation, code sync to dev/master branch, and end to end deployment lifecycle
  • Power BI integration from inside the Synapse service
  • Ability to add Power BI reports into Teams for end users

What is Azure Purview? It is critical to enable these capabilities through a comprehensive data governance solution. An organization that does not know where its data is, does not know what its future will be.  Azure Purview is a unified data governance service that helps organizations achieve a complete understanding of their data. Azure Purview empowers users to discover all data across the business, track lineage of data and create a business glossary wherever it is stored: on-premise, across clouds, in SaaS applications, or in Power BI.

Azure Purview Highlights

  • Key important and rich features: Compliance, Catalog and Data Map
  • Sourcing from on-prem, SaaS, and multi-cloud services
  • Data Map: search/browse data by tech/non-tech domain
  • Business glossary
  • No manual building of data dictionary
  • Data scanning by clicking on a button
  • Automated data classification with custom options
  • Schedule for future scanning and classification
  • Easy cloud based data search
  • Data lineage and reporting
  • Free scanning: On-premise SQL Servers, Power BI Service, data sensitivity labeling for O365 E5 customers

The combination of Azure Synapse Analytics and Azure Purview enables organizations to develop the capabilities needed to empower their teams to leverage all data for analytics and data governance, silo-free.

3CloudMicrosoft Announces the General Availability of Azure Synapse Analytics and the Preview of Azure Purview
Read More

An Introduction to Data Governance (Part 1 of 2)

Data security is of utmost importance for all organizations, and can be ensured with proper data governance policies. In an introduction to data governance, there’s so much to cover, so I’ve split this Azure Every Day blog/video into 2 parts. Let’s start with the basics.

Jon BloomAn Introduction to Data Governance (Part 1 of 2)
Read More

Power BI in the Enterprise – A Conversation with Asgeir Gunnarsson

As I continue to explore and develop best practices for managing serious business-scale Power BI solutions, I’m having conversations with recognized community leaders. In November, I chatted with Ásgeir Gunnarsson on the SQL Train ride from Portland to PASS Summit in Seattle. Ásgeir is a data platform MVP and seasoned Business Intelligence expert from Reykjavik, Iceland who works as Chief Consultant for Datheos, a Microsoft-focused BI and Analytics consultancy in Copenhagen. He leads the Icelandic Power BI User Group and PASS Chapter.

Paul TurleyPower BI in the Enterprise – A Conversation with Asgeir Gunnarsson
Read More

Power BI Governance Strategies

Are you a company struggling to keep up with who is accessing your environment, what reports are being created, and how many licenses are needed within Power BI? Is the lack of data governance preventing your organization from reaching its fullest potential?

3CloudPower BI Governance Strategies
Read More

Introduction to Data Governance in Azure SQL DB

Jon B.-2Data Governance has slowly crept into the limelight, and for good reason. With upcoming mandates on Data Privacy, having a Data Governance framework in place will support and fortify your efforts to becoming a Data Driven organization. In a recent webinar, Jon Bloom, shows how you can easily apply Row Level Security and Data Masking to your Azure SQL Database.

Tom WardIntroduction to Data Governance in Azure SQL DB
Read More

The 5 Stages of Cloud Adoption

So, still not in the cloud and the thought of doing so feels like you’re taking a huge jump into unknown waters? We’re seeing more enterprises starting to dip their toe in the water with Microsoft Azure. Microsoft has shown their commitment to where they’re going with their cloud infrastructure and the growth has been tremendous.

3CloudThe 5 Stages of Cloud Adoption
Read More