August 2023 Summaries

Hex has announced a partnership with Google Cloud, introducing new integrations that enable teams to explore data through various sources and leverage Google Cloud's managed services for large-scale data processing and analysis. The BigQuery integration is becoming more robust with the addition of support for DataFrames, allowing users to apply pandas-like syntax to their BigQuery data. Additionally, Hex will soon integrate with Spark on Google Cloud, offering serverless Spark's autoscaling capabilities and enabling ETL, data science, and machine learning workloads within Hex. Furthermore, Hex is expanding its support for databases with the Google Cloud Ready - Cloud SQL designation, allowing connections to Google Cloud-hosted SQL Server, PostgreSQL, and MySQL databases.

The article discusses an interactive map created to explore "Poles of Brand Inaccessibility" in the United States. These poles represent the farthest points from popular brands' locations, such as McDonald's and Starbucks. Using modern data tools, the author analyzed geographic data to find these remote locations and shared insights about brand distribution across the country. The map allows users to discover unique combinations of brand poles and encourages exploration of lesser-known places in America.

Product analytics on top of a data warehouse allows for deeper insights into feature adoption, retention, and satisfaction. Traditional product analytics tools built on event data often fall short in measuring these metrics accurately. By leveraging warehouse-based analytics with tools like Hex, product teams can centralize all necessary data sources, clean and correct rogue event data, enrich it with context, and combine feature success insights into one comprehensive report. This approach helps reduce rework and provides a clear read on feature adoption, ensuring that the features being developed are adding value for users and ultimately for the business.

The modern analytics workflow can be improved by using end to end tools that combine SQL IDE, notebooks, visualization tools and report builders in one platform. This reduces the need for copying and pasting between multiple tools, thus saving time and effort. Tools like Hex allow analysts to update queries or visualizations with just a few clicks, making it easier to incorporate feedback from stakeholders. Using single tools that consolidate workflows also reduces cognitive load and facilitates flow, enabling analysts to focus more on the task at hand.

The text discusses the potential impact of AI on data jobs and how it relates to Jevons' Paradox, a phenomenon where increased efficiency leads to higher consumption. It argues that while AI may reduce human hours needed for specific tasks, the overall demand for data work is not fixed and can actually increase as more insights are generated. The author suggests that we might need more humans in data roles rather than fewer, as AI makes it easier to generate insights from large amounts of data.