Notification message will go here.
Discover how AI data analytics tools assist data engineers in seven key ways, including automating routine tasks and supercharging data prep and ETL processes.
Explore top AI machine learning strategies for analytics success. From predictive modeling to explainable AI, unlock key insights for your projects.
It’s a smart idea to thoughtfully consider whether to build or buy an analytics application. Use this handy decision tree.
SQL is one of the analyst’s most powerful tools. In SQL Superstar, we give you actionable advice to help you get the most out of this versatile language and create beautiful, effective queries. Losing users sucks. Losing customers really sucks….
Maintaining cache consistency Maintaining a data cache optimized to serve different queries can help speed them up, and benefits from economies of scale. Maintaining this cache leads us to a critical question: How do I know if the cache is…
The all-important revenue graph In your venerable orders table, you’re almost certainly storing prices as numbers. Perhaps they’re integer, perhaps they’re numeric, perhaps you’re using Postgres and they’re money, or perhaps you rolled the dice on floating-point rounding errors and…
A lot of charts and tables are time series, and the queries behind them are often easier when you can join and aggregate against a list of dates. Not having a complete list of dates causes gaps in the results,…
Statistical overconfidence: Dangerous and easy Imagine you have a small online business. This month 200 users signed up on your website, and 10 of them bought your $800 service. Great! You’ve made $8k of income. How much should you expect…
The new guy in Town Like a lot of folks in the data community, we’ve been impressed with Redshift, Amazon’s new distributed database. Yet at first, we couldn’t figure out why performance was so variable on seemingly-simple queries. The key…
NB: These techniques are universal, but for syntax we chose Postgres. Thanks to the inimitable pgAdminIII for the Explain graphics. So useful, yet so slow Count distinct is the bane of SQL analysts, so it was an obvious choice for…
