Business Intelligence Network
business intelligence resources

Blog: William McKnight

Main

April 19, 2008

Revenge of the ERPs

Those processes that were primarily considered to need to go against the data warehouse are now being moved back into operational systems themselves, or new systems are being established in operations. However, unlike previously, when ERP vendors were slow to acknowledge the need for anything beyond what they provided, ERPs today tend to work as members of an information ecosystem. It’s like back to the days before data warehousing, only this time with an operational environment increasingly able to keep up with corporate demands.

Today’s ERP environments are well aware of the real-time and up-to-date need for information and facilitate much of the analysis needed in three ways:
• By providing the analysis within the ERP system
• By flexibly allowing for data warehouse feeds
• By enabling enterprise application integration (EAI) and enterprise information integration (EII) for interchange with other operational systems and cross-system queries

March 26, 2008

Leadership, The Data Warehouse, The Operations World and Analytic Access

I have a new white paper available. It's sponsored by Business Objects and titled "Modernizing and Advancing Information Management Across the Enterprise." In the paper, I try to put information management leadership, the data warehouse, operations and analytics into a modern context.

I talk about the necessity and structure of information leadership, including new concepts of an Information Management Competency Center and Information Management Governance. I talk about the 2 directions data warehouses can go now and federating and consolidating those warehouses. Finally, there's where analytics are going to be coming from and some of the analytic value of modern ERP.

In each of the 4 areas (organization, data warehouse, operations, analytics), I give you a "checklist" of the most relevant questions to ask of your shop and seek answers to.

The paper is available at this link or on my channel here at the B-eye-network.

Continue reading "Leadership, The Data Warehouse, The Operations World and Analytic Access" »

February 18, 2008

Gartner Magic Quadrant for Business Intelligence 2008

Gartner came out with the 2008 BI Platforms Magic Quadrant with all the market heavies in the upper right (Microsoft, Cognos/IBM, Business Objects/SAP and Oracle). SAS is also there and Microstrategy also clears the center. Though it may appear as the safe way to go, this quadrant is consistent with earlier quadrant criteria and shows some minor progress by Microsoft and Cognos, both deserved, and the absorption of Hyperion into Oracle, which surprisingly did not boost Oracle much. In effect, Gartner is commodifying itself along with the toolsets. This quadrant will need to get less top heavy and some recalibration is in order so that the subtler differentiation stands out amongst the BI toolsets. There are also the dozens of smaller BI players that Gartner could highlight and add value in that way. Most BI buyers would (should) know the list of major players already.

Some of the softer factors like local representation, availability of resources, internal skills and synergy with existing technologies becoming more interesting these days in BI selection.

Continue reading "Gartner Magic Quadrant for Business Intelligence 2008" »

January 2, 2008

The Best of Data Warehousing 2007

Continuing the awards for the “best of” information management tools for 2007, I move to the proverbial “back end” and offer up some “best of” products that provide the foundations of our environments. Thinking back over the products I’ve worked with in 2007, I have to repeat my belief that it was the “Best of” year in information management.

Best Open Source DBMS

MySQL Enterprise Fall 2007 Release – This is the commercial subscription offering for the popular MySQL open source database (which makes it “low cost” not free – for those who associate open source with free). It includes a comprehensive set of production-tested software, proactive monitoring tools, and premium support services for corporate developers and DBAs. MySQL provides a full suite of database drivers and graphical tools to help developers and DBAs build and manage their MySQL applications.

Best Data Warehouse Appliance

I take this opportunity to say there is no ‘best’, only best for a given situation because indeed there are many with good value propositions.

Best Federated Query Facilitator

Continue reading "The Best of Data Warehousing 2007" »

December 19, 2007

The Best of Business Intelligence 2007

It’s year-end and time for year-end awards. There seem to be awards for just about everything already, but I’ve come up with some unique (I think) categories to share some vendors and products with you that are on my mind. My diverse client needs have led to some far and near corners of the vendor community for solutions. I’ll start on the business intelligence side. Drumroll, please.

Best tool for working with Microsoft Excel
1a. Xcelsius from Business Objects.
1b. Actuate 9 e.Spreadsheet

Yes, 2 winners. Xcelsius brings Excel spreadsheets to life with its incorporation of live data as well as predictive analytics into robust gauges. It’s a great tool for “what if” and the best accessible development tool for creating user understandable analytics.

Actuate 9 e.Spreadsheet similarly can work on live data. Its distribution capabilities for actual Excel spreadsheets makes it a winner. Live formatting, pivot tables, filters, 3D charting and calculations are rich capabilities for making Excel actionable. It’s quick to learn and takes spreadsheet development (yeah, I know it’s easy for us IT people) off of end user hands who don’t want (or have time for) that task.

Best workflow for contact centers
AIM Performance Suite 6.5 – from the founders of Crystal Enterprise

Best business intelligence appliance
Not to be confused with data warehouse appliance, this award goes to Cognos Now! Version 4.3. This is one way to get operational business intelligence – with operational dashboards. Now! works nice with streaming data. Caching keeps performance high and the price makes it very accessible.

Best BI tool integration with Blackberry
Cognos 8 Go! Mobile – This tool actually understands the thumbwheel roll that Blackberry users are prone to do. Combine with Cognos 8 BI Analysis for Excel 8.2 and you’re looking at your BI content on your PDA in Word, Powerpoint or Excel format.

Best BI library metadata

Continue reading "The Best of Business Intelligence 2007" »

November 21, 2007

Framework Purchasing in Business Intelligence over the next few years

A trend I anticipate to start in 2008 is a byproduct of the enormous M&A activity that has taken place, and will continue to take place. That trend is what I call “framework purchasing.” Many end user organizations, and more to come, when they are rounding out their technology stack, will have to highly consider chiefly the offering from one of the mega-vendors already in their shop and align with their emerging platform (note I didn’t say standard.) There will be tool replacements as well as these vendors drive cross-selling with discounts and the lure of tool integration, the latter of which will take some time.

Consider that with their respective buying sprees, SAP, Microsoft, IBM and Oracle are approaching, or at, complete stacks for not just business intelligence, but enterprise software as a whole. Consider the rich application stack of Hyperion and its data access tool combined with Peoplesoft, JD Edwards, Siebel, Retek, Agile, G log and Demantra. Of course, I just used the “old” names. I guess I am being a little nostalgic. Not to pick out the new Oracle stack here necessarily. IBM, Business Objects and Microsoft have similar stories to tell. However, as the mega-vendors have been busy filling out their gaps and we prepare to draw our collective breath, has anyone noticed SAP does not have its own DBMS? As well, the DBMS market is about as rich with supply as it has been in a decade.

Continue reading "Framework Purchasing in Business Intelligence over the next few years" »

June 26, 2007

UK business intelligence projects hitting target

This article from TechWorld is titled “UK business intelligence projects not hitting target” and starts with “A huge 87 percent of business intelligence projects are failing to meet their original objectives, and nearly a quarter are going over budget, according to new research.”

Wow!

Now, I’m not one to overhype business intelligence success, which I think most of what I read actually does. However, let’s dissect this using the facts of the study.

“The survey of 68 senior IT decision makers in the UK, conducted by the National Computing Centre for data management vendor Sybase, revealed serious disappointment in business intelligence projects, after 85 percent of those interviewed had implemented the technology in order to improve management decision making.“

OK, the only fact there is that 85 percent of those interviewed had implemented BI. The “serious disappointment” is developed in the rest of the story. Or is it?

Continue reading "UK business intelligence projects hitting target" »