Analyzing Business Data with T-SQL
ABSTRACT
Transact-SQL (T-SQL) is a powerful language for querying data but it can be a challenge for application developers and business analysts who are not already deeply familiar with the language to solve business problems. In this session, we will use a variety of T-SQL techniques to generate Key Performance Indicators (KPIs) for a common business scenario. We will see how to calculate measures like revenue, cost, profit, lifetime value, days between orders, and much more using techniques like common table expressions, date math, window functions, percentiles, and the APPLY operator. Come learn techniques to transform your business needs into SQL answers.ADDITIONAL MEDIA
No recordings or additional media are available for this talk.SLIDES
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
DEMO CODE
Click here to access demo code for this presentation.
The source code is licensed under the terms offered by the GPL.