Sql Code

Featherman’s T-SQL Primer ©– Run all queries using the AdventureWorksDW 2012 data warehouse

The goal of business intelligence is to build an IT infrastructure, set of integrated systems, scripted procedures and staff that can reliably and repeatedly to turn mountains of data into actionable information. Often the information is formatted into routine and exception reports, trend reports, dashboards, charts, and scorecards. The easy part is making the charts. The work (and therefore higher pay scale) is in understanding the data, creating data models and like a sculptor or blacksmith, pounding it into shape until it shines in its insightfulness.

The insights needed to make better decisions starts with data management - capturing, cleaning, filtering, and aggregating the data. This document is designed to provide you an introduction to this process. It’s very fun to gain mastery over data, if you don’t the alternative is a lot of copying and pasting in Excel! Your goal is to gain mastery over data, and become self-sufficient so that the hands-on process of extracting and compiling data does not slow down your inquisitive mind.

We have created database tables, learned about data types, and even implemented primary and foreign keys with different graphical designers. We have learned that there are different ways to generate and run SQL queries:

* In Access you can use the GUI Query by Example (QBE) facility

* In SSRS you can use the GUI query designer to build a SQL query

* In SQL Server Management Studio you can use the Query |Design query in Editor option

* You can use a Microsoft Query inside Excel’s external data connection in a QBE facility

* In Access you can write SQL code

* In SQL Server Management Studio you can write SQL code

* In a Microsoft Query inside Excel’s external data connection you can write SQL

* Using an External data connection in Excel, and adding some filters is running SQL behind the scenes

So...