![[백문이불여일타] 데이터 분석을 위한 중급 SQLCourse Thumbnail](https://cdn.inflearn.com/public/courses/324568/cover/9f81ac3f-d663-49e7-9eda-61253189790c/sql_intermediate.png?w=420)
[백문이불여일타] 데이터 분석을 위한 중급 SQL
데이터리안
인프런 누적 수강생 30,000명 이상, 풍부한 온/오프라인 강의 경험을 가진 데이터리안의 SQL 중급 강의. SQL 중급 이론을 배우고, 실습 문제 20개를 함께 풀어봅니다.
Basic
SQL
How can performance be measured in offline advertising? From how to measure the performance of elevator TV ads, to the commonalities and differences in data observed in online/offline marketing! Hear about it at this October seminar!


Elevator TV Use Cases and Effect Analysis Methods
Performance Measurement Methods and Cases for Offline Advertising
Offline ad creative, copy tips
Similarities and differences between online and offline advertising
📍Notice
This course will be converted to a free course starting Monday, June 2, 2025. Please note this before paying for the course.
For inquiries, please click the 'Contact Us' button at the bottom right.
Monthly data analysis seminars 💡
Check out Monthly Datalian again in October 2023!
📢 Please check before taking the class!
This lecture is a recorded video of the live seminar “From SNS Marketing to Offline Advertising with Data” held in October 2023.
Includes replies to real-time chat that comes up during the live presentation.
Monthly Datalian Seminar

Marketers looking for new marketing channels other than YouTube and Instagram
For those of you wondering if outdoor advertising can also be measured for performance
For those who want to know the difference between online marketing and offline marketing
Anyone who saw the TV commercial for an apartment elevator and wondered, “Which company does this?”
📺 In November 2023, we'll talk about marketing performance analysis!
[November Topic] Everything About Marketing Performance Analysis (feat. GA4)
Go to the next live seminar news: https://datarian.io/seminar
✔ Speaker Kang Seol-gi
Focus Media Korea Data Strategy Team Leader
I am a humanities major and 1n-year digital marketer/data analyst who jumped into the ocean of data. I work as the leader of the data strategy team at Focus Media Korea.


As content consumption channels diversify to include TV, mobile, and OTT, finding a medium to meet customers is emerging as a new challenge for marketers. Focus Media is communicating with its target audience of 10 million people every day through 90,000 elevator TVs installed nationwide.
One limitation encountered while operating Elevator TV was that, unlike other digital platforms, it was impossible to collect target information and thus segment customers. Focus Media introduces how to effectively segment apartment residents by what criteria, the solution process, Elevator TV usage cases, and even the effectiveness analysis method.
✔ Panel Kang Seol-gi
Focus Media Korea Data Strategy Team Leader
✔ Panelist Kim Min-joo
Datalian Growth Marketer, Data Analyst


“How do you check CAC for outdoor advertising?”, “How do you test materials for outdoor advertising?”, etc. SNS performance marketers and outdoor advertising marketers will share insights through Q&A. If you are curious about what data online and offline advertising look at and what their similarities and differences are, don’t miss the panel talk.
Part 1 Speaker
Focus Media Korea Data Strategy Team Leader
I am a humanities major and 1n-year digital marketer/data analyst who jumped into the ocean of data. I work as the leader of the data strategy team at Focus Media Korea.
Part 2 panel
Datalian Growth Marketer, Data Analyst
Former B2B logistics startup SwatchOn data analyst, growth marketer
Former Co-Founder, COO of shared living startup Napster
I learned data analysis to find answers in a world where there are no right answers after starting a business. I worked as a data analyst and now I am working on growing services based on data.
Moderator
Datalian Content PD, Data Analyst
Former Ridi Data Analyst
I started working in data analysis at a content company and then started creating content after starting my own business. I use data in all processes, from creating and releasing newsletters and YouTube videos, to ensure that necessary information is delivered in a timely manner.
Q. When is the monthly Datalian Live Seminar? Where can I apply?
You can check out the next month's seminar information on the Datalian website . You can also apply right away!
Q. Is there anything I need to prepare before listening?
No :D Anyone can hear it!
Q. Can I view the slides you used in the seminar separately?
Please check the slides at the link below!
October Seminar Slides : https://bit.ly/46AwJlJ
I liked the glimpse into the process of trying to index offline advertising! Usually, we tend to ignore things that cannot be measured because there is no data, but it was impressive that you found your own answer even with limited requirements!
I was impressed by the content of persuading the people involved to collect data. It made me reflect on whether I have been working and communicating passively up until now.
I was surprised that the analysis I did online was applied offline as well!! I really felt that the essence does not change. ^^
I was impressed by the data collection method of the elevator TV advertisement and the examples of clusters by brand.
It was impressive that the process of setting up hypotheses and collecting data to create target segments, and verifying effectiveness using actual purchasing customer data, was able to overcome the limitations of previous non-digital advertising media.
I was impressed by the fact that offline marketing indicators were directly selected and the clear difference in effectiveness by target.
It was great to hear both online and offline data-based marketing perspectives at the same time.
The point of not giving up and challenging yourself to achieve a difficult goal, and the point of making good use of government support.
I don't know anything about advertising, but it was so interesting to see things from a new perspective.
In the process of identifying the characteristics of each apartment building to increase the effectiveness of offline outdoor advertising, I felt the time required and difficulty of the data preprocessing process.
I found that Focus Media's targeting method was much more sophisticated than I thought.
The overall content was new and impressive, including the process through which elevator TV advertisements were analyzed and the results derived. It was also interesting to see how information was collected through unexpected methods.
It was impressive to create a new metric to analyze offline advertising effectiveness.
It was great to learn about the digital signage product that I had never heard of before! I also liked the fact that data analysts can play a role in various domains, so I wanted to hear more stories about analysts in various fields in the future.
I was worried that I wouldn't be interested since I'm a job seeker and I can't relate to it directly, but I found it very interesting because you explained in detail how the analysis is done. The offline advertising process was also fun.
It was fun to learn about new fields and topics that I would not have been very interested in if it weren't for the seminar.
I, too, will become a cool data analyst like the Datarian analysts!
Accuracy and evidence are important in decision-making, so I am gradually preparing to change my job to a data-related job. Datalian's materials are very motivating and helpful. Thank you for the good materials.
Thank you for hosting a great seminar! Today's session was very smooth and the content was very informative.
Thank you for the lecture full of great insights!
If I had known about the seminar earlier, I wouldn't have had this much work to do... I'll go and listen to the last seminar :)
If there is another good seminar next time, I will participate again!
Thank you for preparing such a informative seminar~!
I had a lot of fun listening to today's lecture 😀
Who is this course right for?
A marketer looking for new marketing channels besides YouTube and Instagram
Those wondering if outdoor advertising performance can be measured
For those who want to know the difference between online marketing and offline marketing
Those who saw the apartment elevator TV ads and wondered, "Which company does this?"
22,204
Learners
2,651
Reviews
27
Answers
4.9
Rating
35
Courses
All
5 lectures ∙ (1hr 57min)
All
1 reviews
Free
Check out other courses by the instructor!
Explore other courses in the same field!