801 - Developing for Data Repository with Microsoft Power BI
Instructor: Ian Proffer
Organization: Acmeware, Inc.
Duration: Half day
In part 2 of our two-part Sunday Seminar on Microsoft Power BI, we’ll take in in-depth look at the ins and outs of using Microsoft Power BI Desktop with the MEDITECH Data Repository. The atypical database schema of the DR isn’t quite what Power BI expects when connecting to a data source, so we’ll look at different connectivity options and different ways you can use SQL code to efficiently present data to Power BI. We’ll talk about data models, the heart of any Power BI-based report, and demonstrate how to build them effectively in Data Repository.
If you can bring a laptop, we’ll guide you through building a real BAR-based data model and report 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. If you don’t have a laptop, don’t worry, you can follow along as our instructors show you how. When you’re finished, you’ll have a report you can use with your own MEDITECH Data Repository after you return home from the conference.
We’ll walk through the Power BI service options after your report is published, showing how you can use workspaces, apps, and dashboards to make reporting easy for your users while managing security and permissions securely. Finally, we’ll look at how you can keep your datasets current, connect to your on-premises servers using a gateway, and optionally manage report delivery using deployment pipelines.
If you’re considering using Microsoft Power BI with MEDITECH, this is the session for you!
Attendees will gain a deeper understanding of Power BI Desktop and service (online) tools and applications. Optionally, if they bring a laptop, attendees will gain first-hand knowledge of Power BI Desktop while they design their own report during the seminar.
Suggested prerequisite knowledge:
- Familiarity with MEDITECH Data Repository
- Beginning to intermediate skills with report design applications
Instructor: Ian Proffer
Ian Proffer is Acmeware’s Director of Communication and Training. Before joining Acmeware in 2007, he spent seven years in healthcare IT at Jefferson Healthcare in Port Townsend, WA (a MEDITECH C/S site) and Harborview Medical Center in Seattle. Ian has worked for the last 20 years as a consultant, report writer, database analyst, administrator, and architect, including four years at Microsoft Corp. His practical work experience in healthcare includes database analysis and administration, report and application authoring and development, and user education and training.