References and Key Frameworks
This book focuses on practical implementation. The sources below informed its approach.
B.6 Data Modeling
The star schema approach in Chapter 6 is based on dimensional modeling.
- Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Wiley.
B.7 Data Visualization
Chapter 8 draws on the following works on visualization 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.8 Health Data Quality and Information Systems
World Health Organization. (2023). Data quality assurance: module 1: framework and metrics. Geneva: WHO. https://www.who.int/publications/i/item/9789240047365
DHIS2. DHIS2 Documentation. https://docs.dhis2.org/
World Health Organization. (2023). The role of HIV viral suppression in improving individual health and reducing transmission: policy brief. Geneva: WHO. https://www.who.int/publications-detail-redirect/9789240055179
Centers for Medicare & Medicaid Services. CMS cell suppression policy. https://www.hhs.gov/guidance/document/cms-cell-suppression-policy
B.9 Data Platforms
- DHIS2. Personal access tokens and Analytics (Web API). https://docs.dhis2.org/
- KoboToolbox. Connecting KoboToolbox to Power BI. https://support.kobotoolbox.org/pulling_data_into_powerbi.html
- ODK. Managing Submissions in Central (OData). https://docs.getodk.org/central-submissions/
B.10 Microsoft Power BI Documentation
Power BI features change every month. The official documentation is the primary reference. The pages below were used to check the 2026 revision of this book (October 2026).
- Microsoft Learn. Power BI documentation. https://learn.microsoft.com/en-us/power-bi/
- Power Query: Data types, Data profiling tools, Working with duplicate values, Replace values, Text/CSV connector. https://learn.microsoft.com/en-us/power-query/
- Modeling: Understand star schema, Many-to-many relationship guidance, Create and manage relationships, Set and use date tables, Auto date/time. https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
- DAX: DAX function reference, Implement time-based calculations, Visual calculations, DAX user-defined functions, DAX query view. https://learn.microsoft.com/en-us/dax/
- Reports: Card visual, Analytics pane, Design reports for accessibility, Mobile-optimized reports. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports
- Sharing and security: Microsoft Fabric licenses, Roles in workspaces, Row-level security, Data refresh, Publish to web. https://learn.microsoft.com/en-us/fabric/enterprise/licenses
- Power BI pricing. https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing
Power BI for M&E and Public Health Data Analysts · The Growing Analyst