Sub-Total: $0.00
Basic dates analysis
Learn how to reveal hidden gaps in your booking data. Traditional reports often miss the story behind no activity—days and weeks where bookings never happened. In this Data Survival Skills session, Robin shows how to use Excel and Power Query to merge booking records with a complete date table, making it easy to spot missing values and understand seasonality. You’ll learn how to build pivots, expose gaps, and enrich your dataset with fields like week numbers and weekdays for clearer insights. By structuring your data this way, you transform raw records into meaningful signals that explain when and why bookings happen. This approach goes beyond simple counts—it connects gaps to business context, helping you optimize promotions, marketing spend, and decision-making.
#DataAnalytics #ExcelTips #PowerQuery #DataAnalysis #BusinessIntelligence #DataCleaning #DataSkills #Productivity #DataVisualization #ExploratoryAnalysis
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.