Customer Behavior Analysis with SQL and Tableau

Customer Behavior Analysis with SQL and Tableau, available at $19.99, has an average rating of 4.69, with 65 lectures, 5 quizzes, based on 131 reviews, and has 1258 subscribers.

You will learn about Select Key Performance Indicators Draft Dashboard Structure Data visualization Best Practices Create MySQL queries Gain Insights from Data Propose Strategies to Improve Business Objectives This course is ideal for individuals who are Aspiring Data Analysts or Data Analysts Eager to Improve Their Skills It is particularly useful for Aspiring Data Analysts or Data Analysts Eager to Improve Their Skills.

Enroll now: Customer Behavior Analysis with SQL and Tableau

Summary

Title: Customer Behavior Analysis with SQL and Tableau

Price: $19.99

Average Rating: 4.69

Number of Lectures: 65

Number of Quizzes: 5

Number of Published Lectures: 65

Number of Published Quizzes: 5

Number of Curriculum Items: 70

Number of Published Curriculum Objects: 70

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Select Key Performance Indicators
Draft Dashboard Structure
Data visualization Best Practices
Create MySQL queries
Gain Insights from Data
Propose Strategies to Improve Business Objectives

Who Should Attend

Aspiring Data Analysts
Data Analysts Eager to Improve Their Skills

Target Audiences

Aspiring Data Analysts
Data Analysts Eager to Improve Their Skills

Do you want to become a job-ready data analyst?

Have you learned the basics and are looking for an opportunity to take your SQL, Tableau, and data analysis skills to the next level?

If that’s the case, this is the perfect course for you!

In this training, Hristina Hristova, an experienced data analyst working at 365 Data Science, will guide you through the complete process of drafting a dashboard aimed at answering specific business questions. She will help you retrieve raw data from SQL, preprocess it, and work on data visualizations in Tableau. At the end of the course, she’ll discuss her findings and pinpoint areas for potential improvement in the 365 Data Science platform.

Acquiring the technical skills to get hired as a data analyst is essential. However, it can be even more crucial to demonstrate your ability to solve real-world business problems. This course offers a unique opportunity to enhance your skills with tools like SQL and Tableau and gain invaluable practical experience learning how data analysts approach problem-solving tasks on the job.

One of the most exciting aspects of the Customer Behavior Analysis course is its use of real-life data from 365 Data Science’s own platform. Some of the topics covered include creating sophisticated queries in MySQL, designing various types of charts in Tableau (like bar charts, combo charts, funnel charts, and line charts), building a cohort analysis table, retention curve, and ultimately, a Tableau dashboard.

As you can see, this course provides the perfect blend of technical and practical skills.

So, what are you waiting for?

Click “Buy Now” and acquire real-world data analyst skills today!

Course Curriculum

Chapter 1: Introduction To The Course

Lecture 1: What Does the Course Cover?

Lecture 2: Motivation – Our Story

Chapter 2: Introduction To The Customer Engagement Analysis Case Study

Lecture 1: The Case Study

Lecture 2: Defining the Key Questions (Part 1)

Lecture 3: Defining the Key Questions (Part 2)

Lecture 4: Sketching the Dashboard (Part 1)

Lecture 5: Sketching the Dashboard (Part 2)

Chapter 3: Retrieving Relevant Data From The Database

Lecture 1: Types of Data Access

Lecture 2: Importing and Presenting the Database

Lecture 3: SQL Query – Activity by Dates (Part 1)

Lecture 4: SQL Query – Activity by Dates (Part 2)

Lecture 5: SQL Query – Activity by Dates (Part 3)

Lecture 6: Assignment 1

Chapter 4: Building The Dashboard – Introduction To Dashboards

Lecture 1: Fixing the Size of the Dashboard

Lecture 2: The Horizontal, Vertical, and Blank Objects

Lecture 3: The Text, Image, and Navigation Objects

Lecture 4: Creating an Item Hierarchy

Lecture 5: Tiled versus Floating Layout

Chapter 5: Building The Dashboard – The Overview Page

Lecture 1: Creating the KPIs (Part 1)

Lecture 2: Creating the KPIs (Part 2)

Lecture 3: Assignment 2

Lecture 4: Horizontal Bar Chart – Overall Minutes Watched

Lecture 5: Formatting the Horizontal Bar Chart

Lecture 6: Assignment 3

Lecture 7: Swapping Between Charts Using a Parameter

Lecture 8: Donut Chart – Ratings

Lecture 9: Assignment 4

Lecture 10: Creating the First Page of the Dashboard (Part 1)

Lecture 11: Assignment 5

Lecture 12: Creating the First Page of the Dashboard (Part 2)

Lecture 13: Assignment 6

Lecture 14: Creating the First Page of the Dashboard (Part 3)

Chapter 6: Building The Dashboard – The Engagement And Onboarding Page

Lecture 1: Line Chart – Number of Engaged Students (Choosing the Engagement Period)

Lecture 2: Line chart – Onboarded to Registered Students (Choosing the Engagement Period)

Lecture 3: Assignment 7

Lecture 4: Line and Bar Charts – Number of Engaged Students (Choosing the Month and Year)

Lecture 5: Assignment 8

Lecture 6: Creating the Second Page of the Dashboard

Lecture 7: Assignment 9

Lecture 8: Configuring the Navigation Buttons

Lecture 9: Assignment 10

Chapter 7: Building The Dashboard – The Engagement By Cohorts Page

Lecture 1: What is a Cohort Analysis?

Lecture 2: Cohort Tables – Retention of Student Engagement

Lecture 3: Retention Curves – Retention of Student Engagement

Lecture 4: Assignment 11

Lecture 5: Creating the Third Page of the Dashboard

Lecture 6: Assignment 12

Lecture 7: Creating a Hover Tooltip

Lecture 8: Assignment 13

Chapter 8: Building The Dashboard – The Exams And Certificates Page

Lecture 1: Horizontal Stacked Bar Chart – Number of Exams Attempted

Lecture 2: Assignment 14

Lecture 3: Bar Charts – Certificates Issuance and Career Track Funnel

Lecture 4: Assignment 15

Lecture 5: Creating the Fourth Page of the Dashboard

Lecture 6: Assignment 16

Chapter 9: Building The Dashboard – The Content Consumption Page

Lecture 1: Combo Charts – Minutes Watched and Minutes Watched per User

Lecture 2: Combo Chart – F2P Conversion Rate and Subscription Duration

Chapter 10: Discussion And Insights

Lecture 1: Interpreting the Data (Platform Engagement)

Lecture 2: Interpreting the Data (Onboarding and Retention)

Lecture 3: Interpreting the Data (Content Consumption)

Lecture 4: Interpreting the Data (F2P CR and Subscription Duration)

Lecture 5: Interpreting the Data (Courses Engagement)

Lecture 6: Interpreting the Data (Exams)

Lecture 7: Interpreting the Data (Certificates)

Lecture 8: Further Steps and Improvement

Instructors

365 Careers
Creating opportunities for Data Science and Finance students

Rating Distribution

1 stars: 0 votes
2 stars: 2 votes
3 stars: 5 votes
4 stars: 42 votes
5 stars: 82 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu