Allscripts Database Architecture and Reporting Workshop At ACE
When: July 28 – 29th, 2009
Where: Orlando, Florida during the ACE pre-conference sessions
Price: $1500
Expert training on the AE EHR database is key to understanding this complex data
model.
The Allscripts Database Architecture and Reporting Workshop will provide you with the
fundamentals necessary to build reports out of the Allscripts Enterprise EHR Database.
Throughout the two day event we plan to review the key tables within the Allscripts databases,
strategies for reporting repositories, deployment methods, and we will walk through reporting
examples provided by the different attendees.
- Course Highlights
- Enterprise EHR Database Architecture Review (key tables)
- Develop Reports Based on Attendee Submissions
- Review Reporting Methodologies
- Review Report Deployment Methods
- Recommended Audience
- Reporting Analysts and Architects: Your decision support or reporting group is
likely flooded with requests for reports from Allscripts. We recommend using a
data warehouse of some sort for reporting (direct copy of production, or one
populated by an ETL process). The reporting analysts and architect(s) within
your organization will need to understand the Allscripts EHR data model in order
to service these report requests. They will obtain a thorough review of the key
tables in the Allscripts database, how they link together (foreign keys are
frequently not available), and the challenges found in retrieving data from the
EHR database. Data warehouse options and design considerations will be
reviewed. - Database Administrators: The DBA will obtain a thorough review of the key
tables in the Allscripts database, how they link together (FKs are frequently not
available), and the challenges found in reporting from the EHR database – both
in the data structure for reporting and performance impact of the queries and
how the transactional data model affects the ability to write efficient reporting
queries. Data warehouse options and design considerations will be reviewed. - Physician IT leaders – we have trained a handful of physician-cum-IT directors who have had great success in understanding the data model, and being able to use both ad-hoc queries to make quick analyses of situations, and help their team write meaningful reports.
- IT leaders – often times the managers and directors of IT groups are not hands-on writing reports. There are times, however, that leaders within the IT organization need to understand the EHR data model at a detailed level. The course is a perfect match for this situation.
- Reporting Analysts and Architects: Your decision support or reporting group is
- Prerequisites
- Prior knowledge of T-SQL is essential. Querying including multiple joins, CASE statements, temporary tables and GROUPing should be an area of comfort for the attendees.
- An understanding of the Allscripts Enterprise EHR with regards to management/admin and end-user use is required.
- A basic understanding of the Allscripts Enterprise EHR databases is preferred, but not necessary
- Prior use of Crystal Reports and SQL Server Reporting Services will also be helpful.
Allscripts Analytics and ETL– this course is well-suited for groups who already have Analytics or the Allscripts ETL, as well as those who don’t. We will cover a variety of data not available in
Analytics/ETL, as well as allowing your DBA group to query the data real-time, such as needed during performance or error troubleshooting.
Attending this Course
Contact Mike Dow for more information and to sign up. Space is limited and seats will be filled
on a first-come, first-served basis.
Mike.Dow@GalenHealthcare.com
617-379-0840
