Customer Behavior Analysis With Sql And Tableau

Unlock Business Insights and Master SQL and Tableau: Get Real-life Data Analyst Experience

What you'll 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

Requirements

Basic SQL Skills

Basic Tableau Skills

Description

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!

Overview

Section 1: Introduction To The Course

Lecture 1 What Does the Course Cover?

Lecture 2 Motivation - Our Story

Section 2: Introduction To The Customer Engagement Analysis Case Study

Lecture 3 The Case Study

Lecture 4 Defining the Key Questions (Part 1)

Lecture 5 Defining the Key Questions (Part 2)

Lecture 6 Sketching the Dashboard (Part 1)

Lecture 7 Sketching the Dashboard (Part 2)

Section 3: Retrieving Relevant Data From The Database

Lecture 8 Types of Data Access

Lecture 9 Importing and Presenting the Database

Lecture 10 SQL Query – Activity by Dates (Part 1)

Lecture 11 SQL Query – Activity by Dates (Part 2)

Lecture 12 SQL Query – Activity by Dates (Part 3)

Section 4: Building The Dashboard – Introduction To Dashboards

Lecture 13 Fixing the Size of the Dashboard

Lecture 14 The Horizontal, Vertical, and Blank Objects

Lecture 15 The Text, Image, and Navigation Objects

Lecture 16 Creating an Item Hierarchy

Lecture 17 Tiled versus Floating Layout

Section 5: Building The Dashboard – The Overview Page

Lecture 18 Creating the KPIs (Part 1)

Lecture 19 Creating the KPIs (Part 2)

Lecture 20 Assignment 1

Lecture 21 Horizontal Bar Chart – Overall Minutes Watched

Lecture 22 Formatting the Horizontal Bar Chart

Lecture 23 Assignment 2

Lecture 24 Swapping Between Charts Using a Parameter

Lecture 25 Donut Chart – Ratings

Lecture 26 Assignment 3

Lecture 27 Creating the First Page of the Dashboard (Part 1)

Lecture 28 Assignment 4

Lecture 29 Creating the First Page of the Dashboard (Part 2)

Lecture 30 Assignment 5

Lecture 31 Creating the First Page of the Dashboard (Part 3)

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

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

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

Lecture 34 Assignment 6

Lecture 35 Line and Bar Charts - Number of Engaged Students (Choosing the Month and Year)

Lecture 36 Assignment 7

Lecture 37 Creating the Second Page of the Dashboard

Lecture 38 Assignment 8

Lecture 39 Configuring the Navigation Buttons

Lecture 40 Assignment 9

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

Lecture 41 What is a Cohort Analysis?

Lecture 42 Cohort Tables – Retention of Student Engagement

Lecture 43 Retention Curves – Retention of Student Engagement

Lecture 44 Assignment 10

Lecture 45 Creating the Third Page of the Dashboard

Lecture 46 Assignment 11

Lecture 47 Creating a Hover Tooltip

Lecture 48 Assignment 12

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

Lecture 49 Horizontal Stacked Bar Chart – Number of Exams Attempted

Lecture 50 Assignment 13

Lecture 51 Bar Charts – Certificates Issuance and Career Track Funnel

Lecture 52 Assignment 14

Lecture 53 Creating the Fourth Page of the Dashboard

Lecture 54 Assignment 15

Section 9: Building The Dashboard – The Content Consumption Page

Lecture 55 Combo Charts – Minutes Watched and Minutes Watched per User

Lecture 56 Combo Chart – F2P Conversion Rate and Subscription Duration

Section 10: Discussion And Insights

Lecture 57 Interpreting the Data (Platform Engagement)

Lecture 58 Interpreting the Data (Onboarding and Retention)

Lecture 59 Interpreting the Data (Content Consumption)

Lecture 60 Interpreting the Data (F2P CR and Subscription Duration)

Lecture 61 Interpreting the Data (Courses Engagement)

Lecture 62 Interpreting the Data (Exams)

Lecture 63 Interpreting the Data (Certificates)

Lecture 64 Further Steps and Improvement

Aspiring Data Analysts,Data Analysts Eager to Improve Their Skills