For making your text sand take a look at the following tutorials here on the COW: Exploding Text in Apple Motion – Part 1
and
Exploding Text in Apple Motion – Part 2
Also take a look at the Particle Metrix: https://idustrialrevolution.com/idrplugins/particlemetrix/index.html
Zak Peric has a tutorial on making text into sand with the Particle Metrix plug-in. Plus the Particle Metrix plug-in has a free trial.
AS for the reveal of the logo, if you can make your sand black and white with the level filter so the sand is white and everything else is black you can do an image mask to reveal it. If you have never done an image mask check out this tutorial I did on creating a hologram. What you are after is in the middle of the tutorial. If not you will have to do a mask. Be sure to add a feather to it.
Hope this helps. Best of luck.
Stephen Smith
Utah Video Productions
Check out my Motion Training DVD
Check out my Motion Tutorials