Bilingual Fertility Rate Analysis Report

A static view of a Power BI report with callouts demonstrating the different functionalities used to visualize the data.

In 2024, I had the idea to explore Statistics Canada data related to fertility rates in Canada. The data is of interest to me, and relevant, as fertility rates have declined to their lowest point in Canadian history.

The visualizations below are examples of data storytelling with callouts to demonstrate the functionalities of Power BI. I use these visualizations to show how the different can functionalities help audiences understand the data better. I often use these types of simple visuals with storytelling to answer questions in a business context.

Data Sources:

  1. Statistics Canada. Table 13-10-0418-01  Crude birth rate, age-specific fertility rates and total fertility rate (live births)

  2. Statistics Canada. Table 13-10-0415-01  Live births, by month

A line chart demonstrating declining fertility rates in Canada from 1990 to 2020 with a forecasted trend to 2030
Line charts demonstrating fertility rates by region highlighting the higher rates in Nunavut
A line chart showing birth rates by month and region

Client
Personal Project

Year
May 2024

A line chart demonstrating fertility rates by age groups in Canada. Women are more likely to have children when they are older than 30 years of age.
A line chart demonstrating patterns in birth rates by month.
A line chart showing the birth rates by month in the North West Territories