![]() In this example, we’re going to query a database in SQL that holds sales data for an organization and import the results into Excel. So, now that you have some basic SQL skills and tons of data, how do you go about analyzing it? In this article, we’re going to run through a use case of querying data in SQL Server and analyzing it using some simple features and functions in Excel, as well as the SQL Spreads Add-In for Excel. In our Introduction to SQL for Excel Users, we gave an overview of SQL Server and went through the basics of constructing SQL queries. It’s therefore just a case of learning some new terminology.
0 Comments
Leave a Reply. |