Skip to main content

Performance Tips

Speed Up Your Data Analysis​

Always filter by date and venue: When running your analysis, always specify which time period and which venues you want to examine. This dramatically speeds up your queries by focusing only on the data you actually need rather than searching through your entire database.

Example: Instead of analyzing all data, specify "January 2025" and "Downtown Mall location" to get much faster results.

For Advanced Users​

Create summary tables: If you have your own Snowflake account and frequently run the same types of analysis, consider creating pre-calculated summary tables. These store commonly needed results (like daily visitor counts or popular search terms) so you can access insights instantly rather than recalculating them each time.

When this helps: This approach is especially valuable if you:

  • Run similar reports regularly (weekly, monthly, quarterly)
  • Need dashboard data that updates automatically
  • Analyze large amounts of historical data frequently