SQL for Business Intelligence Reporting and Analysis

After a short introduction on Data Warehousing (DW) and Business Intelligence (BI) topics, this course examines in depth the possibilities offered by SQL. More specifically, statistical, analytical and OLAP functions will be discussed and explained. The most important ones are then individually discussed and demonstrated; realistic hands-on practical sessions give attendees the chance to grasp quickly the applicability of these SQL functions and options.

The SQL syntax covered in this course is platform independent. When relevant, platform specific exceptions will be pointed-out with respect to Oracle, Db2, and SQL Server.

This course is also available for exclusive, one-company presentations live over the Internet, via the Virtual Classroom Environment service.

What you will learn

On successful completion of this course you will be able to:

understand how SQL (i.e. The SELECT instruction) can be used for DW and BI reporting
write effective SQL from a DW and BI perspective
write problem-based SQL statements, and evaluate possible alternative SQL constructs for their effectiveness.

Who Should Attend

This courseis suitable for everyone involved in the development of business reports by means of SQL statements on relational database systems.

Prerequisites

Prior knowledge of data warehousing concepts is required. This can be obtained by attending the course Data Warehouse Concepts. Advanced SQL proficiency is also essential. This can be gained by attending the course Understanding & Using SQL.

Duration

2 days

Fee (per attendee)

£1320 (ex VAT)

This includes free online 24/7 access to course notes.

Hard copy course notes are available on request from rsmshop@rsm.co.uk

at £50.00 plus carriage per set.

Course Code

SBIA

Data Warehouse and Business Intelligence - positioning

Statistics and analytics - support in SQL

Purpose and context - multi-platform support; AVG; CORRELATION; COUNT; COVARIANCE; MAX; MIN; RAND; STDDEV; SUM; VARIANCE; MEDIAN; etc.

Online Analytical Processing in SQL

Purpose and context - multi-platform support; RANK; DENSE_RANK; ROW_NUMBER; PARTITION BY; ORDER BY; ROWS; RANGE; GROUP BY; GROUPING SETS; ROLLUP; CUBE; OVER; WINDOWING functions: SUM ... OVER ..., LEAD; LAG and similar aggregation functions, and their application in a.o. trend analysis; Text analytics; regular expressions.