781.329.4300 ¦ 
Live online Data Repository training.
Looking to learn about Data Repository using Microsoft reporting tools? Come to our live, instructor-led classes, geared toward your skill level and experience. Sessions including lecture, demos, and time for you to work on learning exercises in a lab environment. Choose standlone or "build your own" topics subjects encompassing SQL Server, Power BI, and more.
Shout out to for an excellent class from Acmeware. Ian was an excellent teacher.
His instruction was like chatting with an old friend while being informative with on-point content.
– Carrie R., Douglas Omaha Technology Commission
Standalone classes
Power BI Fundamentals for DR
Want to learn a better way to present information from MEDITECH Data Repository? Come to this class to get immediate hands-on experience with Microsoft Power BI Desktop. Power BI puts dynamic and interactive report design at your fingertips, making it easy improve your business and clinical analytics with simple to use and cost-effective report design tools.
In this class, we’ll introduce you to the different desktop, server, and cloud-based components of Microsoft’s business intelligence platform. Then we’ll dive in and show you how to build your own inpatient dashboard with Power BI Desktop while demonstrating some of the software’s niftier features - like slicers and drill-through capability - that will give your reports a great user experience.
Class duration: 3 hours
Suggested prerequisites: An understanding of MEDITECH applications and SQL Server Management Studio.
Cost and scheduling
Build your own class
Choose from the following classes below, based on your needs and experience.
We'll work with you to build the class lineup that's best for you.
DR 101: Start Here (2 hours)
These beginner-level topics are for those new to MEDITECH, Data Repository, and SQL Server.
- MEDITECH and Data Repository concepts and organization
- Relational database basics
- Explore the DR schema with Management Studio
- Available for Expanse, C/S and MAGIC
SQL 101: Writing T-SQL Queries (2 hours, with exercises)
This is an introduction to writing T-SQL queries for anyone with no previous experience.
- Using Management Studio to write and save queries
- The basics of SELECT, FROM and WHERE
- Introducing basic T-SQL operators
- Coding best practices
- Available for Expanse, C/S and MAGIC
Cost and scheduling
SQL 201: Using JOIN with Common DR Tables (2 hours, with exercises)
This class is for the new report writer looking to move beyond the basics with T-SQL.
- The basics of using JOIN
- Using stored procedures
- Follow the primary keys: common tables from REG, HIM, BAR, and more
- JOIN techniques in Data Repository
- Available for Expanse, C/S and MAGIC
SQL 220: T-SQL Expressions and Functions (2 hours, with exercises)
This class introduces different approaches for handling the unique challenges of reporting from DR.
- What are T-SQL expressions?
- Commonly used system functions for handling dates, NULL values, and more
- Working with aggregate functions
- Using parameters in stored procedures
- Available for Expanse, C/S and MAGIC
Cost and scheduling
EXP 101: How Expanse DR is Different (2 hours)
This class is for the experienced MAGIC, C/S or 6.0 Data Repository report writer who's ready for Expanse.
- Expanse architecture overview
- DR database schema changes and object-naming conventions
- Manging legacy DR systems and reports
EXP 201: New Applications and DR Tables (3 hours)
We'll highlight the significant changes within key applications, with an eye toward converting your existing library of DR and NPR reports.
- Goodbye ADM and MRI, hello REG and HIM
- Changes in ABS, including common table conventions
- What's new in patient accounts/BAR
Cost and scheduling