Business Intelligence Articles
The following articles are available for download as PDF files. If you don’t have the Adobe Acrobat Reader please download it here.Symmetry PROOF Approach, Symmetry White Paper. The white paper provides an overview of PROOF design principles and standard PROOF design patterns.
How to Leverage Project Server 2007 with PerformancePoint Server 2007 Monitoring and Analytics, William G. Brown, Symmetry and Microsoft White Paper, January, 2009. This white paper provides an overview of the PerformancePoint Server software and how it can be used to develop dashboards with the existing relational and analytical databases created with Microsoft Office Project Server 2007. In addition to detailing some advanced techniques for creating analytically rich scorecards, it covers how to organize Key Performance Indicators (KPIs) and other best practices. Sample data files (PerformancePoint Builder Workspace and ProClarity Briefing Book) are also provided. See the ReadMe file for more information.
Evaluating
Business Intelligence Offerings: Oracle and Microsoft, Symmetry White
Paper, August, 2005. The white paper reviews the key considerations in
deciding on a BI offering, compares the strategies of Oracle and Microsoft,
and evaluates their respective BI offerings.
Evaluating
Business Intelligence Offerings: Business Objects and Microsoft,
Symmetry White Paper, August, 2005. The white paper reviews the key considerations
in deciding on a BI offering, compares the strategies of Business Objects
and Microsoft, and evaluates their respective BI offerings.
Undocumented
Express, William G. Brown, Oracle Internals, February, 2000. The
article describes a series of useful Express tips and functions that
take advantage of Express' stored procedure language.
Getting
Started with ADAPT, Dan Bulos with Sarah Forsman, Symmetry white
paper, July, 1998. The white paper introduces the basic elements of ADAPT,
explaining each of the nine ADAPT database objects and their symbols,
and illustrating how to use the symbols with simple examples.
Oracle
Financial Analyzer:A Look Under the Hood, William G. Brown, OTJ,
winter, 1996. The article discusses how you can develop Oracle Financial
Analyzer applications faster and streamline ongoing system maintenance.
OLAP
Council White Paper, Sarah Forsman, April, 1996. The paper defines
OLAP, who uses it and why, and reviews the key features required for
OLAP software.
OLAP
Council Benchmark Study, Dan Bulos, April, 1996. The paper describes
the OLAP Council’s Analytical Processing Benchmark, APB-1.
How
To Evaluate OLAP Servers, Dan Bulos, DBMS Magazine, August, 1995.
The article contains a comprehensive checklist of features that you can
use as a framework for evaluating OLAP servers.