55232 Data Analyst

Writing Analytical Queries for Business Intelligence

Name: Writing Analytical Queries for Business Intelligence
Price: 2085 CAD
Availability: InStock

This three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis – in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS.

Prerequisites

Before attending this course, participants should be familiar with basic database concepts. Students should take Introduction to SQL Databases before taking this course.

Course Modules

1. Introduction to TSQL for Business Intelligence
2. Turning Table Columns into Variables for Analysis: SELECT, WHERE, ORDER BY
3. Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators
4. Creating an Appropriate Aggregation Level Using GROUP BY
5. Subqueries, Derived Tables and Common Table Expressions
6. Encapsulating Data Retrieval Logic
7. Getting Your Dataset to the Client