The use of analysis is done mainly via the ribbon in excel. Individual features in the ribbon are enabled or disabled based on the type of data displayed and selected (Greyed out if disabled).
Description of the "Analysis" tab
Group
Icon
Description
Insert Data source : Insert a query in the selected excel cell/sheet