Sub-Total: $0.00
Using Case statements for conditional logic in SQL queries
Learn how to uncover booking trends with SQL and Excel.
Every business wants to know when customers commit—are they booking last-minute or months in advance? In this Data Survival Skills session, Robin shows how to use SQL case statements to group bookings into bands like 0–45 days, 46–90 days, and 180+ days. By transforming raw “days out” data into clear categories, you’ll create pivot tables in Excel that reveal booking behaviors at a glance. These insights make it easier for decision-makers to spot trends, prepare staffing, and evaluate the success of early-booking initiatives. By mastering conditional logic in SQL, you’ll move beyond static reports and deliver analysis that truly guides business strategy.
#SQL #DataAnalytics #ExcelTips #BusinessIntelligence #PivotTables #ConditionalLogic #DataSkills #Productivity
If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.