OLAP is an acronym for On Line Analytical Processing. It is an approach to quickly provide the answer to analytical queries that are dimensional in nature. It is part of the broader category business intelligence, which also includes ETL, relational reporting and data mining. The typical applications of OLAP are in business reporting for sales, marketing, management reporting, business performance management (BPM), budgeting and forecasting, financial reporting and similar areas. The term OLAP was created as a slight modification of the traditional database term OLTP (On Line Transaction Processing).
Databases configured for OLAP employ a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. Nigel Pendse has suggested that an alternative and perhaps more descriptive term to describe the concept of OLAP is Fast Analysis of Shared Multidimensional Information (FASMI). They borrow aspects of navigational databases and hierarchical databases that are speedier than their relational kin.
Data Mining :: Databases
Data Warehousing :: Databases

Actuate Corporation - Builds Java based OLAP software for the enterprise and offers business process solutions for HR, Sales, Customer Service and Financial Services.
Meta Description: [ Actuate's business intelligence analytics tools provide real time enterprise reporting with user-friendly executive dashboards. ]
Alta Plana: Online Analytical Processing (OLAP) - A collection of information related to Online Analytical Processing and selected related disciplines including Data Warehousing (DW), Decision Support Systems (DSS), and Executive Information Systems (EIS). Maintained as a public service by Alta Plana Corporation.
Meta Description: [ A collection of information related to
Online Analytical Processing and selected related disciplines including
Data Warehousing (DW), Decision Support Systems (DSS), and Executive
Information Systems (EIS). Maintained as a public service by Alta Plana
Corporation. ]
Ariel Alert - Business intelligence solution for automated scheduling and web-based distribution of exception reports, information snapshots and threshold alerts.
Brio Technology - Leading edge enterprise business intelligence solutions for organizations worldwide.
Meta Description: [ Business performance management solutions, Brio software, Brio products, and Hyperion products. ]
Business Intelligence Technologies, Inc. - BIXL delivers data from Microsoft's SQL Server Analysis Server component, as well as other OLE DB for OLAP compliant cubes, right into Excel.
Business Objects - Business intelligence software and solutions including: enterprise reporting, query and analysis, data integration, and performance management tools.
Meta Description: [ Business Objects is the world's leading provider of enterprise business intelligence solutions, enabling organizations to track, understand, and manage enterprise performance. ]
Codework - 3-way Tangram is desktop OLAP for Windows 95/98 and NT-based platforms. Typical applications include sales analysis, marketing, and reporting, as well as budget and consolidation. Based on the Dyalog APL notation.
Cognos Incorporated - Business intelligence and planning software for performance management. Vendor of reporting, analysis, scorecarding, planning, and consolidation solutions for the enterprise.
Meta Description: [ Business intelligence & corporate performance management software for better business decisions. All data, reports, plans, & scorecards- one view- Cognos. ]
Comshare - Comshare's client/server and Web-based decision support applications allow employees across the enterprise easy access to business information to help your organization plan and operate effectively. Full-service software vendor, worldwide support.
Meta Description: [ Financial Planning & Management Applications, Enterprise Business Process Automation, Budgeting & Forecasting Systems, Sales Forecasting and Manufacturing Software ]
Contour Components Limited - OLAP software for interactive reporting, data analysis and information delivery.
Meta Description: [ Innovative OLAP software for Interactive Reporting, Data Analysis and Information Delivery ]
Data Dynamics Ltd. - Develop ActiveReports and DynamiCube, ActiveX components that provide OLAP and reporting facilities for applications written in Visual Basic. ActiveReports won Productivity Award in the 10th Jolt Product Excellence and Productivity Awards.
Databeacon Inc. - Software for web-based information analysis and reporting. Company, product, and solutions information.
Meta Description: [ Databeacon is .NET Smart Client or Java Open Client. Databeacon provides Web Reporting and Data Analysis software for the Mid-market enterprise and departmental applications. ]
Dimensional Insight - Privately held company specializing in the development and marketing of multidimensional data visualization, analysis, and reporting software.
Gentia do Brasil - South American Gentia distributor with consulting involving Balanced Scorecard and risk strategies.
Geppetto's Workshop L.L.C. - AntMDX and AntSQL. Query technology for enterprise relational and multi-dimensional data sources.
German OLAP and Data Warehouse Forum - Comprehensive list of links to white papers, (research) organizations, companies and product related to Data Warehousing, Online Analytical Processing (OLAP), and Data Mining. Content provided in both English and German.
Hyperion Solutions Corporation - Develops high performance, OLAP software for business planning, analysis, management reporting, and data warehousing applications.
Meta Description: [ Hyperion Solutions Corporation is the global leader in Business Performance Management software. ]
IAF Software, Inc. - Provides business intelligence solutions, including online analytical processing (OLAP) management and analytical tools.
Meta Description: [ Provides business intelligence, OLAP and management software for Oracle OLAP. ]
IBM DB2 OLAP Server - An online analytical database supporting diverse platforms including Windows, UNIX, OS/390 and OS/400.
Meta Description: [ Use IBM DB2 OLAP Server to deliver analytic applications that give your business a competitive edge. DB2 OLAP Server gives you fast, intuitive multidimensional analysis. With the many applications, tools, and solutions providers who support DB2 OLAP Server, you can create your own applications or... ]
Information Builders - WebFOCUS - Business intelligence solution designed to support e-business and e-government initiatives.
Meta Description: [ WebFOCUS is a comprehensive and fully-integrated enterprise business intelligence and reporting platform whose architecture, integration, and simplicity permeate every level of the global organization - executive, analytical, and operational. ]
instantOLAP - Java OLAP and web reporting tool to perform multidimensional analysis on relational database servers.
Meta Description: [ Java OLAP and web reporting tool to perfom multidimensional analysis on relational databases and other datasources ]
Introduction to OLAP - Understanding OLAP technology by example.
Meta Description: [ Understanding OLAP technology by example. ]
JPivot - JPivot is a JSP custom tag library that renders an OLAP table and chart. Users can perform typical OLAP navigations like drill down, slice and dice. It uses Mondrian and XMLA as its OLAP engines.
KD Nuggets Directory - Data mining and knowledge discovery resources.
Meta Description: [ Data Mining, Web Mining, Analytics, Knowledge Discovery ]
LogiXML - Business Intelligence and Reporting Software - LogiXML provides OLAP based business intelligence reporting and analytics software tools. .net based Ad hoc and managed reporting software solutions.
Microsoft Analysis Services - A component of Microsoft SQL Server, Analysis Services provides a client/server solution that enables users to perform sophisticated analyses on large volumes of data using MOLAP, ROLAP or HOLAP storage models. Data sources can include any OLE DB provider, such as SQL Server, Oracle, DB2, other relational databases, and flat files.
Meta Description: [ SQL Server 2005 provides many new and enhanced business intelligence features designed to give you a competitive advantage, including Integration Services, Analysis Services, Reporting Services, and more. ]
Microsoft OLAP Information - Mosha Pasumansky's site containing technical information, whitepapers, utilities, code samples and other resources about Microsoft OLAP products.
MicroStrategy Inc. - Provider of intelligent e-business software and services.
Meta Description: [ Business Intelligence Software Solutions Pixel-Perfect Print-Perfect Seamless BI Integration ]
MIK AG - Provides OLAP software and services for performance measurement.
Meta Description: [ Führender Anbieter für BI-Lösungen, Management-Informationssysteme - MIS - und Controlling für anwenderorientierte Lösungen. ]
Mondrian - An open-source OLAP server written in Java.
Meta Description: [ The world's largest development and download repository of Open Source code and applications ]
404
Occam Research Corp. - Developers of MUSE, a natural language, multidimensional data-analysis and visualization tool. Available for Macintosh and Windows platforms.
OLAP Information Site - Provides links to selected articles, whitepapers, and glossary of OLAP-terms.
Meta Description: [ Information center for OLAP and Data Warehouse interested people. We provide links to selected articles, whitepapers, a huge glossary of online analytical processing terms and more. ]
OLAP Insider - Provides interactive data visualization and data creation tools. By PEYO.
Meta Description: [ SQL database tools,OLAP,data mining - by PEYO ]
OLAP Services User Community - Provides information, resources and forums dedicated to the development and administration of solutions based around Microsoft OLAP Services. Frequented by members of the development team; registration not required for read-only access.
Meta Description: [ This is the place where all MS OLAP users can exchange knowledge, information and ideas. Post your tips, tricks or even complete papers ]
OlapX Software - OLAP multidimensional database creation and browsing tool that enables the interactive analysis, reporting and presentation of Microsoft Analysis Services databases.
Meta Description: [ OlapX is a sophisticated OLAP multidimensional database browsing tool. ]
Oracle Express - Oracle Express OLAP products support strategic decision making across a range of enterprises, including government, pharmaceuticals, retail, utilities, insurance, health care, entertainment, manufacturing, brewing, banking, and telecommunications.
Orenburg BOARD M.I.T. - Programming free, integrated multi-dimensional database for fast information analysis and modeling.
PivotCube VCL - Offers OLAP solutions for Delphi and C++ Builder programmers.
Meta Description: [ PivotCube is a high-performance visual component suite (Delphi and C++ Builder VCL and ActiveX) for rapid development of Internet, client-server and desktop business intelligence applications. It allows end users to perform OLAP and statistical analisys using current data from any relational data... ]
ProClarity Inc. - Provides the foundation for building a business analysis environment around Microsoft SQL Server with integrated Analysis Services and provides an open, flexible and extensible ActiveX/COM platform for the development of custom analytical applications.
Meta Description: [ Business intelligence products and services from ProClarity include software for business intelligence management. ]
QlikTech International AB - Provider of QlikView Business intelligence software that delivers multi-dimensional data analysis for ODBC-enabled enterprise data.
Meta Description: [ QlikTech´s QlikView Business Intelligence Software delivers analytical applications in one quarter of the time, at half the cost, and with twice the value of traditional OLAP-based solutions. QlikView - Business Intelligence. Now Smarter. ]
Rapiddecision.net - RapidDecision is a business intelligence solution that uses real-time information without regard to underlying ERP or dashboard applications.
SAS Business Intelligence - OLAP - SAS OLAP Server - a multidimensional data store designed to provide quick access to presummarized data, generated from vast amounts of detailed data.
Sight Software, Inc. - Pro/Sight Process Intelligence software combines the process analysis of Six Sigma statistical decision tools with the accessibility of Business Intelligence software.
500
Speedware Corporation, Inc. - Media/MR combines relational (ROLAP) and multidimensional (MOLAP) technologies to deliver hybrid (HOLAP) analysis.
Meta Description: [ Speedware is a provider of innovative enterprise software solutions, including application development technology, industry-specific business intelligence solutions and complete HP e3000 migration solutions. ]
Strategy.com - Personal intelligence network from MicroStrategy which actively delivers personalized, relevant and timely information to individuals via digital devices and the web.
Meta Description: [ Business Intelligence Software Solutions Pixel-Perfect Print-Perfect Seamless BI Integration ]
Tek-Tips Forums - OLAP - OLAP technical support forums and mutual help system for computer professionals. Selling and recruiting forbidden.
Temtec International B.V. - Provides OLAP reporting and analysis software and business intelligence solutions.
Meta Description: [ OLAP Software from Temtec provides self-service analysis, OLAP Reporting Software, and Executive Viewer Analysis Services. Temtec provides web-based OLAP analysis and reporting software and business intelligence solutions worldwide. ]
The OLAP Report - Provides regularly updated, detailed and unbiased information on the OLAP market and OLAP products.
| I made this presentation for a client. It is twenty-seven minutes long, and is unlike any of the other videos I have ... | |
| Next Video | |