Page 292 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

We will choose to load the data into a table in a new sheet, but there are several other options. You can also load
the data directly into a pivot table or pivot chart, or you can avoid loading the data and just create a connection
to the data.

Now the tables are loaded into new sheets in Excel and we also have two queries which can quickly be refreshed
if the data in the original workbook is ever updated.
The Query Editor

After going through the guide to connecting your data and selecting the Edit option, you will be presented with
the query editor. This is where any data transformation steps will be created or edited. There are 6 main area in
the editor to become familiar with.

1 The Ribbon – The user interface for the editor is quite similar to Excel and uses a visual ribbon style command
center. It organizes data transformation commands and other power query options into 5 main tabs.
2 Query List – This area lists all the queries in the current workbook. You can navigate to any query from this
area to begin editing it.
3 Data Preview – This area is where you will see a preview of the data with all the transformation steps currently
applied. You can also access a lot of the transformation commands here either from the filter icons in the
column headings or with a right click on the column heading.

279

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