Microsoft Office Tutorials and References
In Depth Information
Building a query is always a complex step because it requires a good knowledge of the data
model you are querying. SQL technicians normally write queries using a standard text editor
because they already know how to retrieve data. Because you are probably not a SQL
technician, you are interested in using the PowerPivot query designer, which is a tool that lets you
build a SQL query through a visual interface. Even if the query designer handles the hard
work for you, understanding the final query structure lets you understand better what the
query designer is asking.
To open the query designer, you need to go to the PowerPivot window, click Existing Connections,
choose the connection to AdventureWorks and then select Open. In the previous chapters, you
always used the first option—that is, you selected the tables you wanted to import from the list
of tables. This time you choose Write A Query That Will Specify The Data To Import, and click
Next. You reach the query editor dialog box shown in Figure 4-20. In the companion workbook
CH04-04-SQL_Query.xlsx, you find the data already loaded and the query ready to be examined.
The query editor is a simple text editor with which you can start to write the SQL query and
give it a friendly name. Because you are probably not a SQL expert, it is much better to click
on the Design button to invoke the query designer.
FIguRE 4-20 The SQL query editor.