It's important to understand that regardless of how big or small you choose to print an image, the total number of pixels within that image remains unchanged.Instead, as you scale up your image, the DPI decreases and the printed size of each pixel increases. Scale up too much and you'll be left with a pixelated mess. We made this graphic to help explain how pixel size impacts DPI in print.
Picture a jar of marbles. The jar is your image before you print, and each marble is a pixel. Now get a bigger jar. This new jar represents a scaled-up print of your image. What are the marbles going to do? They can't just leave all that empty space, can they? In order to fill the jar, the marbles have to get bigger, and the overall density (or marbles per square inch) decreases. In the same way, when you increase the printed size of an image, the pixels have to get bigger, so the overall pixel density (DPI) decreases. This process works in reverse as you scale down an image to print (the same marbles (pixels) have to fit in a smaller jar (picture frame), so they get more dense). To ensure a great print at any size, always start with the highest quality image possible (even a perfect DPI can't turn a low-quality image into a Rembrandt). As you size your image for print, we recommend aiming for a target DPI range of no less than 150 DPI. 300 DPI is considered ideal for printing anything that is meant to be held or viewed at a short distance [More on distance & DPI later].
Sidebar: If you're utilizing your own design software, don't be alarmed if your image's DPI is expressed as pixels/inch. It's still DPI.