Four Worst and Four Best Practices in Business Intelligence - Slide 3

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Next Worst Practice #2-3 Next

Worst Practice #2

Even though Excel provides much utility for business users, it wreaks havoc on the quality and consistency of information. This is especially damaging in heavily regulated industries that must adhere to strict compliance legislation.

Excel was never intended to be a BI tool. It is not Excel that is at fault, but rather its use as a BI tool. Much of what is found in Excel spreadsheets is put there through a manual, error-prone, process, which should never be the case with BI. BI applications should only utilize data from reliable, trustworthy sources.

Another unique phenomenon created by Excel is what is called “spreadmarts.” When individual users accumulate their own store of relied-upon data in their personal spreadsheets to a point where their information becomes a critical data source, it becomes a spreadmart. A spreadmart is an unregulated, non-secure datamart in the hands of a user who rarely backs up his or her data and may leave his or her job on a moment’s notice. This single user isn’t a problem so much as the accumulation of hundreds of users with unregulated datamarts.

BI software – tools, platforms, and applications alike – holds great potential for helping organizations readily access the enterprise information needed to make informed business decisions and, ultimately, achieve their business objectives. But, as with any technology, the implementation, roll out, and usage practices play a critical role in the success of BI.

In tracking mediocre results, and even failure, in the implementation of BI software over the years, many common threads, or “worst practices,” can be found. These worst practices set companies on the inauspicious path of BI failure. They have been repeated by some of the best run and smartest companies in the world. Typically, these worst practices are the result of wanting to ride the latest technology wave without balancing the hype with practical knowledge and experience.

In order to help organizations learn from the mistakes of others, Information Builders provides the following insight into the worst and best practices for BI, so that you will have a solid understanding of how to avoid BI failure and achieve success with your BI initiatives.

More Slideshows:

Seven Video Resume Tips for Job Seekers Tips for job seekers looking to add a video component to their job search.

10 Top Google Apps for Project Management 10 of the highest-rated apps for project management from the Google Apps Marketplace.

Top Five Rules for E-mail Etiquette Follow these simple rules to help you avoid looking like an amateur in the world of e-business communication.


Related Topics : Application Security, IT Process Management, Six Sigma

More Slideshows

142x105itbeusasecurity2.jpg 9 Predictions for Cybersecurity’s Role in Government and Politics in 2017

Experts predict how cybersecurity will affect and involve our government, policies and politics in 2017. ...  More >>

Five9RemoteEmployees0x 5 Best Practices to Enable Remote Workers

Recent years have seen a significant increase in the remote workforce as developments in technology have given employees the freedom to work anywhere, anytime. ...  More >>

DataM62-190x128 10 Steps for a Proper Data Governance Plan

Establishing a digital governance plan can be a challenge, but with the right education and tools, the job can be made a lot simpler. ...  More >>

Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.