There are two different things here, compute and storage.
The different SKU's of virtual machines offer different hardware profiles, different amounts of CPU, Memory, Disk and Network, and different ratios of each of these.
The different storage tiers (Hot, Cool, Archive) offer different levels of SLA and retrieval times with different costs to reflect that.
If you are looking for more information please add some more details to your question.