Healthcare Business Intelligence, + Website A Guide to Empowering Successful Data Reporting and Analytics

Increasing regulatory pressures on healthcare organizations have created a national conversation on data, reporting and analytics in healthcare. Behind the scenes, business intelligence (BI) and data warehousing (DW) capabilities are key drivers that empower these functions. Healthcare Business Intelligence is designed as a guidebook for healthcare organizations dipping their toes into the areas of business intelligence and data warehousing. This volume is essential in how a BI capability can ease the increasing regulatory reporting pressures on all healthcare organizations.

• Explores the five tenets of healthcare business intelligence
• Offers tips for creating a BI team
• Identifies what healthcare organizations should focus on first
• Shows you how to gain support for your BI program
• Provides tools and techniques that will jump start your BI Program
• Explains how to market and maintain your BI Program

The risk associated with doing BI/DW wrong is high, and failures are well documented. Healthcare Business Intelligence helps you get it right, with expert guidance on getting your BI program started and successfully keep it going.

Foreword xi

Preface xiii

Acknowledgments xvii

Chapter 1 Business Intelligence 1

What BI Isn’t 2

Do You Need BI? 3

Healthcare Information Environment 4

Data Modeling 9

The Don’ts 10

Chapter 2 The Tenets of Healthcare BI 13

The Tenets 15

Data Quality 17

Leadership and Sponsorship 22

Technology and Architecture 26

Providing Value 31

Cultural Implications 35

Seeking Equilibrium 35

Chapter 3 Data Quality 39

Data Quality Implications for Healthcare 40

Data Governance 42

Data Profiling 58

Chapter 4 Leadership and Sponsorship 67

Leading a BI Initiative 68

Why Sponsorship Is Critical 80

Chapter 5 Technology and Architecture 101

The “Abilities”: Scalability, Usability, Repeatability, Flexibility 104

Scalability 106

Usability 110

Repeatability 117

Flexibility 130

Chapter 6 Providing Value 135

Creating a BI Team 136

User Adoption 144

The BI User Persona Continuum 149

Six Steps to Providing Value 152

Chapter 7 Gauging Your Readiness for BI 175

Stop 181

Proceed with Caution 186

The Go Stage 191

Chapter 8 Future Trends in Healthcare BI 195

Web 2.0 and Social Media 197

Mobile Technologies for Healthcare BI 204

Analytics: More Than a Buzzword 206

Creating a Data-Driven Organization 208

Big Data and Why It Matters 211

To the Cloud! 212

Chapter 9 Putting It All Together 215

Year One 216

Get Some Support 217

Governance Structure 220

Projects with Value 221

Technology and Architecture Gaps 223

Architectural Gaps 229

Cultural Preparedness 230

Marketing the Program 230

Manage the Inaugural Effort 232

Build Supporting Processes and Infrastructure 234

Train and Deploy 236

Operationalize the BI Function 238

KPIs for Healthcare 239

Departing Thoughts on Healthcare BI 240

Appendix A Data Governance Policies and Procedures 243

Appendix B Business Intelligence Reporting Tool 253

Appendix C Business Intelligence Road Map Template 265

Appendix D Business Intelligence Marketing Plan Template 281

Appendix E Status Report Template 285

About the Website 289

About the Author 291

Index 293

LAURA B. MADSEN, MS, is founder of the Healthcare Business Intelligence Summit and international keynote speaker on healthcare BI. She brings more than a decade of experience in BI and data warehousing for healthcare. Laura leads the Healthcare Practice for Lancet, a leading BI consulting firm headquartered in Minneapolis, Minnesota. At Lancet, she spearheads strategy and product development for the healthcare sector and works with key accounts across the country in the provider, payer, and healthcare manufacturing markets. Prior to joining Lancet, Laura held senior positions with several leading healthcare companies, including UnitedHealth Group. Her responsibilities included leading an enterprise BI project from pre-concept to execution, managing a commercially available suite of BI tools, and advising both business and IT leaders on effective healthcare BI practices.