Page 301 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

The other option you get is the Add this data to the Data Model. This will allow you to use the data output in Power
Pivot and use other Data Model functionality like building relationships between tables. The Data Model Excel’s
new efficient way of storing and using large amounts of data.
The Queries & Connections Window
When you’re working outside of the power query editor, you can see and interact with all the queries in the
workbook through the Queries & Connections window. To open this, go to the Data tab in the regular Excel ribbon,
then press the Queries & Connections command button found in the Queries & Connections section.
When opened it will be docked to the right hand side of the workbook. You can undock it by left clicking on the title
and dragging it. You can drag it to the left hand side and dock it there or leave it floating. You can also resize the
window by left clicking and dragging the edges.
This is very similar to the query list in the editor and you can perform a lot of the same actions with a right click
on any query.
One option worth noting that’s not in the query list right click menu, is the Load To option. This will allow you to
change the loading option for any query, so you can change any Connection only queries to load to an Excel table
in the workbook.

288

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77