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 

GroupIconDescription

Insert Data source : Insert a query in the selected excel cell/sheet

Refresh All

Reloads all the queries in the workbook

GroupIconDescription

Undo

Undo Last Step Analysis.

Ready

Redo Last Step Analysis.

GroupIconDescription

Prompt

Enter values for Query parameters and variables

Filter

Define filter criteria for data

Sort – Sort data

Hierarchy – Expansion level / Parent member positions

Calculations – Ranking / Cumulation 

Add Dynamic calculation, Calculation, Advanced Calculation