Two published dashboards, built so the visuals read in sequence rather than being browsed at random.
Acting as an analyst for a global health organisation needing to understand health trends and disparities across countries and continents. Five worksheets were combined into one dashboard, with a Country filter and Continent and Gender colour legends exposed as dashboard controls, plus a phone layout alongside the desktop one.
Life Expectancy by Continent as a sorted horizontal bar for the latest year. Life Expectancy Trend as a line chart limited to the Top 5 countries with country on colour. Population by Gender as a pie chart labelled as percentage of total. Life Expectancy vs BMI as a scatter with country on detail and continent on colour. Blood Pressure by Continent as a self-directed extension visual.
Life expectancy varies markedly between continents and improves over time in the highest performers.
Population splits close to evenly by gender — approximately 50.6% against 49.4%.
Europe records the highest average blood pressure among the continents charted.
The scatter plot shows a relationship between BMI and life expectancy — an association only, not evidence of causation.
A health service such as the NHS could use a dashboard of this shape to identify health inequalities, compare population groups, target prevention programmes and monitor change over time.
Open exploration of Spotify track features with no fixed brief — average popularity by genre as a sorted bar across 26 genres, danceability against popularity as a scatter with genre on colour, and energy against valence as a bubble scatter with popularity on size.
Pop, Rap and Rock record the highest average popularity. Danceability shows a slight positive relationship with popularity, but with enough exceptions that it does not predict success on its own. Most genres cluster around medium-to-high energy and moderate valence.
Top N filters, single-value dropdowns, dashboard-level filters applied across several worksheets, Quick Table Calculations converting a sum to Percentage of Total, and deliberate use of AVG over SUM so averages are not distorted by differing row counts per country and year.