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.
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.
Single sign-on authentication for access control
Granular permissions for log in, authoring, editing, deletion, sharing, exporting and role based conditional content viewing
Watermarking for approved, “sanctioned data sources”
Content version control, migration workflow and rollback
Exportable data, administrators should be able to easily migrate published data – avoid “data lock in” to a proprietary engine
Support for slowly changing dimensions to accurately report data over time and across organizational structure changes
Data lineage for understanding report data sources and changes
Collaboration with conversation capabilities to reveal reporting content context
Customizable administrative reporting, usage monitoring and alerting
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
How Enterprises Are Attacking the IT Security EnterpriseTo 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.
IT Strategies to Conquer the CloudChances 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.