<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<link rel=File-List href="cid:filelist.xml@01C97AF9.A80D5060">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
b\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
ol
{margin-top:0in;
margin-bottom:0in;
margin-left:.25in;}
ul
{margin-top:0in;
margin-bottom:0in;
margin-left:.25in;}
@page
{size:8.5in 11.0in;}
-->
</style>
</head>
<body style='margin:0'>
<table border=0 cellspacing=0 cellpadding=0 width=769>
<tr>
<td width=0 height=0></td>
<td width=769 height=0></td>
</tr>
<tr>
<td width=0 height=995></td>
<td width=769 height=995 valign=Top>
<img border=0 hspace=0 vspace=0 align=Left
src="cid:image001.jpg@01C97AF9.A80D5060"
title="In November, the Datamart Team..."
alt="In November, the Datamart Team conducted a User Profile survey with the hopes of gaining a better understanding of how people are using the Datamart, which query tools are being used, and for what purpose.
We are happy to report that 241 Datamart users from 40 different agencies responded to the survey. This represents more than 30% of all active Datamart users!
Here’s what they told us:
What kinds of data do you query? Out of the 5 different data sources available in the Datamart, 88% of users query SFMA data and 55% access OSPS data. Several comments were made indicating that users did not know that budget and personnel data were available through the Datamart. That could explain why the number of users accessing personnel or budget data is considerably smaller. Only 20% use ORBITS, 13% use PPDB and 12% use PICS. Additionally, 27% of users access only internal programs and/or databases.
Which query tool do you use? For 61% of users, Brio/Hyperion is the query tool of choice, while 35% of users said they use Brio/Hyperion in conjunction with another query tool, such as Crystal or Access. Survey Produces Good Results
Survey Results
1
Query Tool Project Update
1
Training Update
2
Tips & Tricks
3
Inside this issue:
Datamart Connection
Statewide accounting & reporting serviceS
state controller’s division
department of administrative services
Volume 1, Issue 13
January 2009
Your
Datamart Team
Business Analyst
Linda Flicker
503- 373-7277, x 281
linda.flicker@state.or.us
Systems Analyst
Tonya Harbison
503-373-7277 x238
tonya.a.harbison@state.or.us
Query Tool Project Update
January 21st marks the date for the Enterprise Reporting and Query Tool Project kickoff meeting. This is the first in a series of meetings and events that will take place over the next few months as we move through the phases of the project. The kickoff meeting will be attended by members of the Agency Advisory Group. The Advisory Group is comprised of agency staff who have graciously volunteered to represent Datamart users on the Query Tool Project. There are 16 members representing 10 state agencies. (See page 3 for a listing of members.)
The first order of business will be to look at the current state, begin discussing the various options, where we want to be, and how we should proceed.
See Survey on Page 2
Happy New Year!
See Project on Page 3
">
</td>
</tr>
</table>
</body>
</html>