Customer Behavior Analysis with SQL and Tableau

سرفصل های دوره

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

1. Introduction To The Course

1. What Does the Course Cover

2. Motivation - Our Story

2. Introduction To The Customer Engagement Analysis Case Study

1. The Case Study

2. The Case Study.html

3. Defining the Key Questions (Part 1)

4. Defining the Key Questions (Part 1).html

5. Defining the Key Questions (Part 2)

6. Defining the Key Questions (Part 2).html

7. Sketching the Dashboard (Part 1)

8. Sketching the Dashboard (Part 2)

3. Retrieving Relevant Data From The Database

1. Types of Data Access

2. Types of Data Access.html

3.1 customer behavior.xlsx

3.2 customer engagement.zip

3. Importing and Presenting the Database

4. SQL Query Activity by Dates (Part 1)

5. SQL Query Activity by Dates (Part 2)

6.1 dashboard queries.zip

6. SQL Query Activity by Dates (Part 3)

7. SQL Query Activity by Dates (Part 3).html

4. Building The Dashboard - Introduction To Dashboards

1.1 demo dashboard.zip

1. Fixing the Size of the Dashboard

2. The Horizontal, Vertical, and Blank Objects

3. The Text, Image, and Navigation Objects

4. Creating an Item Hierarchy

5. Tiled versus Floating Layout

5. Building The Dashboard - The Overview Page

1.1 images.zip

1.2 tableau datasources.zip

1. Creating the KPIs (Part 1)

2. Creating the KPIs (Part 2)

3. Assignment 1.html

4.1 1. overview - workbook 1.zip

4. Horizontal Bar Chart Overall Minutes Watched

5. Formatting the Horizontal Bar Chart

6. Assignment 2.html

7.1 1. overview - workbook 2.zip

7. Swapping Between Charts Using a Parameter

8. Donut Chart Ratings

9. Assignment 3.html

10.1 1. overview - workbook 3.zip

10. Creating the First Page of the Dashboard (Part 1)

11. Assignment 4.html

12. Creating the First Page of the Dashboard (Part 2)

13. Assignment 5.html

14.1 1. overview - workbook 4.zip

14. Creating the First Page of the Dashboard (Part 3)

6. Building The Dashboard - The Engagement And Onboarding Page

1.1 2. engagement - workbook 1.zip

1. Line Chart Number of Engaged Students (Choosing the Engagement Period)

2. Line chart Onboarded to Registered Students (Choosing the Engagement Period)

3.1 2. sheet instructions.pdf

3. Assignment 6.html

4.1 2. engagement - workbook 2.zip

4. Line and Bar Charts - Number of Engaged Students (Choosing the Month and Year)

5. Assignment 7.html

6.1 2. engagement - workbook 3.zip

6. Creating the Second Page of the Dashboard

7.1 2. dashboard instructions 1.pdf

7.2 2. dashboard instructions 2.pdf

7.3 2. dashboard instructions 3.pdf

7. Assignment 8.html

8.1 2. engagement - workbook 4.zip

8. Configuring the Navigation Buttons

9. Assignment 9.html

7. Building The Dashboard - The Engagement By Cohorts Page

1. What is a Cohort Analysis

2.1 3. cohorts - workbook 1.zip

2.2 student engagement.zip

2. Cohort Tables Retention of Student Engagement

3. Retention Curves Retention of Student Engagement

4.1 3. sheet instructions 1.pdf

4.2 3. sheet instructions 2.pdf

4. Assignment 10.html

5.1 3. cohorts - workbook 2.zip

5. Creating the Third Page of the Dashboard

6.1 3. dashboard instructions.pdf

6. Assignment 11.html

7.1 3. cohorts - workbook 3.zip

7.2 info.zip

7. Creating a Hover Tooltip

8. Assignment 12.html

8. Building The Dashboard - The Exams And Certificates Page

1.1 4. exams - workbook 1.zip

1. Horizontal Stacked Bar Chart Number of Exams Attempted

2.1 4. sheet instructions 1.pdf

2. Assignment 13.html

3.1 4. exams - workbook 2.zip

3. Bar Charts Certificates Issuance and Career Track Funnel

4.1 4. sheet instructions 2.pdf

4.2 4. sheet instructions 3.pdf

4. Assignment 14.html

5.1 4. exams - workbook 3.zip

5. Creating the Fourth Page of the Dashboard

6. Assignment 15.html

9. Building The Dashboard - The Content Consumption Page

1.1 5. learning - workbook 1.zip

1. Combo Charts Minutes Watched and Minutes Watched per User

2.1 5. learning - workbook 2.zip

2. Combo Chart F2P Conversion Rate and Subscription Duration

10. Discussion And Insights

1. Interpreting the Data (Platform Engagement)

2. Interpreting the Data (Onboarding and Retention)

3. Interpreting the Data (Content Consumption)

4. Interpreting the Data (F2P CR and Subscription Duration)

5. Interpreting the Data (Courses Engagement)

6. Interpreting the Data (Exams)

7. Interpreting the Data (Certificates)

8. Further Steps and Improvement

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy