Customer analysis ending with Excel and Orange,

From cross-selling to A/B testing to exit risk management all at once

“How do you read the customer's inner feelings?”

Now you can easily and simply prove your marketing with data using Excel and Orange!

The process of finding “real customers” that make real profits beyond vague guesses

The end of lost marketing, a “data correct answer” strategy that only leaves profit!

— Highly accurate 1:1 customized customer analysis with just a click without coding

-Practical retention strategies by recommending customer-specific preferences and capturing signs of attrition

— Overwhelming profit structure design that is proven by numbers instead of experience and guesses

— Fail-free marketing answers derived from A/B testing and LTV (lifetime value) calculations

Now, don't plan with only vague expectations.

Prove your marketing sense with customer responses!

What is Orange?

Orange is a data analysis tool that can perform data analysis and machine learning visually without coding, and is designed to easily handle complex statistics or algorithms in a block-linked manner.

By importing only customer data, selection pattern analysis, related rules, recommendations, and classification/prediction can be intuitively checked on one screen, so even non-majors can quickly execute data-based decisions.

Complete your intuition with a compelling data strategy with Excel and Orange!

High-quality data analysis techniques and Excel work automation curriculum features completed with structured prompts

This is a practical course that completes recommendations and exit predictions using Excel and Orange without coding.

1. The beginning of customer analysis that even a data beginner can understand

An analysis process that captures the flow so that customer behavior can be read without complicated formulas

2. Create data standards to verify sentimental judgments

Learn analytical thinking to explain differences between choice and performance through hypothesis setting and testing

3. Discover customer patterns that lead to referrals and cross-selling

Find opportunities that lead to actual sales through correlation rules and similarity analysis

4. Analysis of key factors to identify causes of conversion and churn

Derive determinants to change customer behavior through regression analysis and preference analysis

5. Practical customer strategy completed with LTV and forecasting

A curriculum that selects high-value customers and designs strategies for retention and repurchase

The moment numbers are more persuasive than words, the way you understand customers changes.

Start marketing determined by data. Start now.

VIP customer selection, Excel and orange are all you need!

Standardless analysis is just a simple labor; capture the “golden time” of purchases and abandonment in data.

From preference analysis to LTV prediction!

It's time to put aside guesswork and prove overwhelming results with just numbers.

About knowledge sharers

I can confidently recommend it to people like this.

— People who have a lot of customer data but don't know where to start analyzing it

— Those who want to go beyond simple indicator analysis to analyze data used in decision making

— Those who need customer understanding skills in marketing, CRM, growth, planning, and product jobs

— Practitioners who want to properly understand the principles of recommendation systems, A/B testing, and customer segmentation

— People who want to explain “why this customer left” and “who is a really important customer” with data

— Those who want to design an efficient marketing operation strategy based on customer lifetime value

— Anyone who is burdened with statistics or analysis tools but wants to learn analytical thinking with a focus on concepts and interpretation

“What should I do with this data?” We turn that feeling of emptiness into “confidence.”

Complex coding and unnecessary statistical theory have all been eliminated.

Become an irreplaceable marketer who proves plans with “numbers” using only Excel and Orange.

Course features

STEP 1. The starting point of analysis to understand customer data

Understanding the perspective of reading customer behavior and choice data and the basic flow of data analysis

STEP 2. Learn statistical thinking to test reasons for choice

Learn how to prove differences through hypothesis setting, chi-square testing, and A/B testing

STEP 3. Practice analyzing patterns leading to recommendations and cross-selling

Derive customer recommendations and sales opportunities based on associated rules, lift, and collaborative filtering

STEP 4. Analysis of key factors affecting performance

Derive factors that influence transitions and exits through regression analysis and positioning analysis

STEP 5. Customer strategy completed with LTV and attrition prediction

Practical customer strategy design using customer lifetime value, survival rate, and probability of repurchase

Data neglect equals abandonment of profits.

Check out customer choices so you can awaken dormant data with “sales”!

Discover the hidden law of profit with Excel and Orange!

Organize recommendations, cross-sales, and exit predictions all at once

Customer analytics practice, start right now

Expected Questions Q&A

Q. Do I need player knowledge about artificial intelligence to take the course?

A. This course is designed to provide competencies that anyone interested in artificial intelligence can immediately listen to and use in practice, and player knowledge about artificial intelligence is not required.

Q. Are there any requirements or requirements to take the course?

A. No special prior knowledge or skills are required to take the course. However, if you have a Google account to access generative AI tools in the course, you can proceed more smoothly. If you don't have a Google account yet, we recommend that you sign up for a smooth learning experience before the course.

Q. Can I only take the Generative AI course if I have a paid subscription?

A. Subscriptions and payments are not required to take courses. Although some of the features introduced in the course may require payment, this course is designed with the primary goal of gaining insight into how the various and specific AI practical competencies covered in the course can be applied to one's own work.

Please check before taking the course!

Since this is a practice-oriented course, it is a good idea to prepare a dual monitor or an extra device that can separate the lecture screen from the practice screen.

Also, since exercises are conducted based on Windows OS, we recommend taking courses in a Windows environment.

Lecture plan and practice files are <00. It is located in the Textbook Download Center> section.

Top 1% Data Literacy — A data-driven customer growth strategy completed with only Excel and Orange

Top 1% Data Literacy — A data-driven customer growth strategy completed with only Excel and Orange