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

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.

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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.