Slew of webinars and resources

Why requirements definition is a critical first step (April 18, 2007 @ 1:00pm EST)

Managing your requirements is only half the battle. For management to be truly effective, taking the first step of defining complete, accurate requirements is absolutely critical. In this webcast, Forrester Senior Analyst Carey Schwaber will explain how you can build agreement around requirements right from the start, so there are no uncertainties down the road.

Aligning Business and IT (on demand)

Many CIOs are struggling in their quest of aligning IT with the corporate business strategies, objectives, metrics and culture. CIOs need to become more involved in the development of strategic initiatives and build an understanding of the corporate and line of business missions and goals if they seek to align IT with the corporate directions. Moreover, CIOs need to interpret that knowledge into a flexible IT strategy if the alignment is to succeed long-term.

Business Intelligence Trends (podcast)

As business intelligence (BI) evolves, new trends emerge. But whichimportant BI trends should you pay attention to? And how should yourorganization incorporate this information into BI strategies?

Business intelligence basics

Business intelligence is defined as,

The process of gathering information about a business or industry matter; a broad range of applications and technologies for gathering, storing, analyzing, and providing access to data to help make business decisions.

While I am not an expert in this field I do have a fundamental understanding of the key concepts. The picture below shows a high level view of a simple business intelligence configuration.There are:

1. Source systems which gather the information that will be analyzed.
2. Information from the source systems are stored in their native databases or other data sources. Typically the database are configured for speed of processing. This is good for processing transactions quickly but bad for analyzing them.
3. Information from the data sources goes through a process known as ETL where the data is extracted from the source system, transformed (to meet business needs) and loaded into a data warehouse. Many different data sources can be consolidated.
   
4. Information from the data warehouse is made available to end-users in the form of data marts where the data is organized to answer specific types of business questions (e.g., sales data can be cross referenced by product, region, time, sales representative, etc...)
5. Finally, reporting and analytic tools are used to analyze the information in the data marts. This genre of reporting tools are known collectively as on-line analytical processing (OLAP for short.) There are a few different variations of OLAP tools: MOLAP or multi-dimensional OLAP and relational OLAP or ROLAP. Each has its advantages and disadvantages. For more information on OLAP I suggest going to the OLAP report.
   

Considerations

• Do you need real-time reporting? Is it important to understand what is going on right now? By nature, most business intelligence configurations update their information at a frequency insufficient for real-time reporting.
• Are there standard reporting needs or are reporting needs of a more ad-hoc nature? The answer to this question my mean that one of MOLAP or ROLAP may be more relevant.
  

Tips for Business Intelligence

There was a short set of slides posted on BaselineMag.com outlining 6 Tips for Business Intelligence Success. Make sure you check it out. The tips are:

1. Understand your enterprise
2. Involve key users
3. Make sure components of a BI system work together
4. Be mindful that different employee groups will want different interfaces
5. Consider making applications broadly available
6. Create a competency center

Some of these tips are applicable to normal business analyst engagements as well.