References and Key Frameworks
While this book focuses on practical implementation, the methodologies used are grounded in established standards for data warehousing, visualization, and public health monitoring.
Below are the primary sources and frameworks that informed the structure of this guide.
B.1 1. Data Modeling & Warehousing
The “Star Schema” approach used in Chapter 5 is based on Dimensional Modeling theory.
- Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling. Wiley. (The industry standard for star schema design).
B.2 2. Data Visualization Theory
The design principles in Chapter 12 (The 5-Second Rule, Z-Pattern) draw from cognitive psychology and information design.
- Knaflic, C. N. (2015). Storytelling with Data: A Data Visualization Guide for Business Professionals. Wiley.
- Few, S. (2004). Show Me the Numbers: Designing Tables and Graphs to Enlighten. Analytics Press.
B.3 3. M&E and Public Health Standards
The indicator definitions and synthetic data structure align with common global health frameworks.
- World Health Organization (WHO). (2020). Data Quality Review (DQR) Toolkit. (For data quality checks and validation logic).
- DHIS2. DHIS2 User Guide / Analytics. (For the logic behind facility-district-province hierarchies).
B.4 4. Microsoft Power BI Documentation
Technical features and DAX behaviors change frequently. The official documentation remains the primary reference.
- Microsoft Learn. Power BI Documentation. https://learn.microsoft.com/en-us/power-bi/
© 2025 Oluwatobi Olatunbosun ·
CC BY-NC-SA 4.0
Power BI for M&E and Public Health Data Analysts
Power BI for M&E and Public Health Data Analysts