January 2021 Summaries

The power of event data lies not just in tracking user activity but also in transforming it into attributes that can be used to enrich user profiles, trigger workflows, and segment users for targeted marketing campaigns. By aggregating and transforming events, developers can unlock new insights such as account health scores, product qualified leads, and daily active users per account. These attributes can then be used to automate tasks, personalize customer interactions, and drive revenue through data-driven decisions. The key is to transform event data into object attributes that can be used across various tools and platforms, enabling a more seamless and effective user experience.

A cohort analysis is a powerful tool used to gather insights on customer churn, lifetime value, product engagement, and stickiness by analyzing groups of customers with similar characteristics over time. This 3-dimensional visualization allows for comparisons across different segments and metrics, providing valuable information for improving user onboardings, product development, and marketing tactics. By segmenting users based on specific criteria such as time-based cohorts, segment-based cohorts, or sized-based cohorts, businesses can gain a better understanding of their customers' behaviors and trends, enabling data-driven decision making. The process involves collecting required data, manipulating it in SQL, and then ingesting the result into a business intelligence tool to create a digestible format for analysis and visualization. Cohort analyses offer insights on user behavior, customer churn, lifetime value, and more, allowing businesses to identify areas of improvement and take targeted actions to enhance their products and services.

Snowflake is a modern data-warehousing solution that's built with the needs of today's data teams in mind, offering quality-of-life features such as easy data sharing and a user-friendly experience that Amazon Redshift still tries to catch up on. Snowflake makes sharing data super simple by allowing users to copy databases within their own data structure and grant instant read access to those databases, which is a safer and more efficient process than traditional methods used by Redshift. Additionally, Snowflake's unique ability to decouple computing and storage costs results in lower overall costs for businesses, with the true cost-savings coming from building a tighter infrastructure. Unlike Redshift, Snowflake scales linearly, allowing small startups to grow on a solid foundation of data, while also handling concurrency and real-time data more efficiently. Furthermore, Snowflake is more flexible and agile than Redshift, making it easier for businesses to adapt to the rapidly changing data industry. While migration from Redshift to Snowflake can be a process with some nuances to consider, the benefits of using Snowflake far outweigh those of Redshift.

There is a customer data platform (CDP) embedded in many businesses' data warehouses, waiting to be leveraged without the need for an expensive CDP solution. A CDP collects, manages, and governs customer data, helping with data collection, management, and governance. However, off-the-shelf CDP solutions have limitations due to their young industry age, lack of clear definitions, and potential to lock customers in with proprietary philosophies. By utilizing a good data infrastructure, businesses can already collect and manage customer data without the need for an expensive CDP solution. Instead, they can tailor their existing data warehouse to provide these features using lightweight tools like dbt and Census, creating a more sound data infrastructure, being more flexible, and avoiding the drawbacks of off-the-shelf CDPs.