Stop Losing Customers – Periscope Data SQL Tips

In this How-To Guide, “Stop Losing Customers – Periscope Data SQL Tips”, Periscope Data explains the easiest way to calculate cohort retention statistics using SQL queries. Any organization that fails to track their customer segments is most likely leaving money on the table when a churn event occurs.

Cohort analysis using SQL is a popular toolset many skilled analysts use to understand any differences between groups of customers. In this use case, an analyst would be able to monitor older and new customers to observe when product interest drops for either group which may be associated with seasonal shifts, local demographic changes or any number of factors. 

If you have a SQL database, you can use SQL to perform cohort analysis on your own data to understand customer retention and loyalty. This document offers a step-by-step approach to writing the script and interpreting the results. 

Request Free!

A Practical Guide to Transform Manufacturing Operations With Smart Pull

The mechanism of “Pull” processes—those triggered by an actual event instead of a forecast—is nothing new. It is at the heart of many successful manufacturing strategies. Recent technological advances in digitization, including the harnessing of Big Data analytics, the use of the cloud, Business Process Management (BPM), social media, IIoT, and mobility, have extended the power of Pull beyond Lean manufacturing. In the wake of the current technological innovation wave, it is not uncommon for manufacturers to not know what next step to take.

In light of these new developments, this white paper will focus on the mechanism of business transformation enabled by these technologies, which can be attributed to two major forces: the power of Pull and digitization. Nine practical applications are detailed, showing how innovative manufacturers can better leverage digital technologies to achieve new levels of operational excellence. Dassault Systèmes calls the synergized effect of these forces “Smart Pull.”

Explore the full potential of the new opportunities enabled by Smart Pull.

Request Free!