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.

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.

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.

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.

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.

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.

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.

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.

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.