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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024