Very practical and hands on. This course is really helpful for someone new to data science in guiding how to build a dashboard and the details and the KPI's to consider, and overall how to plan building a dashboard from scratch.
This Customer Engagement Analysis course defines the questions most relevant to customer engagement. You’ll analyze student engagement on the 365 learning platform, construct a comprehensive Tableau report, analyze the findings, and recommend ideas for improvements.
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.
This Customer Engagement Analysis course is an exciting journey toward studying the level of student engagement on the 365 platform. You’ll gain valuable knowledge on analyzing customers’ behavior and uplevel your SQL and Tableau skills.
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.
“A well-rounded data analyst needs to be equipped with multiple skills in their toolbelt—including a carefully planned project, extracting meaningful data, and visualizing it in the most intuitive way that promptly identifies potential problems. The level of execution of these steps and the actions taken could make the difference between a thriving business and an unavailing one.”
Content Creator at 365 Data Science
Customer Engagement Analysis with SQL and Tableau
with Hristina Hristova