尊敬的 微信汇率:1円 ≈ 0.046239 元 支付宝汇率:1円 ≈ 0.04633元 [退出登录]
SlideShare a Scribd company logo
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com
DATA GOVERNANCE IN
A CLOUD BI WORLD
Clint Vallandingham
Sr. Manager BI & Analytics www.visualbi.com
Chandler Stevens
VP, Microsoft BI & Analytics
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 3
ABOUT VISUAL BI
All-in-One Partner for End-to-End BI & Analytics Needs
Visual BI Solutions is a leading All-in-One Business Intelligence (BI) enablement firm specializing in BI &
Analytics services, solutions, trainings and products. We have proven expertise in enabling BI & Analytics
for 100+ world’s leading brands. We can help you achieve competitive advantage by effectively managing
the Plan - Build - Run spectrum for BI.
Trusted by the largest companies world-wide
Trusted by
the industry
Integration and Partnership with
SAP and Microsoft is our forte
CONSULTING SERVICES
• Strategy
• Architecture Implementation
• Training
• Managed Services
• Visualization
• Cloud Migrations
ANALYTICS SOLUTIONS
• Dashboards by LOB
• Advanced Analytics
• Big Data Solutions
TRAINING
• SAP Business Objects Training
§ SAP Lumira Discovery (2 Days)
§ SAP Lumira Designer (3 Days )
§ SAP Web Intelligence (2 Days)
§ SAP Analysis for Office (2 Days)
• SAP Analytics Cloud Training
• Microsoft Power BI Training
SOFTWARE PRODUCTS
• VBI View – One Portal for All BI Content
• Product Extensions for SAP Lumira / SAP Design Studio
§ Visual BI Extensions (VBX Suite)
§ Document Management and Change Control
• Value Driver Tree (VDT) for Planning and Simulations
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 4
ABOUT VISUAL BI
Customer Portfolio (Software, Services, Training)
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 5
Data Governance in a Cloud BI World
WEBINAR AGENDA
Introduction1
Data quality and the modern data warehouse2
Establishing data integrity and accountability4
Conclusion
Ensuring compliance with Azure governance3
Development lifecycle with Azure DevOps6
Accountability of the data steward5
7
BI Vantage8
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 6
Introduction
Data Governance in a Cloud BI World
What is Data Governance?
Wikipedia defines data governance as, “the people, processes, and
information technology required to create a consistent and proper
handling of an organization's data across the business enterprise.
This definition holds just as true when utilizing cloud based resources
and technologies.
1. People
The data steward plays a critical role in the success of a data governance program. Ownership and accountability must be assigned and agreed upon prior to
releasing data and analytics to an enterprise.
2. Process
Data governance requires a well-defined process or workflow where data is stored or ingested and transformations are applied. Additions or modifications to
this process must go through change control. Security should be a consideration at every step of this process.
3. Technology
The technology must meet the standards defined in the data governance program. The technology chosen should help with the implementation considerations
such as security and availability.
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 7
Why Data Governance?
A good data governance program can have many benefits. We are going
to focus on a few key elements and the role of Cloud BI in each of these
areas:
Quality
Data quality must be established and maintained throughout the
lifecycle of the data.
Compliance
Good data governance practices help ensure not only internal
compliance but also from external entities such as GDPR.
Integrity
A combination of security and change control can help ensure the
integrity of the data from source to destination.
Accountability
If and when the data comes into questions it is important that data
stewards have validated and approved the data and analytics.
Introduction
Data Governance in a Cloud BI World
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 8
Cloud Considerations
When choosing cloud based resources for a data services solution it is important to ensure those solution are complaint and can even help
when implementing a data governance program. In this presentation we will focus on Microsoft’s Azure platform and demonstrate how to
implement data governance procedures using Azure.
Policies should be drafted and followed for each of these key areas:
Data Lifecycle – Organizational policy should classify data and define when that data should be removed from the cloud based data
services. This helps control cost and reduces risk.
Security – Policy should define access and accessibility at the data set level and this policy must be followed across cloud based resources.
Logging & Metadata – Cloud based services should provide adequate logging to ensure integrity of the data services solution. The service
should also provide relevant metadata of the data set as to the source, type and owner.
Transformation – Policy should require all transformations are documented and approved by the data steward. Transformations may occur
at different stages in the data lifecycle. It is critical that all are documented and approved.
Introduction
Data Governance in a Cloud BI World
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 9
QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY
Data Quality and The Modern Data Warehouse
Data Governance in a Cloud BI World
System Record
Establish authoritative source
for data elements
Single Source of Truth
Master Data Management
Critical data elements
MDM Software
Semantic Modeling
Business Terminology
Self-service BI & Analytics
Azure Analysis Services
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 10
QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY
Ensuring Compliance with Azure Governance
Data Governance in a Cloud BI World
Firewall
Protection
Traditional On-Premise
Protection
Establishing
Identity
Azure Active Directory
Group Based
Security
Managing access at Scale
Hierarchies
Policy and
Blueprints
Tracking Compliance
Managing Policies
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 11
Establishing Data Integrity and Accountability
Data Governance in a Cloud BI World
QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY
Service Level Agreements
Commitment to availability and quality
Penalties
Data orchestration
Data movement and transformation
Azure Data Factory
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 12
Accountability of The Data Steward
Data Governance in a Cloud BI World
QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY
Ownership
Ensure data quality
Communication
Monitoring
Retroactive & Proactive
Process Improvement
13
Continuous integration (CI)
Continuous delivery (CD)
Continuous deployment
with CI/CD
Development Lifecycle with Azure DevOps
Data Governance in a Cloud BI World
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 14
Azure Modern Data Warehouse and Advanced Analytics
Data Governance in a Cloud BI World
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 15
Data Governance Takeaways
⇢ Cloud BI presents many data governance challenges over traditional on-premise
solutions
⇢ Azure offers a rich suite of tools to help overcome these challenges
⇢ Data quality, compliance, integrity and accountability can all be accomplished with a
strong data governance program
⇢ The data steward plays a crucial role in the success of the data governance program
Conclusion
Data Governance in a Cloud BI World
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 16
Introducing BI Vantage
Modern Data Warehousing Offering
§ Establish a foundation for delivering data
analytics to your business decision makers
§ Provides a low TCO solution coupled with a quick
and iterative implementation window
§ Allows your organization to right-size the
implementation to address business
requirements
§ Enables a “pay as you go” scalable solution that
grows with the needs of your business over time
§ Brings together the industry leading Visual BI
data warehousing experience coupled with the
Microsoft Azure data platform
Fast Time
to Value
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 17
Q&A
© 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 18
www.visualbi.com
THANK YOU! gopal
@visua
lbi.com
Chandler Stevens
for your Time
chandlers@visualbi.com
www.visualbi.com
VP, Microsoft BI & Analytics
Clint Vallandingham
clintv@visualbi.com
Sr. Manager BI & Analytics

