The old biblical saying is true even in your IT organization. Someone in your organization has got to have a vision for the future of BI in the company. What happens if there is no vision? One word for you, "Tangents." There are a million and one systems that your organization can use. Most of them have some sort of reporting functionality attached. These vendors need to refer to the BI roadmap for your organization. What? you don't have a roadmap? Well you need one. Realize that if you don't drive your vendors. Your vendors will drive you. Your IT department can only support X number of systems. The only reason for X+1 is a lack of vision.
Joe, I inherited this lack of vision. How do I get to goodness? Here is Joe's happy path:
1) Analyze your current environment. What are the systems and who uses them.
2) Ask yourself, which reporting environment do I want to use for Adhoc reports, General Reporting, and Dashboards. NOTE: You can have 3 different tools for the three different needs.
3) Develop a plan to get down to 3 reporting systems. Push as much reporting to your data warehouse as possible. After all, that is the purpose of the DW. Your new favorite word is "Sunset" because your the new hatchet person for sunsetting reporting tools. Sometimes you need to merge a legacy data warehouse into the EDW. That depends on your business and where you want to move as an organization.
4) Before you purchase a new system, All Vendors will report through the data warehouse - bar none.
After you come up with your new vision and roadmap, socialize this to the business. Be the new Evangelist for Clean reporting. Call it the Common Core Reporting. Feel free to steal that one if you want.
Joe
No comments:
Post a Comment