Presenters: Wesley Caproon, Art Institute of Chicago
Year: 2020
Price: Member: $49, Non-members: $79
Description: The ability to ply data in a SQL database before using it in a reporting, visualization or modeling application makes that higher-level work easier. We will focus on writing queries with window functions for common fundraising tasks like calculating consecutive years of giving with some time devoted to other database features and to avoiding pitfalls.