Customer Engagement Analysis with SQL and Tableau
top-rated

Name: Customer Engagement Analysis with SQL & Tableau Course
Price: 36 USD

with Hristina Hristova

4.9/5

(141)

Gain first-hand data analyst experience: Use SQL and Tableau to tackle real-world business challenges

5 hours of content 1832 students

Start for Free

What you get:

5 hours of content
33 Interactive exercises
45 Downloadable resources
World-class instructor
Closed captions
Q&A support
Future course updates
Course exam
Certificate of achievement

Customer Engagement Analysis with SQL and Tableau
top-rated

A course by Hristina Hristova

Start for Free

What you get:

5 hours of content
33 Interactive exercises
45 Downloadable resources
World-class instructor
Closed captions
Q&A support
Future course updates
Course exam
Certificate of achievement

$99.00

Lifetime access

Buy now

Start for Free

What you get:

5 hours of content
33 Interactive exercises
45 Downloadable resources
World-class instructor
Closed captions
Q&A support
Future course updates
Course exam
Certificate of achievement

What You Learn

Improve your SQL and Tableau proficiency by tackling complex real-world business datasets
Interpret engagement data to uncover actionable insights that can boost user experience and satisfaction
Create professional and well-formatted multi-page Tableau dashboards
Develop sharp business acumen by using data to identify business challenges, analyse trends, and propose improvements
Take advantage of an excellent opportunity to add a unique project to your portfolio
Master data visualization by creating sophisticated and informative charts in Tableau

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

Conducting a customer engagement analysis and ensuring that users experience the best of the product or service is of utmost importance for every company. In this Customer Engagement Analysis course, we’ll use SQL to extract user behavior information from 365’s database, then feed it into Tableau to create a multi-page customer engagement dashboard. Finally, we’ll discuss our findings and pinpoint areas for potential improvement.

Learn for Free

1.1 What Does the Course Cover?

4 min

1.2 Motivation - Our Story

5 min

2.1 The Case Study

5 min

2.3 Defining the Key Questions (Part 1)

7 min

2.5 Defining the Key Questions (Part 2)

6 min

2.7 Sketching the Dashboard (Part 1)

4 min

Curriculum

1. Introduction to the Course

2 Lessons 9 Min

This section of our customer engagement analysis course introduces the instructor and customer engagement and provides the prerequisites for the course.

What Does the Course Cover?
4 min
Motivation - Our Story
5 min
2. Introduction to the Customer Engagement Analysis Case Study

5 Lessons 26 Min

This section defines the customer engagement case study and the most intriguing questions of the analysis. We’ll then use the questions to sketch our Tableau dashboard.

The Case Study
5 min
Defining the Key Questions (Part 1)
7 min
Defining the Key Questions (Part 2)
6 min
Sketching the Dashboard (Part 1)
4 min
Sketching the Dashboard (Part 2)
4 min
3. Retrieving Relevant Data from the Database

6 Lessons 31 Min

In this section, we’ll rely on MySQL Workbench to import and study the database. We then focus on creating a query that retrieves information about the students’ engagement on a specific day and whether they’ve been free or paid users. You’ll learn how to export this information into a CSV file, later to be fed into Tableau.

Types of Data Access
8 min
Importing and Presenting the Database
7 min
SQL Query – Activity by Dates (Part 1)
8 min
SQL Query – Activity by Dates (Part 2)
2 min
SQL Query – Activity by Dates (Part 3)
5 min
Assignment 1 Read now
1 min
4. Building the Dashboard – Introduction to Dashboards

5 Lessons 22 Min

This section of the Customer Engagement Analysis course is an introduction to Tableau dashboards. We discuss the dashboard dimensions, the objects it offers, the difference between a Tiled and a Floating layout, and the importance of the item hierarchy within a dashboard.

Fixing the Size of the Dashboard
3 min
The Horizontal, Vertical, and Blank Objects
5 min
The Text, Image, and Navigation Objects
6 min
Creating an Item Hierarchy
2 min
Tiled versus Floating Layout
6 min
5. Building the Dashboard – The Overview Page

14 Lessons 55 Min

In this section, we create our first Tableau visuals. We cover the construction and design of key performance indicators showing the number of engaged students on the platform, the average minutes watched, and the number of certificates issued. Then, we create a horizontal bar chart analyzing the courses students are most interested in. A donut chart reveals the distribution of course reviews from 5 stars to 1. We also learn to use parameters as filters as well as tools for switching between sheets. Finally, we put the sheets together in our first of five dashboard pages.

Creating the KPIs (Part 1)
6 min
Creating the KPIs (Part 2)
6 min
Assignment 2 Read now
1 min
Horizontal Bar Chart – Overall Minutes Watched
7 min
Formatting the Horizontal Bar Chart
2 min
Assignment 3 Read now
1 min
Swapping Between Charts Using a Parameter
3 min
Donut Chart – Ratings
6 min
Assignment 4 Read now
1 min
Creating the First Page of the Dashboard (Part 1)
9 min
Assignment 5 Read now
1 min
Creating the First Page of the Dashboard (Part 2)
7 min
Assignment 6 Read now
1 min
Creating the First Page of the Dashboard (Part 3)
4 min
6. Building the Dashboard – The Engagement and Onboarding Page

