Kevin Feasel - Analyzing Business Data with T-SQL

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.

About Kevin:
Kevin Feasel is a Microsoft Data Platform MVP and CTO at FareGame Inc, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.