Top 10 Must Have Self-Service BI Governance Capabilities - InformationWeek
IoT
IoT
Data Management // Big Data Analytics
Commentary
2/23/2017
07:00 AM
Jen Underwood
Jen Underwood
Commentary
50%
50%

Top 10 Must Have Self-Service BI Governance Capabilities

If self-service business intelligence initiatives are on your agenda, follow these 10 best practices for ensuring proper governance.

Although self-service BI solutions have come a long way and add tremendous value in daily decision making, many offerings still lack crucial governance, data security, and privacy features. Do you know what governance capabilities to look for when selecting or implementing self-service analytics solutions? In this article I will discuss why governance is important and share my top 10 must-have features for rolling out self-service BI tools to the masses.

Why Govern Self-Service BI?

A self-service reporting system with little or no governance can be challenging to remediate. Reporting issues typically arise after numerous data models and reports have been developed. A few tell-tale signs that your self-service BI reporting is out of control include seeing multiple copies of the same data, you can only report on current organizational structure, you do not have a shared reporting calendar, or rolled up detail numbers do not match summary numbers.

[Jen Underwood will be the featured speaker in a May 17 Interop ITX session, Best Practices for Developing Real-time Dashboards.]

To avoid a reporting mess, it is far better to start with governance in mind on Day One. Potential risks of not governing your self-service BI offering include:

  • Failure to comply with regulatory, security or privacy requirements
  • Bad decisions based on outdated, incorrect, or incomplete data
  • Numerous copies of uncontrolled data compromise one version of the truth
  • Inefficient, non-reusable data models, business logic and metrics
  • Inability to verify the data origins and changes if audited
  • Reporting inaccuracy or limitations across time periods
  • Loss of credibility if reports cannot be reconciled
  • Scalability, maintainability and security issues

Trust but Verify Self-Service BI Security

At an industry conference that I recently attended, a director of analytics from a global 2000 retailer shared how his security team identified data exposure holes while testing one of the less mature but top three ranked self-service BI offerings in the market today. His security team findings initially shocked me. After more thought, I do understand how easily security can be overlooked when buying these solutions.

Security is a deeper level, complex technical topic. Most business users would not understand security, digital communication protocol terminology or what types of functionality to look for when buying self-service BI solutions. Security is not a “sizzle” feature that will get a lot of business user votes to prioritize it for vendor development investment. I also suspect security functionality is assumed by users that purchase these tools with the swipe of a credit card.

My top tip for buying or implementing self-service BI solutions: Don't assume your self-service BI offering has sufficient governance or data security controls; verify it.

Be sure to include your own information security officer or enterprise architect in self-service BI reviews. If your preferred platform does not have adequate controls, you might be able to address governance gaps with work-arounds. It is better to protect the organization than to beg for forgiveness when it comes to data security.

Key Governance Capabilities

Enterprise-ready, self-service BI platforms should have built-in governance capabilities for agile, yet controllable access to data for reporting. Effective governance requires structuring appropriate authentication, data connection access, report development and sharing processes.

Here are my personal top ten governance features that I consider when evaluating self-service BI solutions.

  1. Single sign-on authentication for access control
  2. Granular permissions for log in, authoring, editing, deletion, sharing, exporting and role based conditional content viewing
  3. Watermarking for approved, “sanctioned data sources”
  4. Content version control, migration workflow and rollback
  5. Exportable data, administrators should be able to easily migrate published data – avoid “data lock in” to a proprietary engine
  6. Support for slowly changing dimensions to accurately report data over time and across organizational structure changes
  7. Data lineage for understanding report data sources and changes
  8. Collaboration with conversation capabilities to reveal reporting content context
  9. Customizable administrative reporting, usage monitoring and alerting
  10. Administrative utilities for mass deployments

More Than Features

A self-service BI governance program is more than a collection of technical features. Governance frameworks usually address people, process, and technology in balancing information value with organizational regulatory, compliance, data privacy and ethics needs. Without all areas addressed or continually monitored, self-service BI governance initiatives quickly fade into a collection of unfollowed guidelines.

Jen Underwood, founder of Impact Analytix, LLC, is a recognized analytics industry expert. She has a unique blend of product management, design and over 20 years of "hands-on" development of data warehouses, reporting, visualization and advanced analytics solutions. In ... View Full Bio
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
Video
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll