inflearn logo

Top 1% Data Literacy – Data-Driven Customer Growth Strategy Secret Class Completed with Only Excel and Orange

Customer analysis completed with Excel and Orange, from cross-selling to A/B testing and churn risk management all at once

(5.0) 7 reviews

8 learners

Level Beginner

Course period Unlimited

AI
AI
Excel
Excel
MS-Office
MS-Office
Orange3
Orange3
Data literacy
Data literacy
AI
AI
Excel
Excel
MS-Office
MS-Office
Orange3
Orange3
Data literacy
Data literacy

Reviews from Early Learners

Reviews from Early Learners

5.0

5.0

찰떡콩떡

88% enrolled

It was great because it included practical content that can be used immediately in the field, such as A/B testing and lifetime value!!

5.0

히릿

100% enrolled

Analyzing it with Orange in addition to Excel makes it much easier to see everything at a glance!

5.0

일찍일어나는새가벌레

76% enrolled

It's very useful since I'm mixing in oranges.

What you will gain after the course

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

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

  • Customer recommendation and sales opportunity derivation based on association rules, lift, and collaborative filtering

  • Deriving factors that influence conversion and churn through regression analysis and positioning analysis

  • Practical Customer Strategy Design Using Customer Lifetime Value, Survival Rate, and Repurchase Probability

Customer analysis completed with Excel and Orange,
from cross-selling to A/B testing and churn risk management, all at once


“How do you read the customer's mind?”
Now, easily and simply prove your marketing with data using Excel and Orange!

The process of finding 'real customers' who generate actual profit beyond vague guesses
An end to wandering marketing, a 'data answer sheet' strategy that leaves only profit!

 

– Ultra-precise 1:1 personalized customer analysis completed with just clicks, no coding required
– Practical retention strategies through personalized recommendations and detection of churn signals
– Designing an overwhelming profit structure proven by numbers instead of experience and guesswork
– The foolproof marketing answer derived from A/B testing and LTV (Lifetime Value) calculations

Stop planning based on vague assumptions.
Prove your marketing intuition through customer response!



High-quality data analysis techniques and Excel task automation curriculum features completed with structured prompting

Complete recommendation and churn prediction using Excel and Orange without coding in this practical course.

1. The beginning of customer analysis that even data beginners can understand
An analysis process that establishes the flow so you can read customer behavior even without complex formulas

2. Creating data standards to verify intuition-based judgments
Learning analytical thinking to explain the difference between choices and performance through hypothesis setting and verification

3. Discovering customer patterns that lead to recommendations and cross-selling
Finding opportunities that lead to actual sales through association rules and similarity analysis

4. Key Factor Analysis to Identify Causes of Conversion and Churn
Deriving Determinants that Change Customer Behavior through Regression and Preference Analysis

5. Practical Customer Strategy Completed with LTV and Forecasting
A curriculum for identifying high-value customers and designing retention and repurchase strategies

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

Start data-driven marketing today.


A data analysis lecture that identifies 'customers who actually bring in money' using Excel and Orange

1. Sign up for the course

2. Precisely analyzing customers' inner thoughts with data alongside Instructor Jung-ah Choi

3. From recommendations to churn prevention, equipping a foolproof ‘revenue formula’

Start right now with a sophisticated strategy completed in just one click!




Selecting VIP customers—Excel and Orange are all you need!

Analysis without criteria is just manual labor; seize the "golden time" of purchases and churn within the data.

From preference analysis to LTV prediction!
It's time to discard guesswork and prove overwhelming performance with numbers alone.


About the Instructor

I confidently recommend this to the following people.

– Those who have plenty of customer data but feel overwhelmed about where to start analyzing
– Those who want to go beyond simple metric analysis and perform data analysis used for decision-making
– Those in Marketing, CRM, Growth, Planning, or Product roles who need customer understanding capabilities
– Practitioners who want to properly understand the principles of recommendation systems, A/B testing, and customer segmentation
– Those who want to explain "why this customer left" or "who the truly important customers are" using data
– Those who want to design efficient marketing operation strategies based on Customer Lifetime Value (LTV)
– Anyone who feels burdened by statistics or analysis tools but wants to learn analytical thinking centered on concepts and interpretation

 

“What on earth should I do with this data?” We will turn that uncertainty into ‘confidence.’
We have stripped away all complex coding and unnecessary statistical theories.
Become an irreplaceable marketer who proves planning with ‘numbers’ using only Excel and Orange.



Course Features

STEP 1. The starting point of analysis for understanding customer data

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

 

STEP 2. Learning statistical thinking to verify the reasons behind choices

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

 

STEP 3. Pattern Analysis Practice Leading to Recommendations and Cross-selling

