The fierce competition of two OLAP technologies has not stop by merging their mother’s companies. Cognos in 2007 acquired Applix (though months later itself was acquired by IBM) not just to create synergy effect or broaden its customer base but to gain technological advantage too. Cognos’s PowerPlay, some ten years ago probably the most broadly used OLAP technology, has already reached its technological limits and new innovative products had superior performance and more capabilities. Continue reading 'IBM Cognos OLAP: TM1 versus PowerCubes'»
Using OLAP (multidimensional analysis) brings brand new user experience but until users do not have it, they cannot figure out how they will use it. This is often a major issue when projecting business intelligence or data warehouse solutions. User are used to static paper reports and when interviewed by project analysts they describe their requirements from that point of view. So it happens that data warehouses or business intelligence solutions often try to use OLAP as purely reporting tool and users are not happy because OLAP tools often lack rich formatting capabilities. If the end users knew how OLAP works, many BI projects would be much more successful and satisfying for both the users and the implementators.
The most important benefit business intelligence can bring to a retailer is exact knowledge about real margin achieved for every product sold in any shop in any day. Though it can seem trivial at first sight it is a major challenge when you try to do it. Continue reading 'Questions to Consider When Building Business Intelligence in Retail Business'»
The most basic way to deploy business intelligence is to connect it to data in existing operational databases, like ERP systems (enterprise resource planning systems e.g. SAP, Oracle Financials, Microsoft Dynamics, Lawson or other), CRM, billing systems, manufacturing control systems and so on.
Business intelligence is a name used for wide class of software applications that provides managers and other knowledge workers with information they need for managing more effectively their organizations (companies, public institutions, schools, hospitals, ngo’s and other). It includes tools for reporting, analysis, OLAP, dashboards, scorecards and others. Continue reading 'Business Intelligence Software and Systems, an Introduction'»