Go to File > New > Background Content: Transparent.
You will see a checkerboard patterned workspace.
If you're talking about making part of an image you already have partially transparent, you'll need to make it a true layer (so that is e.g., Layer 0, not Background), then mask the part of it you want to see through. There are tutorials on doing masking on Adobe TV. For example: