MoMA Art Explorer Tool

Overview

An interactive, Excel-based dashboard to explore the Museum of Modern Art (MoMA) collection by Nationality, Artist, and Minimum Year of Creation, and to display the earliest qualifying artwork with rich metadata and an embedded image.

The MoMA Art Explorer Tool successfully transforms a large, complex museum dataset into an intuitive and interactive platform that can be used by curators, researchers, and art enthusiasts to explore the Museum of Modern Art’s vast collection with ease. Through the strategic use of advanced Excel features — including data cleaning functions, dynamic dropdowns, conditional filtering, and embedded images — the tool bridges the gap between static records and actionable insights.

From a functional standpoint, the tool streamlines the process of identifying and analyzing an artist’s earliest work on display after a specified date, filtered by nationality. This eliminates the need for time-consuming manual searches and ensures that relevant information is delivered quickly, accurately, and in a visually engaging format. By embedding images of the artworks directly into the dashboard, it enhances the curator’s ability to connect the data with the actual piece, fostering a deeper appreciation and contextual understanding of the collection.

In conclusion, this project not only fulfills its intended purpose of assisting MoMA’s curatorial team in artwork exploration but also stands as a strong portfolio example of applying data analysis skills to solve real-world challenges. It demonstrates how thoughtful design, combined with technical proficiency, can transform raw datasets into powerful decision-making tools that add lasting value to an organization.