Advanced SQL for Analytics
Do you consider yourself okay with SQL but want to level up? This session will cover SQL functions that can be used for analytics. Most of these functions are available in ANSI SQL and thus work on most databases, but some functions will be specific to Oracle, Snowflake, and BigQuery (and perhaps other databases I haven't researched). We'll cover window functions, aggregations, pivoting, statistical functions, and even machine learning capabilities within SQL. Prepare to leave this session excited to impress your analytics stakeholders with more advanced ways of looking at data!
Speaker/Host
Primary/Host Speaker
Michelle Hardwick
Chief Data Officer at UC Riverside
Michelle Hardwick is the Chief Data Officer for UCR. Her primary goal is to create intuitive and insightful data products that drive data-informed decisions and boost data literacy across the campus. With over 20 years of experience in data, Michelle has overseen multiple implementations of data warehouses, BI, analytics, and machine learning across many industries. She is passionate about improving storytelling with data and effective data visualizations. Michelle has a BS in Computer Science from Winona State University and an MBA from Utah State University.
Let us help you with your search