More Related Content

What's hot

Webinar - ValQ for Production Planning and Control
Webinar - ValQ for Production Planning and ControlWebinar - ValQ for Production Planning and Control
Webinar - ValQ for Production Planning and Control
Visual_BI
 
xViz Advanced Custom Visuals for Microsoft Power BI - What's New?
xViz Advanced Custom Visuals for Microsoft Power BI - What's New?xViz Advanced Custom Visuals for Microsoft Power BI - What's New?
xViz Advanced Custom Visuals for Microsoft Power BI - What's New?
Visual_BI
 
Emerging BI trends 2019
Emerging BI trends 2019Emerging BI trends 2019
Emerging BI trends 2019
Visual_BI
 
Impactful Financial Reporting using Microsoft Power BI - Webinar
Impactful Financial Reporting using Microsoft Power BI - WebinarImpactful Financial Reporting using Microsoft Power BI - Webinar
Impactful Financial Reporting using Microsoft Power BI - Webinar
Visual_BI
 
Data science in Azure
Data science in AzureData science in Azure
Data science in Azure
Visual_BI
 
On-the-fly Material Requirement Planning using Microsoft Power BI
On-the-fly Material Requirement Planning using Microsoft Power BIOn-the-fly Material Requirement Planning using Microsoft Power BI
On-the-fly Material Requirement Planning using Microsoft Power BI
Visual_BI
 
Traditional BI VS Self Service BI
Traditional BI VS Self Service BITraditional BI VS Self Service BI
Traditional BI VS Self Service BI
Visual_BI
 
Why Customers need to upgrade to SAP Lumira 2.2?
Why Customers need to upgrade to SAP Lumira 2.2?Why Customers need to upgrade to SAP Lumira 2.2?
Why Customers need to upgrade to SAP Lumira 2.2?
Visual_BI
 
