Rabab A.
Before 365:
Project Coordinator | SOFRECO
After 365:
Freelance Data Analyst
See all reviews
Online Course
top-rated
free
Customer Engagement Analysis with SQL and Tableau
with
Hristina Hristova
Gain first-hand data analyst experience: Use SQL and Tableau to tackle real-world business challenges
1949 students already have enrolled
Skill level:
Intermediate
Duration:
5 hours
-
Lessons (4 hours)
-
Practice exams (1.25 hours)
-
Projects (10 hours)
- Lessons (4 hours)
- Practice exams (1.25 hours)
- Projects (10 hours)
CPE credits:
7.5
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of
professionals must earn to maintain their licenses and stay current with regulations and best
practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's
official website: www.nasbaregistry.org
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of
professionals must earn to maintain their licenses and stay current with regulations and best
practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's
official website: www.nasbaregistry.org
Accredited:
certificate
What You Learn
- Extract user behavior data from 365’s database using SQL queries.
- Feed that engagement data into Tableau to build multi-page dashboards.
- Interpret engagement patterns to uncover actionable improvement areas.
- Create polished, structured dashboards that highlight business insights.
- Showcase your skills with a unique SQL and Tableau project.
Topics & tools
retention curvestacked bar charttableau dashboardcohort analysis tablemysql querykey performance indicatorscombo chartline chartcustomer engagementhover tooltipfunneldata analysisbar chartdata visualizationdashboard reportingtableauSQL
Your instructor
Head of Data Content at 365 Data Science | Theoretical Physicist | Educator in Physics, Mathematics, and Programming
Track record
Bringing real-world expertise from leading global companies
Academic background
Master's degree, Theoretical and Mathematical Physics
Course OVERVIEW
Description
CPE Credits: 7.5
Field of Study: Information Technology
Delivery Method: QAS Self Study
Delivery Method: QAS Self Study
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.
Prerequisites
- Any SQL environment (such as SQLite, MySQL Workbench, or an online SQL editor).
- Tableau Desktop or Tableau Public
- Python (version 3.8 or later), pandas library, and a code editor or IDE (e.g., Jupyter Notebook, Spyder, or VS Code)
Advanced preparation
Curriculum
65 lessons
33 exercises
1 project
3 exams
- 2. Introduction to the Customer Engagement Analysis Case Study26 MinThis 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.
- 3. Retrieving Relevant Data from the Database31 MinIn 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.
- 4. Building the Dashboard – Introduction to Dashboards22 MinThis 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.
- 5. Building the Dashboard – The Overview Page55 MinIn 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) FreeCreating the KPIs (Part 2) FreeAssignment 2 FreeHorizontal Bar Chart – Overall Minutes Watched FreeFormatting the Horizontal Bar Chart FreeAssignment 3 FreeSwapping Between Charts Using a Parameter FreeDonut Chart – Ratings FreeAssignment 4 FreeCreating the First Page of the Dashboard (Part 1) FreeAssignment 5 FreeCreating the First Page of the Dashboard (Part 2) FreeAssignment 6 FreeCreating the First Page of the Dashboard (Part 3) Free
- 6. Building the Dashboard – The Engagement and Onboarding Page27 MinThis 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) FreeLine chart – Onboarded to Registered Students (Choosing the Engagement Period) FreeAssignment 7 FreeLine and Bar Charts - Number of Engaged Students (Choosing the Month and Year) FreeAssignment 8 FreeCreating the Second Page of the Dashboard FreeAssignment 9 FreeConfiguring the Navigation Buttons FreeAssignment 10 Free
- 7. Building the Dashboard – The Engagement by Cohorts Page29 MinWe 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.
- 8. Building the Dashboard – The Exams and Certificates Page18 MinThis 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.
- 9. Building the Dashboard – The Content Consumption Page11 MinThe 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.
- 10. Discussion and Insights47 MinThe 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) FreeInterpreting the Data (Onboarding and Retention) FreeInterpreting the Data (Content Consumption) FreeInterpreting the Data (F2P CR and Subscription Duration) FreeInterpreting the Data (Courses Engagement) FreeInterpreting the Data (Exams) FreeInterpreting the Data (Certificates) FreeFurther Steps and Improvement Free
- 11. Course project and exam690 Min
Free preview
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
94%
of AI and data science graduates
successfully change
or advance their careers.
9 in 10
people walk away career-ready
with practical data and AI skills.
$29,000
average salary increase
after moving to an AI and data science career
ACCREDITED certificates
Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global
institutions.
Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities
employers value most.
How it WORKS
Student REVIEWS
