Prerequisites
This chapter outlines what you need before working through the rest of this book. The goal is to ensure that all readers start from a shared baseline, regardless of prior experience.
Nothing here is advanced. If you can open Power BI Desktop and follow simple instructions, you are ready.
0.15 Software Requirements
0.15.1 Power BI Desktop
You need Power BI Desktop, which is free.
- Install it from the Microsoft Store (recommended): it updates itself automatically and doesn’t need administrator rights. You can also download an installer from Microsoft’s Download Center.
- Keep it up to date. Microsoft releases a new version every month and supports only the latest one.
Microsoft’s minimum requirements (October 2026):
- Windows 10 or later (64-bit). Windows on ARM is supported with the September 2025 cumulative update (KB5065789) or later.
- At least 2 GB of available memory; 4 GB or more recommended.
- A screen resolution of at least 1440 × 900.
- Windows display scaling at 100%; at higher scaling, some dialogs may not be visible.
All exercises in this book use Power BI Desktop.
Note on licensing: Power BI Desktop is free, and you don’t need a paid license for Chapters 1 to 8. Chapter 9 (publishing) needs a work or school account, and sharing with others needs a paid license. That chapter explains the options.
0.15.2 A Note for Mac Users
Power BI Desktop runs only on Windows. Options documented by Microsoft include:
- Windows 365 or Azure Virtual Desktop: Windows in the cloud, used from a browser or app on your Mac. Microsoft states that Power BI Desktop is fully supported on both.
- A Windows virtual machine on your Mac (for example, with Parallels Desktop). On Macs with Apple silicon this runs Windows on ARM, which needs the update listed above.
Some report and model editing is also possible in the Power BI service in a browser (see Chapter 3), but this book assumes Desktop.
0.16 Hardware Recommendations
The figures above are Microsoft’s minimums. Power BI loads data into memory, so in practice more memory makes work smoother. From the author’s experience:
- Memory: 8 GB or more.
- Screen: a second monitor helps: one for this book, one for Power BI.
0.17 Data Used in This Book
All practical exercises use a synthetic, patient-level integrated health dataset created specifically for learning.
The dataset represents routine service delivery across:
- Antenatal Care (ANC)
- HIV and ART
- Malaria
- Tuberculosis (TB)
- Non-Communicable Diseases (NCDs)
Privacy note: No real patient data is used. Patients and facilities are identified only by generated numbers.
The dataset is intentionally not clean. It includes missing values, inconsistent formats, and common data quality issues that reflect real health information systems. You will clean, model, and analyze this data step by step in later chapters.
0.18 Files You Will Work With
Download the following CSV files from the Data Dictionary and Access appendix and save them in one folder:
-
fact_patient_visits.csv(one row per patient visit: the line list) -
fact_targets.csv(quarterly targets per facility) -
dim_patient.csv(one row per patient: sex, age, HIV status) -
dim_facility.csv(one row per facility: type, ownership, location) -
dim_date.csv(one row per day in 2024)
These files form a star schema that is used throughout the book. The appendix describes every column.
Important: Do not edit these files manually in Excel. All cleaning and transformation will be done inside Power BI.
0.19 Knowledge Assumptions
This book assumes:
- basic familiarity with tables (rows and columns);
- comfort opening files and using software menus;
- no prior Power BI experience;
- no prior DAX experience;
- no database background.
If you have used Excel for reporting (even just for simple sums and filters), you are more than prepared.
0.20 How This Book Is Organized
Each chapter builds on the previous one.
- Why and how (Chapters 1–3): why Power BI matters, the mindset of starting from questions, and the parts of the Power BI ecosystem.
- Preparation (Chapters 4–5): connecting to data and cleaning it with Power Query.
- Modeling (Chapter 6): building the star schema.
- Analytics (Chapter 7): defining indicators with DAX.
- Communication (Chapters 8–9): designing dashboards, then publishing and sharing them securely.
Most exercises tell you the result you should see, so you can check your work as you go.
Practical exercises are included in most chapters. You are encouraged to follow along in Power BI rather than reading passively.
0.21 Before You Continue
Before moving to the next chapter, confirm that:
- Power BI Desktop opens without errors.
- You have downloaded the five sample CSV files into one folder.
- You have created a folder (for example,
My Power BI Project) to save your work.
Once these are in place, you are ready to begin.
The next chapter explains why Power BI matters for Monitoring and Evaluation, and how it fits into real program workflows.
Power BI for M&E and Public Health Data Analysts · The Growing Analyst