Customer Behavior Analysis with SQL and Tableau
Unlock Business Insights and Master SQL and Tableau: Get Real-life Data Analyst Experience
Lo que serás capaz de hacer
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!
- Select Key Performance Indicators
- Draft Dashboard Structure
- Data visualization Best Practices
- Create MySQL queries
- Gain Insights from Data
- Propose Strategies to Improve Business Objectives
Temario
UNIDAD 1 - Introduction To The Course · 2 leccionesUNIDAD 1 - Introduction To The Course
UNIDAD 1 - Introduction To The Course
- What Does the Course Cover?
- Motivation - Our Story
UNIDAD 2 - Introduction To The Customer Engagement Analysis Case Study · 8 leccionesUNIDAD 2 - Introduction To The Customer Engagement Analysis Case Study
UNIDAD 2 - Introduction To The Customer Engagement Analysis Case Study
- The Case Study
- The Case Study
- Defining the Key Questions (Part 1)
- Defining the Key Questions (Part 1)
- Defining the Key Questions (Part 2)
- Defining the Key Questions (Part 2)
- Sketching the Dashboard (Part 1)
- Sketching the Dashboard (Part 2)
UNIDAD 3 - Retrieving Relevant Data From The Database · 8 leccionesUNIDAD 3 - Retrieving Relevant Data From The Database
UNIDAD 3 - Retrieving Relevant Data From The Database
- Types of Data Access
- Types of Data Access
- Importing and Presenting the Database
- SQL Query – Activity by Dates (Part 1)
- SQL Query – Activity by Dates (Part 2)
- SQL Query – Activity by Dates (Part 3)
- SQL Query – Activity by Dates (Part 3)
- Assignment 1
UNIDAD 4 - Building The Dashboard – Introduction To Dashboards · 5 leccionesUNIDAD 4 - Building The Dashboard – Introduction To Dashboards
UNIDAD 4 - Building The Dashboard – Introduction To Dashboards
- Fixing the Size of the Dashboard
- The Horizontal, Vertical, and Blank Objects
- The Text, Image, and Navigation Objects
- Creating an Item Hierarchy
- Tiled versus Floating Layout
UNIDAD 5 - Building The Dashboard – The Overview Page · 14 leccionesUNIDAD 5 - Building The Dashboard – The Overview Page
UNIDAD 5 - Building The Dashboard – The Overview Page
- Creating the KPIs (Part 1)
- Creating the KPIs (Part 2)
- Assignment 2
- Horizontal Bar Chart – Overall Minutes Watched
- Formatting the Horizontal Bar Chart
- Assignment 3
- Swapping Between Charts Using a Parameter
- Donut Chart – Ratings
- Assignment 4
- Creating the First Page of the Dashboard (Part 1)
- Assignment 5
- Creating the First Page of the Dashboard (Part 2)
- Assignment 6
- Creating the First Page of the Dashboard (Part 3)
UNIDAD 6 - Building The Dashboard – The Engagement And Onboarding Page · 9 leccionesUNIDAD 6 - Building The Dashboard – The Engagement And Onboarding Page
UNIDAD 6 - Building The Dashboard – The Engagement And Onboarding Page
- Line Chart – Number of Engaged Students (Choosing the Engagement Period)
- Line chart – Onboarded to Registered Students (Choosing the Engagement Period)
- Assignment 7
- Line and Bar Charts - Number of Engaged Students (Choosing the Month and Year)
- Assignment 8
- Creating the Second Page of the Dashboard
- Assignment 9
- Configuring the Navigation Buttons
- Assignment 10
UNIDAD 7 - Building The Dashboard – The Engagement By Cohorts Page · 8 leccionesUNIDAD 7 - Building The Dashboard – The Engagement By Cohorts Page
UNIDAD 7 - Building The Dashboard – The Engagement By Cohorts Page
- What is a Cohort Analysis?
- Cohort Tables – Retention of Student Engagement
- Retention Curves – Retention of Student Engagement
- Assignment 11
- Creating the Third Page of the Dashboard
- Assignment 12
- Creating a Hover Tooltip
- Assignment 13
UNIDAD 8 - Building The Dashboard – The Exams And Certificates Page · 6 leccionesUNIDAD 8 - Building The Dashboard – The Exams And Certificates Page
UNIDAD 8 - Building The Dashboard – The Exams And Certificates Page
- Horizontal Stacked Bar Chart – Number of Exams Attempted
- Assignment 14
- Bar Charts – Certificates Issuance and Career Track Funnel
- Assignment 15
- Creating the Fourth Page of the Dashboard
- Assignment 16
UNIDAD 9 - Building The Dashboard – The Content Consumption Page · 2 leccionesUNIDAD 9 - Building The Dashboard – The Content Consumption Page
UNIDAD 9 - Building The Dashboard – The Content Consumption Page
- Combo Charts – Minutes Watched and Minutes Watched per User
- Combo Chart – F2P Conversion Rate and Subscription Duration
UNIDAD 10 - Discussion And Insights · 8 leccionesUNIDAD 10 - Discussion And Insights
UNIDAD 10 - Discussion And Insights
- Interpreting the Data (Platform Engagement)
- Interpreting the Data (Onboarding and Retention)
- Interpreting the Data (Content Consumption)
- Interpreting the Data (F2P CR and Subscription Duration)
- Interpreting the Data (Courses Engagement)
- Interpreting the Data (Exams)
- Interpreting the Data (Certificates)
- Further Steps and Improvement
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
10 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
5 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por 365 Careers.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 10 unidades · 70 lecciones · 50 h
- 12 meses de acceso
- 5 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por 365 Careers; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