9 Lessons 27 Min

This section covers the second page of our customer engagement analysis dashboard. We create a line and bar charts showing how the number of engaged students varies with time. The sheets are adapted to different date granularities (daily and monthly), switching between them with navigation buttons.

Line Chart – Number of Engaged Students (Choosing the Engagement Period)
6 min
Line chart – Onboarded to Registered Students (Choosing the Engagement Period)
4 min
Assignment 7 Read now
1 min
Line and Bar Charts - Number of Engaged Students (Choosing the Month and Year)
5 min
Assignment 8 Read now
1 min
Creating the Second Page of the Dashboard
5 min
Assignment 9 Read now
1 min
Configuring the Navigation Buttons
3 min
Assignment 10 Read now
1 min
7. Building the Dashboard – The Engagement by Cohorts Page

8 Lessons 29 Min

We dedicate this section to cohorts and cohort analyses. We first set the scene and discuss what cohorts are and how they are represented graphically. We then create a cohort table and retention curves in Tableau, which analyze the retention of engaged customers on the platform. We learn how to use action filters to display the retention curves upon selection on the cohort table. We also create a tooltip that displays helpful information about the charts when hovered over them. Finally, we combine these elements on the third page of the dashboard.

What is a Cohort Analysis?
6 min
Cohort Tables – Retention of Student Engagement
6 min
Retention Curves – Retention of Student Engagement
2 min
Assignment 11 Read now
1 min
Creating the Third Page of the Dashboard
6 min
Assignment 12 Read now
1 min
Creating a Hover Tooltip
6 min
Assignment 13 Read now
1 min
8. Building the Dashboard – The Exams and Certificates Page

6 Lessons 18 Min

This section of the Customer Engagement Analysis course deals with exams, certificates, and career track analyses. We create a horizontal stacked bar chart to visualize the number of successful and unsuccessful exam attempts, a vertical bar chart to display the monthly certificates issued, and another horizontal bar chart to create a funnel analysis. We then arrange these charts with their filters on the fourth page of the dashboard.

Horizontal Stacked Bar Chart – Number of Exams Attempted
4 min
Assignment 14 Read now
1 min
Bar Charts – Certificates Issuance and Career Track Funnel
6 min
Assignment 15 Read now
1 min
Creating the Fourth Page of the Dashboard
5 min
Assignment 16 Read now
1 min
9. Building the Dashboard – The Content Consumption Page

2 Lessons 11 Min

The fifth and final page of the dashboard features an analysis of the minutes watched by 365’s students, the free-to-paid conversion rate based on the amount of content consumed before subscribing, as well as studying the relationship between content consumed and subscription duration. All these analyses are visualized by combo charts—combining a line chart and a bar chart.

Combo Charts – Minutes Watched and Minutes Watched per User
5 min
Combo Chart – F2P Conversion Rate and Subscription Duration
6 min
10. Discussion and Insights

8 Lessons 47 Min

The course’s final section is dedicated to analyzing the dashboard, gaining valuable insights, and suggesting changes that would ideally improve the platform’s performance and increase the company’s revenue. We also discuss possible improvements and further analysis of the customer engagement dashboard.

Interpreting the Data (Platform Engagement)
5 min
Interpreting the Data (Onboarding and Retention)
8 min
Interpreting the Data (Content Consumption)
4 min
Interpreting the Data (F2P CR and Subscription Duration)
7 min
Interpreting the Data (Courses Engagement)
5 min
Interpreting the Data (Exams)
4 min
Interpreting the Data (Certificates)
7 min
Further Steps and Improvement
7 min

Topics

Retention CurveStacked Bar ChartTableau DashboardCohort analysis tableMySQL queryKey Performance IndicatorsCombo ChartLine chartCustomer EngagementHover TooltipFunnelData AnalysisBar chartData VisualizationDashboard Reporting

Tools & Technologies

Course Requirements

Highly recommended to take the SQL, and Intro to Tableau courses first
You will need to install MySQL Workbench
You will need to install Tableau Public

Who Should Take This Course?

Level of difficulty: Intermediate

Aspiring data analysts
Current data analysts who want to improve their technical and business skills

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Meet Your Instructor

Hristina Hristova

Head of Data Content at

6 Courses

1676 Reviews

14275 Students

Hristina Hristova is a Theoretical Physicist with experience in the fields of mathematics, physics, programming, and the creation of various educational content. For several years now, she has been tutoring physics and mathematics students online, following educational programs such as The IB Diploma, Cambridge IGCSE, and Cambridge AS & A Level, among many others. Hristina’s high qualification and adaptive teaching style have helped plenty of students successfully pass their exams, while also enjoying the learning process.