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. learning a new skill can be a fun and rewarding exercise.įinally, it’s worth pointing out that as an Excel user, you are already familiar with many of the key concepts in SQL.you can start using SQL query tools (like SQL Server Management Studio) to view and query data yourself, instead of asking a DBA to do it for you.

it will help you understand the importance of data structure, and may improve the way you use Excel.

it makes it easier to talk ‘data’ to your DBA team.

These Database Administrators (DBAs) or other professionals are experts in their field, so why should you need to learn how to use SQL? The answer, is of course, that you don’t have to learn SQL to use data from a SQL database, but there are some real advantages of learning some SQL for Excel users: Organizations that use SQL have dedicated people or teams to manage their SQL estates. This is where SQL steps in, and why you need to use both. Excel is the data tool of choice for the vast majority of people, but as we highlighted in the previous article, it has some shortcomings. In today’s world, there is more data than ever, and everybody in the workplace needs to be comfortable using data in some way.

In a previous article, SQL and Excel: Why you need both, we showed that for many businesses the use of both SQL Server and Excel is an optimum approach to data management. Bonus: Use SQL Spreads to refresh the dashboard and update forecast dataĭata Analysis Using SQL and Excel: An Overview Data Analysis Using SQL and Excel: An Overview

How to get data analysis on excel