BI & HANA: Case study: Architecting data for self-service BI — How American Red Cross leveraged dimensional modeling techniques alongside the information design tool to achieve success

  • by Ken Coleman, American Red Cross
  • March 1, 2019
Find out how the American Red Cross overcame architectural data challenges specifically associated with deploying self-service BI to a portion of its 6,000 users nationwide.

Find out how the American Red Cross overcame architectural data challenges specifically associated with deploying self-service BI to a portion of its 6,000 users nationwide — a common roadblock to many organizations. Understand why dimensional modeling is essential for an effective self-service program, how the approach works in synergy with the information design tool to simplify universes, and gain step-by-step instructions based on the company’s methodology, including how it: 

  • Uses "shared dimensions" within the information design tool to simplify the semantic layer for self-service BI users when a dimensional model is used
  • Architects dimensional summary tables to deliver the performance and row limitations required for self-service
  • Leverages a powerful data architecture technique — accumulated fact tables — to avoid the need to merge multiple data sources within SAP Lumira


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.