When you start a new game or load a new game watch for the in game advisor button to appear at the top left of your screen. Clicking on your faction button or one of your cities will cause him to appear. Having clicked on his portrait he will ask you to activate the script which is done by clicking the "show me how" button immediately below his portrait.