User FAQs

If you have a question, please send it to us.

1) What is Power Query ?
This is all about getting the data.
Creating data sources, making connections, shaping and tranforming the data.
This includes the power query editor.

2) What is Power Pivot ?
This is all about analysing the data.
This is an extension to the pivot table functionality.
Additional features include - import from multiple sources, advanced calculations, larger data sets, can use the DAX formula language.

3) What is Power View ?
This is all about presenting the data
Creating dynamic/interactive visualisations including charts, dashboards, maps
This is available through Power BI desktop and fully integrates with both Power Query and Power Pivot.

4) What is a Data Model ?
data models can be saved inside workbooks

5) What is a Linked Table ?

6) When would you use the Goal Seek data analysis feature ?
This can be used to calculate an unknown value in a given formula.

7) When would you use the Scenario Manager data analysis feature ?
Lets you construct various different scenarios with your data and allows you to perform 'what if' analysis.

8) What is an Data Table ?
Not to be confused with a regular table.
This is a type of What If data analysis that creates a table based on the impact of one (or two) variables in a formula.
They provide a way to calculate multiple variations and display and compare the results in a table layout.
There is even a calculation option called "Automatic except for data tables".

9) When is the Quick Analysis Smart Tag displayed ?
It is displayed everytime you select two or more adjacent cells.

10) What features can be found on the Quick Analysis Smart Tag ?
This smart tag provides quick access to 5 features:
Formatting, Charts, Totals, Tables, Sparklines