Skip Links

Network World

  • Social Web 
  • Email 
  • Close

(Comma separation for multiple addresses)
Your Message:

Spreadsheet governance is a must

By James Kobielus , Network World , 11/09/2006
Kobielus
  • Share/Email
  • Tweet This
  • Comment
  • Print

Spreadsheets are a wild card in the master-data management equation.

On the one hand, spreadsheets are one of the primary client applications for viewing and working with master reference data from corporate data warehouses. On the other hand, they make it far too easy for users to ignore or flout the MDM controls governing data warehouse operations. Users often populate Excel spreadsheets with information that is outdated, inconsistent and full of errors, and with formulas that deviate significantly from company-approved analytical models.

Spreadsheet governance should be a core component of every organization's MDM and regulatory-compliance strategies. To ensure all users are working from a common set of master data and analytical models, a company should place its spreadsheets under strict MDM version, change and access controls. For compliance purposes, organizations must be able to determine which spreadsheet version a given user relied on at a particular time when taking a specific action. Ideally, desktop spreadsheets should be populated with current, sanctioned data from corporate-sanctioned data warehouses and other official repositories.

In the past few years, the range of commercial spreadsheet-governance tools has grown steadily, though the niche is still far from mature. Vendors in this emerging market include established business intelligence vendors, such as Actuate, and compliance-focused vendors, such as ClusterSeven, Compassoft, Mobius Management Systems and Prodiance.

  • Share/Email
  • Tweet This
  • Comment
  • Print
Partner Content

Blue Stripe Software

www.bluestripe.com/

Improving Application Performance Troubleshooting

Diagnosing why an application is slow is hard, at times taking days or weeks to isolate and resolve. This paper explains the challenges involved using current management tools, provides a 'wish list' for application management and analysis, and explains the need for an application system-wide approach that monitors entire applications, not components.

Download Whitepaper

Virtual Vigilance: Managing Application Performance in Virtual Environments

This paper highlights the impact of virtualization on application performance.  "Managing Application Performance in Virtual Environments" states: "Best-in-Class organizations are predominately taking actions around improving visibility across both physical and virtual systems, assessing the business impact of application performance and understanding interdependencies of applications in virtualized environments."

Download Whitepaper

Application Service Requests: The Missing Link for Pragmatic ITSM

Forrester Research analyst Glenn O'Donnell and BlueStripe co-founder Vic Nyman discuss a breakthrough approach to application problem management. Learn the new approach for ITSM problem management, which provides: Rapid isolation of application slow-downs to specific components for quick problem resolution, 24/7 monitoring for proactive notification of potential issues before end users are impacted and much more.

Register for Webcast

Comment
Login
Forgot your account info?
Add comment
Anonymous comments subject to approval. Register here for member benefits.
Have a NetworkWorld account? Log in here. Register now for a free account.

Videos

rssRss Feed