The Staff of Dread Zombies is necromancy in a stick. It copies the Conjuration spell Dread Zombie, reanimating a very powerful dead body to fight for you for 60 seconds. Point it at the biggest corpse in the room and watch your former enemy switch sides. It suits any character, but players without strong Conjuration get the biggest lift from it.
Where to find it
The best-known source is the Aspiring Mage, a random encounter carrying the staff. You can persuade him to give it up, pay him for it, or kill him and take it. Mages at the College of Winterhold sell it, and it can turn up as random loot. With Dragonborn, you can craft one at Neloth‘s Staff Enchanter in Tel Mithryn from four
Heart Stones and an Unenchanted Conjuration Staff.
Is it worth using?
Yes, especially in tough fights. A raised giant or bandit chief is a serious ally for a full minute. It uses its own charge rather than Magicka, and a higher Conjuration skill lowers the charge per use, according to the source. The recharge is about the size of a grand soul gem, so carry big gems. One nice side effect: the corpse is already there, so you need no prep, just a body and a bad attitude.
Stats from the Skyrim game files; locations checked against community wiki articles, written in our own words.

