The Search Interface - an Update on Project Idaho
We have made significant progress since the last newsletter and are on target to deliver a Pilot Program release of Worksheets and Searches in the 2nd quarter of 2010. We are making great strides with a new Search interface.

Process Management Tool Helps Decipher Performance Issues
The Process Management feature of PBI is a tool to help identify poorly-performing processes and ultimately view and analyze the SQL statements in the process. Click here to see how.

Pie Chart Alternatives for Graphing in the PresentationCenter
PBI encourages our users to select graphs and pictorial representations of their data that the end user will easily grasp and understand. Learn more about graphing in the PresentationCenter here.

PBI Training
View our 2nd quarter 2010 training schedule.

What's New
Twitter news and new additions to the team.

Meaningful Use
In 2009, Congress passed the American Recovery and Reinvestment Act which includes incentives for healthcare providers and hospitals to implement and embrace Electronic Health Record (EHR) technology and become “meaningful users” of certified EHR technology.

The Next Step - 2010
Analysis is the best way to retrieve aggregated data in Precision.BI. However, there are instances where an aggregate value would be useful in a Worksheet. Click here to view the code and explanations.

SQL Tips and Tricks
OVER Clause.  It is used to add ranking functions and aggregate functions to any SELECT (even without a GROUP BY clause). See the code here.