You are previewing SAS Business Intelligence for the Health Care Industry.
O'Reilly logo
SAS Business Intelligence for the Health Care Industry

Book Description

SAS Business Intelligence for the Health Care Industry: Practical Applications teaches health care executives, managers, providers, and business analysts how to use SAS Business Intelligence (BI) tools to convert data into knowledge and value at all levels in the health care industry.

This book demonstrates how SAS BI solutions can be applied to the health care industry and offers detailed explanations of code and tasks in an approachable case study format. All applications are created with sample data that has the richness and complexity of operational health care data. Topics include:

  • using SAS Add-In for Microsoft Office and SAS Stored Processes technology to better track and forecast revenues and margins
  • creating OLAP and relational web reports that enable care management programs to locate and assist the neediest patients
  • implementing data access restrictions on OLAP and relational data in accordance with the industry's need for secure data access
  • creating dashboards to help executives monitor their health care organization

With its level of depth and perfect blend of technology and business contexts, this book provides health care analysts, researchers, and statisticians with information and examples that can be used effectively and immediately. It is an indispensable aid to the health care professional in keeping up with a fast-changing industry.

Table of Contents

  1. About This Book
  2. About The Authors
  3. Acknowledgments
  4. Chapter 1: An Overview of SAS Business Intelligence
    1. 1.1 Introduction
    2. 1.2 Features of the US Health-Care Industry
      1. 1.1.2 Public Insurance Programs
    3. 1.3 Data Used in This Book
    4. 1.4 SAS BI Solutions for the Health-Care Industry
    5. 1.5 Conceptual Architecture of SAS BI Platform
    6. 1.6 Physical Architecture of the SAS BI Platform
    7. 1.7 Types of SAS BI Tools
    8. 1.8 Seamless Integration between SAS BI Tools
    9. 1.9 SAS Metadata: The Glue That Holds It All Together
    10. 1.10 Features of the SAS BI Platform
    11. 1.11 Description of SAS BI Applications
    12. 1.12 Conclusion
  5. Chapter 2: Creating SAS Stored Processes for the Finance Department
    1. 2.1 Introduction
    2. 2.2 Basic Stored Processes
      1. 2.2.1 Tabulating Charges by Dates of Service and Payment
      2. 2.2.2 Calculating Historical Ratio of Paid/Charged Amounts
      3. 2.2.3 Tracking Revenues, Costs, and Enrollment
    3. 2.3 Advanced Stored Processes
      1. 2.3.1 Creating a Stored Process with Linked Prompts
      2. 2.3.2 Chaining Stored Processes
    4. 2.4 Modifying a Stored Process
    5. 2.5 Creating Stored Processes with Complex Macro Programming
      1. 2.5.1 Multiple Values Selection in Prompt
      2. 2.5.2 All Possible Values Selection in Prompt
    6. 2.6 Conclusion
  6. Chapter 3: SAS Add-In for Microsoft Office for the Business Analyst
    1. 3.1 Introduction
    2. 3.2 Running a SAS Stored Process
    3. 3.3 Querying Warehouse Data with SAS Add-In for Microsoft Office
    4. 3.4 Analytical Tasks with SAS Add-In for Microsoft Office
      1. 3.4.1 Generating Monthly Revenues with the Summary Tables Wizard
      2. 3.4.2 Using the Summary Tables Task
      3. 3.4.3 Using SAS Add-In for Microsoft Office Graph Task
    5. 3.5 Customizing the SAS Add-In for Microsoft Office
      1. 3.5.1 Presenting Results in the SAS Add-In for Microsoft Office
      2. 3.5.2 Scheduling and Sharing in SAS Add-In for Microsoft Office
    6. 3.6 Conclusion
  7. Chapter 4: Slicing and Dicing Data with OLAP Cubes
    1. 4.1 Introduction
    2. 4.2 OLAP Cube: Concepts and Definitions
    3. 4.3 Building a Cube with SAS OLAP Cube Studio
      1. 4.3.1 Creating a Cube Using the Cube Designer
      2. 4.3.2 Adding Calculated Items to the Cube
    4. 4.4 Using OLAP Cubes with SAS Add-In for Microsoft Office
      1. 4.4.1 Essentials of the SAS OLAP Analyzer
      2. 4.4.2 Adding Measures and Moving Dimensions
      3. 4.4.3 Slicing and Dicing in the SAS OLAP Analyzer
      4. 4.4.4 Filtering and Slicing
      5. 4.4.5 Creating Computed Measures
      6. 4.4.6 Conditional Highlighting
      7. 4.4.7 Bookmarking a Customized Cube View
    5. 4.5 Conclusion
  8. Chapter 5: Building a Data Bridge with SAS Information Map Studio
    1. 5.1 Introduction
    2. 5.2 Navigating SAS Information Map Studio
    3. 5.3 Creating an Information Map
      1. 5.3.1 Identifying External Tables
      2. 5.3.2 Joining Tables
      3. 5.3.3 Organizing Content in Folders
      4. 5.3.4 Setting Properties
      5. 5.3.5 Creating Computed Items
      6. 5.3.6 Creating Filters
      7. 5.3.7 Revisiting Data Item Properties
      8. 5.3.8 Features of the Hot Spotters Information Map
    4. 5.4 Maintaining and Updating an Information Map
    5. 5.5 Creating an Information Map with Prompted Linked Filters
    6. 5.6 Conclusion
  9. Chapter 6: Effective Patient Management with SAS Web Report Studio
    1. 6.1 Introduction
    2. 6.2 Creating Population Lists
    3. 6.3 Application Architecture
    4. 6.4 The Basics of SAS Web Report Studio
      1. 6.4.1 Accessing SAS Web Report Studio
      2. 6.4.2 Creating a Summary Report
      3. 6.4.3 Working with Report Results
      4. 6.4.4 Saving a Report and Exporting Results
    5. 6.5 Creating Prompted Reports
      1. 6.5.1 Creating the Population List Report
      2. 6.5.2 Creating the Member Profile Report
    6. 6.6 Linking Reports
    7. 6.7 Conclusion
    8. 6.8 Notes
  10. Chapter 7: Data Security and Dynamic Updates with SAS Information Map Studio
    1. 7.1 Introduction
    2. 7.2 Data Security in an Information Map
      1. 7.2.1 Restricting Access to Claims Data
      2. 7.2.2 Restricting Access to Medical Diagnoses
    3. 7.3 Dynamic Data Updates
    4. 7.4 Scheduling and Distributing a Report in SAS Web Report Studio
      1. 7.4.1 Distributing Reports Conditionally
    5. 7.5 Conclusion
  11. Chapter 8: Advanced OLAP Applications in the Health-Care Industry
    1. 8.1 Introduction
    2. 8.2 Creating a Multipurpose Cube
      1. 8.2.1 Creating a Star Schema Cube in SAS OLAP Cube Studio
      2. 8.2.2 Building an OLAP Information Map
      3. 8.2.3 Creating Multi-Sectioned Reports in SAS Web Report Studio
    3. 8.3 Implementing OLAP Data Security via MDX
      1. 8.3.1 Fundamentals of OLAP Concepts and Terminology
      2. 8.3.2 Creating MDX Expressions with SAS Enterprise Guide
      3. 8.3.3 Restricting Data Access with MDX
    4. 8.4 Computing Health-Care Metrics in an OLAP Cube
      1. 8.4.1 Data Manipulation
      2. 8.4.1 Summary Data Sets
      3. 8.4.3 Creating an OLAP Cube from Summary Tables
    5. 8.5 Conclusion
  12. Chapter 9: Creating Dashboards for the Health-Care Industry
    1. 9.1 Introduction
    2. 9.2 Elements of Effective Dashboards
    3. 9.3 SAS BI Tools for Dashboards
    4. 9.4 The Executive Dashboard
      1. 9.4.1 A First Look: Overall Dashboard Organization
      2. 9.4.2 A Quick Introduction to SAS BI Dashboard
      3. 9.4.3 Creating Indicators
      4. 9.4.4 Linking Indicators for an In-Depth Analysis
      5. 9.4.5 Putting It All Together in a SAS Dashboard0
      6. 9.4.6 Placing a Dashboard in SAS Information Delivery Portal
    5. 9.5 The Medical Management Dashboard
      1. 9.5.1 Overview of the Medical Management Dashboard
      2. 9.5.2 Understanding the Medical Management Dashboard’s Indicators
      3. 9.5.2 Using a Stored Process as a Data Source for Indicator Data
    6. 9.6 Conclusion
  13. Index