5 Factors In Agile BI - InformationWeek
IoT
IoT
Healthcare // Analytics
News
6/1/2011
01:45 PM
50%
50%
RELATED EVENTS
[Cybersecurity] New Methods for Managing the Skills Shortage
Jun 06, 2017
In this webinar, security experts discuss methods for doing better security with fewer people, inc ...Read More>>

5 Factors In Agile BI

Business decision-makers need data fast. Here's how to deliver.

3. Agile Infrastructure

The standard BI infrastructure goes something like this: Information flows from data sources to the operational data store and data warehouse via extract, transform, and load (ETL) and is provided to customers, in most cases, as reports on a thin-client interface.

The question is, how do we optimize this architecture to fully leverage an agile development approach?

We can't always do much about data sources; the company may not even own all of them. On the other hand, we can do a lot to improve the data integration layer. Vendors such as Composite Software, IBM, and Informatica offer tools to integrate data without physically moving it. Integration happens in a virtual layer; source data is cached in the virtualization server and refreshed as needed by the business or as agreed with the data source owner.

Virtual integration lets business users visualize data much earlier in the development cycle, which helps them further refine requirements. Such an architecture also sustains near-real-time BI more easily than the standard ETL model.

4. The Cloud And Agile BI

When does the cloud make sense for BI and how does it improve agility? Companies without BI programs should look closely at the cloud as a way to jump-start their initia- tives. With cloud services, BI and ETL software can be provisioned as a service. Companies with problematic in-house systems can use the cloud to avoid having to upgrade hardware and software.

Another time the cloud can help is when data sources feeding the data warehouse change. Say a legacy system is replaced by a commercial, off-the-shelf system--all the underlying BI mappings and infrastructure must be redone. When a packaged ERP system is adopted to eliminate a multitude of homegrown siloed apps, there may be BI modules associated with the packaged tool that can be implemented in the cloud. Most companies will take a hybrid approach. Remember, where a system is hosted is less important than how fast and how well users can be served.

5. IT And Agile BI

Agility is driven by the need to serve end users. It's about always being relevant and responsive. To achieve maximum effectiveness, IT must interact with the business it serves and also connect with the business problems. A BI team with high turnover from project to project will find it much harder to leverage lessons learned.

Finally, beware red tape, which is usually imposed by ingrained processes and project management offices. Business and IT executive sponsors must commit fully to agile development. Only then can the need for speed be reflected in the BI infrastructure.

Diagram: How the cloud aids agile BI

Margherita Bruni helped the AARP IT leadership team implement and manage a best-in-class integrated enterprise-wide BI practice and competency center.

Previous
2 of 2
Next
Comment  | 
Print  | 
More Insights
Comments
Threaded  |  Newest First  |  Oldest First
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To 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.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of Data and Analytics
Today's companies are differentiating themselves using data analytics, but the journey requires adjustments to people, processes, technology, and culture. 
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll