IBM Press room - 2010-10-21 IBM Acquires Clarity Systems - United States

Coming close to a single source of total BI tools, IBM takes over a mid-sized financial planning and reporting technology firm in Toronto.

Clarity Systems delivers financial governance software that enables organizations to automate the process of collecting, preparing, certifying and controlling financial statements for electronic filing, in support of mandates by the SEC and other financial regulatory agencies. To significantly reduce the risks of potential error and the lengthy times required to create and file financial documents, Clarity Systems software allows finance professionals to seamlessly integrate information for more efficient planning, consolidation and financial reporting.

IBM Press room - 2010-10-21 IBM Acquires Clarity Systems - United States

Forced Parameterization: A Turbo Button?

 

Forced Parameterization: A Turbo Button?

I never had the need to turn on the PARAMETERIZATION FORCED database option until this week. We pretty much use only stored procedures for our internal applications so the execution plans are almost always in cache and reused. This practice of using parameterized stored procedure calls, together with attention to detail in query and index tuning, allows us to comfortably handle several thousand requests per second on commodity hardware without taking special measures.

Forced Parameterization: A Turbo Button?

AMO Analysis Services Create KPI

How to create a KPI from command-line/Powershell.

AMO Analysis Services Create KPI

First PerformancePoint Services 2010 Project Recap « Alan Whitehouse’s Ramblings

 
Great article on some of the trials and tribulations of installing and designing PPS 2010 dashboard solutions.

Project Background
We recently completed Phase 1 of a PerformancePoint 2010 deployment for one of the largest insurance companies in Canada. In 2009, TGO Consulting engaged with them to deploy Dynamics GP as their new ERP system. Towards the middle of November, we heard through the grapevine that the client was also looking for a business intelligence solution and had already narrowed the list down to two well-known players in the industry – neither of which was Microsoft.

First PerformancePoint Services 2010 Project Recap « Alan Whitehouse’s Ramblings

Data Mining, Predictive Modeling, Techniques

Though not specific to PerformancePoint or even SQL 2008 data mining, Statistica has an excellent and comprehensive site about Data Mining.

Data Mining is an analytic process designed to explore data (usually large amounts of data - typically business or market related) in search of consistent patterns and/or systematic relationships between variables, and then to validate the findings by applying the detected patterns to new subsets of data. The ultimate goal of data mining is prediction - and predictive data mining is the most common type of data mining and one that has the most direct business applications. The process of data mining consists of three stages: (1) the initial exploration, (2) model building or pattern identification with validation/verification, and (3) deployment (i.e., the application of the model to new data in order to generate predictions).

Data Mining, Predictive Modeling, Techniques