Customer Behavior Analysis with SQL and Tableau

Focused View

365 Careers

4:21:08

33 View

1. Introduction To The Course

1. What Does the Course Cover.mp4

03:57

2. Motivation - Our Story.mp4

05:06

2. Introduction To The Customer Engagement Analysis Case Study

1. The Case Study.mp4

05:06

2. The Case Study.html

3. Defining the Key Questions (Part 1).mp4

07:14

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

5. Defining the Key Questions (Part 2).mp4

06:20

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

7. Sketching the Dashboard (Part 1).mp4

03:41

8. Sketching the Dashboard (Part 2).mp4

03:43

3. Retrieving Relevant Data From The Database

1. Types of Data Access.mp4

08:13

2. Types of Data Access.html

3.1 customer behavior.xlsx

3.2 customer engagement.zip

3. Importing and Presenting the Database.mp4

07:05

4. SQL Query Activity by Dates (Part 1).mp4

08:10

5. SQL Query Activity by Dates (Part 2).mp4

01:30

6.1 dashboard queries.zip

6. SQL Query Activity by Dates (Part 3).mp4

05:03

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.mp4

03:04

2. The Horizontal, Vertical, and Blank Objects.mp4

04:43

3. The Text, Image, and Navigation Objects.mp4

05:35

4. Creating an Item Hierarchy.mp4

01:37

5. Tiled versus Floating Layout.mp4

05:52

5. Building The Dashboard - The Overview Page

1.1 images.zip

1.2 tableau datasources.zip

1. Creating the KPIs (Part 1).mp4

06:12

2. Creating the KPIs (Part 2).mp4

06:02

3. Assignment 1.html

4.1 1. overview - workbook 1.zip

4. Horizontal Bar Chart Overall Minutes Watched.mp4

06:52

5. Formatting the Horizontal Bar Chart.mp4

01:51

6. Assignment 2.html

7.1 1. overview - workbook 2.zip

7. Swapping Between Charts Using a Parameter.mp4

03:17

8. Donut Chart Ratings.mp4

05:46

9. Assignment 3.html

10.1 1. overview - workbook 3.zip

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

08:45

11. Assignment 4.html

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

07:59

13. Assignment 5.html

14.1 1. overview - workbook 4.zip

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

03:51

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).mp4

06:25

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

03:41

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).mp4

05:22

5. Assignment 7.html

6.1 2. engagement - workbook 3.zip

6. Creating the Second Page of the Dashboard.mp4

05:27

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.mp4

02:30

9. Assignment 9.html

7. Building The Dashboard - The Engagement By Cohorts Page

1. What is a Cohort Analysis.mp4

06:27

2.1 3. cohorts - workbook 1.zip

2.2 student engagement.zip

2. Cohort Tables Retention of Student Engagement.mp4

06:01

3. Retention Curves Retention of Student Engagement.mp4

02:24

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.mp4

06:00

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.mp4

05:38

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.mp4

04:21

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.mp4

05:47

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.mp4

04:40

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.mp4

05:25

2.1 5. learning - workbook 2.zip

2. Combo Chart F2P Conversion Rate and Subscription Duration.mp4

06:20

10. Discussion And Insights

1. Interpreting the Data (Platform Engagement).mp4

05:17

2. Interpreting the Data (Onboarding and Retention).mp4

08:04

3. Interpreting the Data (Content Consumption).mp4

04:17

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

06:57

5. Interpreting the Data (Courses Engagement).mp4

05:13

6. Interpreting the Data (Exams).mp4

03:49

7. Interpreting the Data (Certificates).mp4

07:00

8. Further Steps and Improvement.mp4

07:29

Description

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

Who is this for?

Aspiring Data Analysts

Data Analysts Eager to Improve Their Skills

What You Need to Know?

Basic SQL Skills

Basic Tableau Skills

More details

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!
Who this course is for:
Aspiring Data Analysts
Data Analysts Eager to Improve Their Skills

User Reviews

Rating

average 0

Total votes0

Focused display

365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 2,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, 365 focuses on the following topics on Udemy: 1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook5) Blockchain for BusinessAll of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur365 Careers’ courses are the perfect place to start.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.