IBIS Agenda

SQL for Data Analysts – Advanced (Day 2)

Adam Lange

Consultant, A. Lange Consulting LLC

Amy O’Neel

Senior Consultant, InfoSol Inc.

Day 2 Agenda:

  • Complex functions
    • Using the WITH statement
    • Window functions
    • Ranking data
    • Point in time functions
    • Using the APPLY function
  • Deploying SQL queries in your tool
    • Web Intelligence
    • Crystal Reports
    • InfoBurst
    • Tableau
    • Power BI
  • Other database systems
    • Compare/contrast RDBMS’s
    • Syntactical differences

VIEW DAY 1 AGENDA

Post-Conference Boot Camp