Life after Xcelsius
Life after XcelsiusLife after Xcelsius
Life after Xcelsius
Visual_BI
 
Expert recommendations for picking the right SAP BusinessObjects BI solution ...
Expert recommendations for picking the right SAP BusinessObjects BI solution ...Expert recommendations for picking the right SAP BusinessObjects BI solution ...
Expert recommendations for picking the right SAP BusinessObjects BI solution ...
SAP Analytics
 
#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira
#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira
#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira
SAP Analytics
 
The Power of Collective Insight with SAP BI
The Power of Collective Insight with SAP BIThe Power of Collective Insight with SAP BI
The Power of Collective Insight with SAP BI
Waldemar Adams
 
Realize the value of SAP BusinessObjects BI 4.1
Realize the value of SAP BusinessObjects BI 4.1Realize the value of SAP BusinessObjects BI 4.1
Realize the value of SAP BusinessObjects BI 4.1
SAP Analytics
 
[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...
[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...
[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...
JK Tech
 
Siebel crm strategy and roadmap ()
Siebel crm strategy and roadmap ()Siebel crm strategy and roadmap ()
Siebel crm strategy and roadmap ()
crm2life
 
Agile BI: How to Deliver More Value in Less Time
Agile BI: How to Deliver More Value in Less TimeAgile BI: How to Deliver More Value in Less Time
Agile BI: How to Deliver More Value in Less Time
Perficient, Inc.
 
e-Zest BI services
e-Zest BI servicese-Zest BI services
e-Zest BI services
Sumit Kittur
 
M|18 DBS Bank’s Journey with MariaDB
M|18 DBS Bank’s Journey with MariaDBM|18 DBS Bank’s Journey with MariaDB
M|18 DBS Bank’s Journey with MariaDB
MariaDB plc
 
Making the Most of Power BI with SQL Server 2014 and Azure
Making the Most of Power BI with SQL Server 2014 and AzureMaking the Most of Power BI with SQL Server 2014 and Azure
Making the Most of Power BI with SQL Server 2014 and Azure
Perficient, Inc.
 
[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud
[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud
[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud
Oracle Korea
 

What's hot (20)

Webinar - ValQ for Production Planning and Control
Webinar - ValQ for Production Planning and ControlWebinar - ValQ for Production Planning and Control
Webinar - ValQ for Production Planning and Control
 
xViz Advanced Custom Visuals for Microsoft Power BI - What's New?
xViz Advanced Custom Visuals for Microsoft Power BI - What's New?xViz Advanced Custom Visuals for Microsoft Power BI - What's New?
xViz Advanced Custom Visuals for Microsoft Power BI - What's New?
 
Emerging BI trends 2019
Emerging BI trends 2019Emerging BI trends 2019
Emerging BI trends 2019
 
Impactful Financial Reporting using Microsoft Power BI - Webinar
Impactful Financial Reporting using Microsoft Power BI - WebinarImpactful Financial Reporting using Microsoft Power BI - Webinar
Impactful Financial Reporting using Microsoft Power BI - Webinar
 
Data science in Azure
Data science in AzureData science in Azure
Data science in Azure
 
On-the-fly Material Requirement Planning using Microsoft Power BI
On-the-fly Material Requirement Planning using Microsoft Power BIOn-the-fly Material Requirement Planning using Microsoft Power BI
On-the-fly Material Requirement Planning using Microsoft Power BI
 
Traditional BI VS Self Service BI
Traditional BI VS Self Service BITraditional BI VS Self Service BI
Traditional BI VS Self Service BI
 
Why Customers need to upgrade to SAP Lumira 2.2?
Why Customers need to upgrade to SAP Lumira 2.2?Why Customers need to upgrade to SAP Lumira 2.2?
Why Customers need to upgrade to SAP Lumira 2.2?
 
Life after Xcelsius
Life after XcelsiusLife after Xcelsius
Life after Xcelsius
 
Expert recommendations for picking the right SAP BusinessObjects BI solution ...
Expert recommendations for picking the right SAP BusinessObjects BI solution ...Expert recommendations for picking the right SAP BusinessObjects BI solution ...
Expert recommendations for picking the right SAP BusinessObjects BI solution ...
 
#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira
#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira
#askSAP Analytics Innovation Community Call: Self-Service BI and SAP Lumira
 
The Power of Collective Insight with SAP BI
The Power of Collective Insight with SAP BIThe Power of Collective Insight with SAP BI
The Power of Collective Insight with SAP BI
 
Realize the value of SAP BusinessObjects BI 4.1
Realize the value of SAP BusinessObjects BI 4.1Realize the value of SAP BusinessObjects BI 4.1
Realize the value of SAP BusinessObjects BI 4.1
 
[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...
[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...
[Webinar] - Adopt QAD & Progress DBA Global Shared Services to Deliver Cost O...
 
Siebel crm strategy and roadmap ()
Siebel crm strategy and roadmap ()Siebel crm strategy and roadmap ()
Siebel crm strategy and roadmap ()
 
Agile BI: How to Deliver More Value in Less Time
Agile BI: How to Deliver More Value in Less TimeAgile BI: How to Deliver More Value in Less Time
Agile BI: How to Deliver More Value in Less Time
 
e-Zest BI services
e-Zest BI servicese-Zest BI services
e-Zest BI services
 
M|18 DBS Bank’s Journey with MariaDB
M|18 DBS Bank’s Journey with MariaDBM|18 DBS Bank’s Journey with MariaDB
M|18 DBS Bank’s Journey with MariaDB
 
Making the Most of Power BI with SQL Server 2014 and Azure
Making the Most of Power BI with SQL Server 2014 and AzureMaking the Most of Power BI with SQL Server 2014 and Azure
Making the Most of Power BI with SQL Server 2014 and Azure
 
[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud
[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud
[2015 Oracle Cloud Summit] 1. Oracle Keynote_Modern Business in the Cloud
 

Similar to Data governance in a Cloud BI world

O365Con18 - Power BI Governance - Folker Visser
O365Con18 - Power BI Governance - Folker VisserO365Con18 - Power BI Governance - Folker Visser
O365Con18 - Power BI Governance - Folker Visser
NCCOMMS
 
Forging an Analytics Center of Excellence
Forging an Analytics Center of ExcellenceForging an Analytics Center of Excellence
Forging an Analytics Center of Excellence
Lewandog, Inc,
 
Azure advanced analytics for SAP customers
Azure advanced analytics for SAP customersAzure advanced analytics for SAP customers
Azure advanced analytics for SAP customers
Visual_BI
 
Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...
Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...
Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...
DataStax
 
Modernizing Integration with Data Virtualization
Modernizing Integration with Data VirtualizationModernizing Integration with Data Virtualization
Modernizing Integration with Data Virtualization
Denodo
 
Sabre: Mastering a strong foundation for operational excellence and enhanced ...
Sabre: Mastering a strong foundation for operational excellence and enhanced ...Sabre: Mastering a strong foundation for operational excellence and enhanced ...
Sabre: Mastering a strong foundation for operational excellence and enhanced ...
Orchestra Networks
 
Capgemini Leap Data Transformation Framework with Cloudera
Capgemini Leap Data Transformation Framework with ClouderaCapgemini Leap Data Transformation Framework with Cloudera
Capgemini Leap Data Transformation Framework with Cloudera
Capgemini
 
Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...
Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...
Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...
Precisely
 
DAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the Same
DAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the SameDAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the Same
DAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the Same
DATAVERSITY
 
Top Data Analytics Services | Data Analytics | Codetru
Top Data Analytics Services | Data Analytics | CodetruTop Data Analytics Services | Data Analytics | Codetru
Top Data Analytics Services | Data Analytics | Codetru
CODETRU Software Solutions
 
Data Architecture Strategies: Data Architecture for Digital Transformation
Data Architecture Strategies: Data Architecture for Digital TransformationData Architecture Strategies: Data Architecture for Digital Transformation
Data Architecture Strategies: Data Architecture for Digital Transformation
DATAVERSITY
 
Is your big data journey stalling? Take the Leap with Capgemini and Cloudera
Is your big data journey stalling? Take the Leap with Capgemini and ClouderaIs your big data journey stalling? Take the Leap with Capgemini and Cloudera
Is your big data journey stalling? Take the Leap with Capgemini and Cloudera
Cloudera, Inc.
 
Accelerating Cognitive Business with Hybrid Cloud
Accelerating Cognitive Business with Hybrid CloudAccelerating Cognitive Business with Hybrid Cloud
Accelerating Cognitive Business with Hybrid Cloud
Denny Muktar
 
[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...
[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...
[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...
DataScienceConferenc1
 
The Future of Digital Marketing and Advertising: 2023 Predictions
The Future of Digital Marketing and Advertising: 2023 PredictionsThe Future of Digital Marketing and Advertising: 2023 Predictions
The Future of Digital Marketing and Advertising: 2023 Predictions
SG Analytics
 
451 Research + NuoDB: What It Means to be a Container-Native SQL Database
451 Research + NuoDB: What It Means to be a Container-Native SQL Database451 Research + NuoDB: What It Means to be a Container-Native SQL Database
451 Research + NuoDB: What It Means to be a Container-Native SQL Database
NuoDB
 
Microsoft Dynamics - SA Technologies Capability Overview
Microsoft Dynamics - SA Technologies Capability OverviewMicrosoft Dynamics - SA Technologies Capability Overview
Microsoft Dynamics - SA Technologies Capability Overview
RajTalukdar2
 
Where the Warehouse Ends: A New Age of Information Access
Where the Warehouse Ends: A New Age of Information AccessWhere the Warehouse Ends: A New Age of Information Access
Where the Warehouse Ends: A New Age of Information Access
Inside Analysis
 
DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?
DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?
DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?
DATAVERSITY
 
By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...
By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...
By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...
IngridBuenaventura
 

Similar to Data governance in a Cloud BI world (20)

O365Con18 - Power BI Governance - Folker Visser
O365Con18 - Power BI Governance - Folker VisserO365Con18 - Power BI Governance - Folker Visser
O365Con18 - Power BI Governance - Folker Visser
 
Forging an Analytics Center of Excellence
Forging an Analytics Center of ExcellenceForging an Analytics Center of Excellence
Forging an Analytics Center of Excellence
 
Azure advanced analytics for SAP customers
Azure advanced analytics for SAP customersAzure advanced analytics for SAP customers
Azure advanced analytics for SAP customers
 
Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...
Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...
Webinar: Building a Multi-Cloud Strategy with Data Autonomy featuring 451 Res...
 
Modernizing Integration with Data Virtualization
Modernizing Integration with Data VirtualizationModernizing Integration with Data Virtualization
Modernizing Integration with Data Virtualization
 
Sabre: Mastering a strong foundation for operational excellence and enhanced ...
Sabre: Mastering a strong foundation for operational excellence and enhanced ...Sabre: Mastering a strong foundation for operational excellence and enhanced ...
Sabre: Mastering a strong foundation for operational excellence and enhanced ...
 
Capgemini Leap Data Transformation Framework with Cloudera
Capgemini Leap Data Transformation Framework with ClouderaCapgemini Leap Data Transformation Framework with Cloudera
Capgemini Leap Data Transformation Framework with Cloudera
 
Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...
Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...
Looking to the Future: Embracing the Cloud for a More Modern Data Quality App...
 
DAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the Same
DAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the SameDAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the Same
DAS Slides: Cloud-Based Data Warehousing – What’s New and What Stays the Same
 
Top Data Analytics Services | Data Analytics | Codetru
Top Data Analytics Services | Data Analytics | CodetruTop Data Analytics Services | Data Analytics | Codetru
Top Data Analytics Services | Data Analytics | Codetru
 
Data Architecture Strategies: Data Architecture for Digital Transformation
Data Architecture Strategies: Data Architecture for Digital TransformationData Architecture Strategies: Data Architecture for Digital Transformation
Data Architecture Strategies: Data Architecture for Digital Transformation
 
Is your big data journey stalling? Take the Leap with Capgemini and Cloudera
Is your big data journey stalling? Take the Leap with Capgemini and ClouderaIs your big data journey stalling? Take the Leap with Capgemini and Cloudera
Is your big data journey stalling? Take the Leap with Capgemini and Cloudera
 
Accelerating Cognitive Business with Hybrid Cloud
Accelerating Cognitive Business with Hybrid CloudAccelerating Cognitive Business with Hybrid Cloud
Accelerating Cognitive Business with Hybrid Cloud
 
[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...
[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...
[DSC Adria 23] Thomas Miebach A modern, business focused data strategy with C...
 
The Future of Digital Marketing and Advertising: 2023 Predictions
The Future of Digital Marketing and Advertising: 2023 PredictionsThe Future of Digital Marketing and Advertising: 2023 Predictions
The Future of Digital Marketing and Advertising: 2023 Predictions
 
451 Research + NuoDB: What It Means to be a Container-Native SQL Database
451 Research + NuoDB: What It Means to be a Container-Native SQL Database451 Research + NuoDB: What It Means to be a Container-Native SQL Database
451 Research + NuoDB: What It Means to be a Container-Native SQL Database
 
Microsoft Dynamics - SA Technologies Capability Overview
Microsoft Dynamics - SA Technologies Capability OverviewMicrosoft Dynamics - SA Technologies Capability Overview
Microsoft Dynamics - SA Technologies Capability Overview
 
Where the Warehouse Ends: A New Age of Information Access
Where the Warehouse Ends: A New Age of Information AccessWhere the Warehouse Ends: A New Age of Information Access
Where the Warehouse Ends: A New Age of Information Access
 
DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?
DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?
DAS Slides: Emerging Trends in Data Architecture — What’s the Next Big Thing?
 
By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...
By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...
By Thoughtworks | Building data as a product: The key to unlocking Data Mesh'...
 

Recently uploaded

06-18-2024-Princeton Meetup-Introduction to Milvus
06-18-2024-Princeton Meetup-Introduction to Milvus06-18-2024-Princeton Meetup-Introduction to Milvus
06-18-2024-Princeton Meetup-Introduction to Milvus
Timothy Spann
 
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
hanshkumar9870
 
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
Douglas Day
 
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts ServicePune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
vashimk775
 
Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...
Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...
Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...
mparmparousiskostas
 
Interview Methods - Marital and Family Therapy and Counselling - Psychology S...
Interview Methods - Marital and Family Therapy and Counselling - Psychology S...Interview Methods - Marital and Family Therapy and Counselling - Psychology S...
Interview Methods - Marital and Family Therapy and Counselling - Psychology S...
PsychoTech Services
 
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service LucknowCall Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
hiju9823
 
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
Call Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call GirlCall Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call Girl
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
sapna sharmap11
 
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
Rebecca Bilbro
 
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
Call Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call GirlCall Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call Girl
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
sapna sharmap11
 
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
9gr6pty
 
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
PsychoTech Services
 
Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In BangaloreBangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
yashusingh54876
 
Do People Really Know Their Fertility Intentions? Correspondence between Sel...
Do People Really Know Their Fertility Intentions?  Correspondence between Sel...Do People Really Know Their Fertility Intentions?  Correspondence between Sel...
Do People Really Know Their Fertility Intentions? Correspondence between Sel...
Xiao Xu
 
Health care analysis using sentimental analysis
Health care analysis using sentimental analysisHealth care analysis using sentimental analysis
Health care analysis using sentimental analysis
krishnasrigannavarap
 
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
mona lisa $A12
 
Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)
GeorgiiSteshenko
 
MySQL Notes For Professionals sttudy.pdf
MySQL Notes For Professionals sttudy.pdfMySQL Notes For Professionals sttudy.pdf
MySQL Notes For Professionals sttudy.pdf
Ananta Patil
 
Startup Grind Princeton 18 June 2024 - AI Advancement
Startup Grind Princeton 18 June 2024 - AI AdvancementStartup Grind Princeton 18 June 2024 - AI Advancement
Startup Grind Princeton 18 June 2024 - AI Advancement
Timothy Spann
 
🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...
🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...
🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...
shivangimorya083
 

Recently uploaded (20)

06-18-2024-Princeton Meetup-Introduction to Milvus
06-18-2024-Princeton Meetup-Introduction to Milvus06-18-2024-Princeton Meetup-Introduction to Milvus
06-18-2024-Princeton Meetup-Introduction to Milvus
 
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
Mumbai Call Girls service 9920874524 Call Girl service in Mumbai Mumbai Call ...
 
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
202406 - Cape Town Snowflake User Group - LLM & RAG.pdf
 
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts ServicePune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
Pune Call Girls <BOOK> 😍 Call Girl Pune Escorts Service
 
Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...
Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...
Optimizing Feldera: Integrating Advanced UDFs and Enhanced SQL Functionality ...
 
Interview Methods - Marital and Family Therapy and Counselling - Psychology S...
Interview Methods - Marital and Family Therapy and Counselling - Psychology S...Interview Methods - Marital and Family Therapy and Counselling - Psychology S...
Interview Methods - Marital and Family Therapy and Counselling - Psychology S...
 
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service LucknowCall Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
Call Girls Lucknow 0000000000 Independent Call Girl Service Lucknow
 
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
Call Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call GirlCall Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call Girl
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
 
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
PyData London 2024: Mistakes were made (Dr. Rebecca Bilbro)
 
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
Call Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call GirlCall Girls Hyderabad  (india) ☎️ +91-7426014248 Hyderabad  Call Girl
Call Girls Hyderabad (india) ☎️ +91-7426014248 Hyderabad Call Girl
 
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
一比一原版(uob毕业证书)伯明翰大学毕业证如何办理
 
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
Essential Skills for Family Assessment - Marital and Family Therapy and Couns...
 
Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In BangaloreBangalore Call Girls  ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
Bangalore Call Girls ♠ 9079923931 ♠ Beautiful Call Girls In Bangalore
 
Do People Really Know Their Fertility Intentions? Correspondence between Sel...
Do People Really Know Their Fertility Intentions?  Correspondence between Sel...Do People Really Know Their Fertility Intentions?  Correspondence between Sel...
Do People Really Know Their Fertility Intentions? Correspondence between Sel...
 
Health care analysis using sentimental analysis
Health care analysis using sentimental analysisHealth care analysis using sentimental analysis
Health care analysis using sentimental analysis
 
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
Delhi Call Girls Karol Bagh 👉 9711199012 👈 unlimited short high profile full ...
 
Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)Telemetry Solution for Gaming (AWS Summit'24)
Telemetry Solution for Gaming (AWS Summit'24)
 
MySQL Notes For Professionals sttudy.pdf
MySQL Notes For Professionals sttudy.pdfMySQL Notes For Professionals sttudy.pdf
MySQL Notes For Professionals sttudy.pdf
 
Startup Grind Princeton 18 June 2024 - AI Advancement
Startup Grind Princeton 18 June 2024 - AI AdvancementStartup Grind Princeton 18 June 2024 - AI Advancement
Startup Grind Princeton 18 June 2024 - AI Advancement
 
🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...
🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...
🔥Mature Women / Aunty Call Girl Chennai 💯Call Us 🔝 8094342248 🔝💃Top Class Cal...
 

Data governance in a Cloud BI world

  • 1. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com DATA GOVERNANCE IN A CLOUD BI WORLD Clint Vallandingham Sr. Manager BI & Analytics www.visualbi.com Chandler Stevens VP, Microsoft BI & Analytics
  • 2. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 3 ABOUT VISUAL BI All-in-One Partner for End-to-End BI & Analytics Needs Visual BI Solutions is a leading All-in-One Business Intelligence (BI) enablement firm specializing in BI & Analytics services, solutions, trainings and products. We have proven expertise in enabling BI & Analytics for 100+ world’s leading brands. We can help you achieve competitive advantage by effectively managing the Plan - Build - Run spectrum for BI. Trusted by the largest companies world-wide Trusted by the industry Integration and Partnership with SAP and Microsoft is our forte CONSULTING SERVICES • Strategy • Architecture Implementation • Training • Managed Services • Visualization • Cloud Migrations ANALYTICS SOLUTIONS • Dashboards by LOB • Advanced Analytics • Big Data Solutions TRAINING • SAP Business Objects Training § SAP Lumira Discovery (2 Days) § SAP Lumira Designer (3 Days ) § SAP Web Intelligence (2 Days) § SAP Analysis for Office (2 Days) • SAP Analytics Cloud Training • Microsoft Power BI Training SOFTWARE PRODUCTS • VBI View – One Portal for All BI Content • Product Extensions for SAP Lumira / SAP Design Studio § Visual BI Extensions (VBX Suite) § Document Management and Change Control • Value Driver Tree (VDT) for Planning and Simulations
  • 3. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 4 ABOUT VISUAL BI Customer Portfolio (Software, Services, Training)
  • 4. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 5 Data Governance in a Cloud BI World WEBINAR AGENDA Introduction1 Data quality and the modern data warehouse2 Establishing data integrity and accountability4 Conclusion Ensuring compliance with Azure governance3 Development lifecycle with Azure DevOps6 Accountability of the data steward5 7 BI Vantage8
  • 5. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 6 Introduction Data Governance in a Cloud BI World What is Data Governance? Wikipedia defines data governance as, “the people, processes, and information technology required to create a consistent and proper handling of an organization's data across the business enterprise. This definition holds just as true when utilizing cloud based resources and technologies. 1. People The data steward plays a critical role in the success of a data governance program. Ownership and accountability must be assigned and agreed upon prior to releasing data and analytics to an enterprise. 2. Process Data governance requires a well-defined process or workflow where data is stored or ingested and transformations are applied. Additions or modifications to this process must go through change control. Security should be a consideration at every step of this process. 3. Technology The technology must meet the standards defined in the data governance program. The technology chosen should help with the implementation considerations such as security and availability.
  • 6. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 7 Why Data Governance? A good data governance program can have many benefits. We are going to focus on a few key elements and the role of Cloud BI in each of these areas: Quality Data quality must be established and maintained throughout the lifecycle of the data. Compliance Good data governance practices help ensure not only internal compliance but also from external entities such as GDPR. Integrity A combination of security and change control can help ensure the integrity of the data from source to destination. Accountability If and when the data comes into questions it is important that data stewards have validated and approved the data and analytics. Introduction Data Governance in a Cloud BI World
  • 7. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 8 Cloud Considerations When choosing cloud based resources for a data services solution it is important to ensure those solution are complaint and can even help when implementing a data governance program. In this presentation we will focus on Microsoft’s Azure platform and demonstrate how to implement data governance procedures using Azure. Policies should be drafted and followed for each of these key areas: Data Lifecycle – Organizational policy should classify data and define when that data should be removed from the cloud based data services. This helps control cost and reduces risk. Security – Policy should define access and accessibility at the data set level and this policy must be followed across cloud based resources. Logging & Metadata – Cloud based services should provide adequate logging to ensure integrity of the data services solution. The service should also provide relevant metadata of the data set as to the source, type and owner. Transformation – Policy should require all transformations are documented and approved by the data steward. Transformations may occur at different stages in the data lifecycle. It is critical that all are documented and approved. Introduction Data Governance in a Cloud BI World
  • 8. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 9 QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY Data Quality and The Modern Data Warehouse Data Governance in a Cloud BI World System Record Establish authoritative source for data elements Single Source of Truth Master Data Management Critical data elements MDM Software Semantic Modeling Business Terminology Self-service BI & Analytics Azure Analysis Services
  • 9. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 10 QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY Ensuring Compliance with Azure Governance Data Governance in a Cloud BI World Firewall Protection Traditional On-Premise Protection Establishing Identity Azure Active Directory Group Based Security Managing access at Scale Hierarchies Policy and Blueprints Tracking Compliance Managing Policies
  • 10. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 11 Establishing Data Integrity and Accountability Data Governance in a Cloud BI World QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY Service Level Agreements Commitment to availability and quality Penalties Data orchestration Data movement and transformation Azure Data Factory
  • 11. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 12 Accountability of The Data Steward Data Governance in a Cloud BI World QUALITY COMPLIANCE INTEGRITY ACCOUNTABILITY Ownership Ensure data quality Communication Monitoring Retroactive & Proactive Process Improvement
  • 12. 13 Continuous integration (CI) Continuous delivery (CD) Continuous deployment with CI/CD Development Lifecycle with Azure DevOps Data Governance in a Cloud BI World
  • 13. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 14 Azure Modern Data Warehouse and Advanced Analytics Data Governance in a Cloud BI World
  • 14. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 15 Data Governance Takeaways ⇢ Cloud BI presents many data governance challenges over traditional on-premise solutions ⇢ Azure offers a rich suite of tools to help overcome these challenges ⇢ Data quality, compliance, integrity and accountability can all be accomplished with a strong data governance program ⇢ The data steward plays a crucial role in the success of the data governance program Conclusion Data Governance in a Cloud BI World
  • 15. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 16 Introducing BI Vantage Modern Data Warehousing Offering § Establish a foundation for delivering data analytics to your business decision makers § Provides a low TCO solution coupled with a quick and iterative implementation window § Allows your organization to right-size the implementation to address business requirements § Enables a “pay as you go” scalable solution that grows with the needs of your business over time § Brings together the industry leading Visual BI data warehousing experience coupled with the Microsoft Azure data platform Fast Time to Value
  • 16. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 17 Q&A
  • 17. © 2018 Visual BI Solutions, Inc. All rights reserved. www.visualbi.com 18 www.visualbi.com THANK YOU! gopal @visua lbi.com Chandler Stevens for your Time chandlers@visualbi.com www.visualbi.com VP, Microsoft BI & Analytics Clint Vallandingham clintv@visualbi.com Sr. Manager BI & Analytics
  翻译: