- Mythbuster busts his own tale
- 10 open source companies to watch
- Sony recalls 73,000 Vaio laptops
- Tool to evade China's Web censorship
- Chrome and Firefox and add-ons
Newsletters | Podcasts | Chats | Opinions | RSS Feeds | This Week In Print | IT Careers | Community | Reports | Downloads | Slideshows | New Data Center
Partner Sites:App Performance | On Demand Security | Networking Solution | SOA | Value of WDS
Despite the idea that business intelligence is a crucial tool for getting and keeping customers, adequately measuring company performance, and delivering flexibility, challenges remain. One of the most important: data governance.
Although data governance is crucial to successful BI and data warehouse efforts, it isn't easy. To the rescue: five dirty data practices you may be guilty of, and five ways to clean them up.
Dirty Data Practice No. 1
You think buying the coolest business intelligence tool is all you need.
It may be a truism that your BI reporting tools are only as good as the information you feed them (that is, "garbage in, garbage out"), but that doesn't mean that the right actions are a given. Since most organizations still take an isolated view of data, data governance remains a difficulty, says Ian Charlesworth, principal analyst with IT consultancy Ovum. Data is all too often siloed in different business units and is entered, treated and viewed differently, making "one version of the truth" impossible.
Clean It Up
Know your data.
The first step of data governance is to establish a clear view of your data; find out what you have, how reliable the information is, what data is beneficial but previously unused, which data is corrupted and which IT projects are duplicating information. And be sure to communicate to stakeholders the cost of not having data governance and the value of creating it.
Dirty Data Practice No. 2
You procrastinate until you can do a complete overhaul.
An all-or-nothing approach is almost guaranteed to fail. For starters, bringing all data under control in one fell swoop is not realistic given time and money constraints, and in organizations where such an overhaul is possible, user resistance is almost a given.
Clean It Up
Start small, think big.
Instead of all or nothing, prioritize the most crucial aspects of data governance, in keeping with your overarching vision. For example, Charlesworth recommends focusing on four key areas.
Create data quality processes and procedures, and where possible embed these at the point of data creation or capture. For example, create a data validation routine in an order entry system or establish a corporate standard for name and address nomenclature.

In this whitepaper learn how Retrospective Network Analysis (RNA) has proved a different type of...
SNMP Monitorin One Critical Component to Network ManagementSNMP is a valuable tool to any network administrator who requires complete visibility into the...
Monitoring and Managing App PerformanceThis paper defines application analysis, discusses the different categories of tools on the market,...

Double-Take (r) Software and Microsoft are teaming up on September 9, 2008 for a webinar focusing...
PoE Plus: Impact on the PoE MarketThe standard for Power over Ethernet (PoE), IEEE Std. 802.3af(tm)-2003, advanced networking,...
Intelligent Mobility: BlackBerry Technical Seminar 2008The virtual BlackBerry Technical Seminar keeps growing in popularity every year, and we want to...

Find out why analysts say approaching virtualization with an ounce of caution is wise. And also why...
Closing the Loop: Extending Wireless LAN Security to Wireless PrintersEnterprises cannot overlook wireless printers when assessing network security. The print jobs and...
Ethernet Services: WAN options matureWAN Ethernet services are reliable, cost-efficient offerings that are widely available and in a...
Partner Content
NetScout is one of the world's premier providers of integrated network and application performance solutions.
www.netscout.com
Know First
Get Proactive — Move from Troubleshooting to Monitoring to Management with nGenius K2's Service Dashboard & Intelligent Early Warning Alarms
Watch the Video
Know Where
Get Rapid Performance Problem Isolation with nGenius Performance Manager and Diagnose Problems up to 70% Faster!
Learn More
Know Why
Get the Details to Validate and Solve your Toughest Performance Issues with nGenius InfiniStream and Sniffer Intelligence Modules
Read the Whitepaper
Comment