On Oblivion
Your base Magicka is determined by multiplying your Intelligence by 2, then adding in any Racial and Birthsign bonuses.
No Birthsigns give Intelligence boosts.
Increasing your Intelligence past 100 will continue to give you increased Magicka.
 On Morrowind
Affects your total Magicka and magic use. Governs the skills of Alchemy, Enchant, Conjuration, and Security.
Related ThreadsStarting NG with a Sorcerer...help w/ intelligence? - last post by @ Jan 23, 2012
Good Intelligence/Faith Build? - last post by @ Jan 27, 2014
Dexterity/Intelligence Build Help - last post by @ Dec 10, 2013