Deriving customer recommendations and sales opportunities based on association rules, lift, and collaborative filtering

 

STEP 4. Analyzing Key Factors Influencing Performance

Deriving factors affecting conversion and churn through regression and positioning analysis

 

STEP 5. Completing Customer Strategy with LTV and Churn Prediction

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



Neglecting data is equivalent to giving up profits.
Check your customers' choices so that dormant data can awaken as ‘revenue’!

Discover the hidden laws of profit using Excel and Orange!

Get started now with customer analysis practice,
covering everything from recommendations and cross-selling to churn prediction





Anticipated Q&A

Q. Do I need prior knowledge of AI to take this course?
A. This course is designed with the goal of providing skills that anyone interested in AI can immediately apply to their practical work; therefore, no prior knowledge of AI is required.

Q. Are there any requirements or prerequisites for taking the course?
A. No special prior knowledge or skills are required to take the course. However, having a Google account to access the generative AI tools introduced in the course will help the process go more smoothly. If you don't have a Google account yet, we recommend signing up before the lecture for a seamless learning experience.

Q. Do I need a paid subscription to Generative AI to take this course?
A. Subscriptions and payments are not mandatory for taking the course. While some features introduced in the lectures may require payment, this course is primarily designed for you to gain insights into how to apply the various and specific AI practical skills covered in the lectures to your own work.



Please check before taking the course!

  • Since this is a practice-oriented course, we recommend using a dual monitor setup or an extra device so you can separate the lecture screen from your practice screen.

  • Also, since the practice sessions are based on Windows OS, we recommend taking the course in a Windows environment.

  • The lecture materials and practice files are located in the <00. Textbook Download Center> section.

Recommended for
these people

Who is this course right for?

  • Those who have plenty of customer data but feel overwhelmed and don't know where to start the analysis

  • Those who want to perform data analysis used for decision-making, going beyond simple metric analysis.

  • Those who need customer understanding capabilities in marketing, CRM, growth, planning, and product roles

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

  • Those who want to design an efficient marketing operation strategy based on Customer Lifetime Value (CLV)

Need to know before starting?

  • No special prior knowledge or skills are required to take this course. However, having a Google account will ensure a smoother experience when accessing generative AI tools during the lessons. If you do not have a Google account yet, we recommend signing up in advance for a seamless learning experience.

Hello
This is Masocampus

10,140

Learners

1,442

Reviews

122

Answers

4.7

Rating

104

Courses

"I will grow more than yesterday. And, I will help those who strive to grow more than yesterday."

With Actionable Content that embodies the sincerity and aspirations of Maso Campus,

100 million cumulative hours of lectures shared online and offline since 2013!

This precious experience and time are always the source of growth for both Maso Campus and our students.

The Miso Campus team strictly adheres to two principles for the growth of us all. 1. Actionable Content that can be put into practice immediately after learning. 2. Respecting the time and effort of participants.

The Miso Campus team strictly adheres to two principles for the growth of us all.

1. Actionable Content that you can actually use after learning 2. Time-Saving Curriculum that respects the participant's time and effort Grow with Miso Campus's Actionable and Time-Saving Curriculum

1. Actionable Content that you can surely use once you learn it

2. Time-Saving Curriculum that respects the time and effort of participants

We hope you will walk the path of growth together with Masocampus's Actionable and Time-Saving Curriculum.

We hope you will walk the path of growth together with Maso Campus's Actionable and Time-Saving Curriculum.

More

Curriculum

All

25 lectures ∙ (8hr 40min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

7 reviews

5.0

7 reviews

  • deshin6394님의 프로필 이미지
    deshin6394

    Reviews 12

    Average Rating 5.0

    5

    88% enrolled

    It was great because it included practical content that can be used immediately in the field, such as A/B testing and lifetime value!!

    • bullae님의 프로필 이미지
      bullae

      Reviews 29

      Average Rating 5.0

      5

      76% enrolled

      It's very useful since I'm mixing in oranges.

      • xtpwlsx690267님의 프로필 이미지
        xtpwlsx690267

        Reviews 4

        Average Rating 5.0

        5

        68% enrolled

        I didn't even know what an orange was, but I found out through this opportunity. Thank you.

        • hryoon5235님의 프로필 이미지
          hryoon5235

          Reviews 33

          Average Rating 5.0

          5

          100% enrolled

          Analyzing it with Orange in addition to Excel makes it much easier to see everything at a glance!

          • smpark6031님의 프로필 이미지
            smpark6031

            Reviews 9

            Average Rating 5.0

            5

            100% enrolled

            You explain complex and difficult customer data analysis in a way that is easy to understand.

            Masocampus's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!

            Limited time deal

            $1,188,970.00

            28%

            $61.60