Customer Experience Analysis

Description

This workshop will be extremely useful for people working in the burgeoning online business.

Our instructors will explain what are social media listening and the customer retention model (LifeCycle Grid) will tell about important tools they use in business.

 

Basic requirements for participants:

Knowledge

• Excel 2013/2016 OR
• 2016 Office 2016 Professional Plus OR
• 365 Office 365 – all versions including Desktop or Excel for Windows

General understanding

• social networks and online communications;
• Marketing research terminology.

 

Target audience:

• business analysts, marketing managers, data analysts;
• sales, HR, advertising, communications specialists;
• media, online social networks researchers;
• public sector analysts;
• data journalists;
• future experts in data analysis.

 

What you get:

• ability to interpret data from social networks;
• practical skills in creating client base assessment models;
• Power Pivot and Dashboard skills
• cohort analysis skills

 

Workshop program:

 

• 10:00 – 13:15 (with a break)

 

Social media listening – what is it? What is the place of SML projects in business processes? How to implement social media research into your company’s decision-making process? Features of methodology, work with data in social networks, interpretation of results and search of sacred insights from consumers.

 

Teacher – Anton Bezkorovainyi

 

13:15 – 14:15 Lunch break

 

• 14:15 – 17:30 pm (with a break)

 

The second part of the session will cover Power Pivot / Power Query (or Excel on steroids). Students will be introduced to the Business Metrics Dashboard (DAX) and Life-Cycle Grid. Much of the lesson will be devoted to cohort analysis – how and why to do it, such as churn, LTV, and CAC. Who are the “new” customers, how to evaluate their quality, and why it is important not to forget about the “old” customers.

 

Teacher – Pavlo Levchuk

 

Price – 1650 UAH