Online Course top-rated
Growth Analysis with SQL, Python, and Tableau

Gain first-hand data analyst experience: Use SQL, Python, and Tableau to tackle real-world business challenges

4.8

863 reviews on
1,576 students already enrolled
  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Skill level:

Advanced

Duration:

4 hours
  • Lessons (4 hours)

CPE credits:

5.5
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited

certificate

What you learn

  • Improve your SQL, Python, and Tableau proficiency using real business data.
  • Interpret subscription and transaction data to find growth insights.
  • Create professional, multi-page Tableau dashboards with clean formatting.
  • Use data to spot challenges, analyze trends, and propose improvements.
  • Create a portfolio‑ready project with sophisticated Tableau visualizations.

Topics & tools

Tableau DashboardMySQL queryKey Performance IndicatorsFunnelCombo ChartLine chartData AnalysisStacked Bar ChartBar chartWaterfall ChartGrowth MetricsHover TooltipData VisualizationDashboard ReportingData PreprocessingTableauSqlPython

Your instructor

Course OVERVIEW

Description

CPE Credits: 5.5 Field of Study: Information Technology
Delivery Method: QAS Self Study
Every company aims to maximize its market presence. Consequently, growth metrics become a primary focus for analysis and monitoring month over month. In this course, we’ll develop a dashboard for tracking growth data. Utilizing SQL and Python, we'll extract relevant data from 365's database and import it into Tableau to create a professional, multi-page dashboard. Finally, we'll explore insights and findings from the visualizations.

Prerequisites

  • Any SQL environment (such as SQLite, MySQL Workbench, or an online SQL editor).
  • Tableau Desktop or Tableau Public
  • Python (version 3.8 or later), pandas library, and a code editor or IDE (e.g., Jupyter Notebook, Spyder, or VS Code)

Curriculum

55 lessons 1 exam
  • 1. Introduction to the Course
    9 min
    This section introduces the course and covers what you’ll learn. We also touch on the prerequisites: SQL, Python, and Tableau fundamentals.
    9 min
    This section introduces the course and covers what you’ll learn. We also touch on the prerequisites: SQL, Python, and Tableau fundamentals.
    What Does the Course Cover? Free
    Motivation - Our Story
  • 2. Case Study Overview
    32 min
    This part introduces the terminology and highlights the essential questions for a growth dashboard. These questions will guide us in designing the dashboard's layout and graphs.
    32 min
    This part introduces the terminology and highlights the essential questions for a growth dashboard. These questions will guide us in designing the dashboard's layout and graphs.
    Introduction to the Project Free
    Term Definitions - Visitors, UTMs, Channel of Acquisition Free
    Term Definitions - User Types and Funnels
    Key Questions and Metrics
    Sketching the Dashboard (Part 1)
    Sketching the Dashboard (Part 2)
  • 3. Retrieving Relevant Data from the Database
    84 min
    Here, we explore the 365 database utilized in this Growth Analysis with SQL, Python, and Tableau course—focusing on using MySQL to extract necessary data sources for graph creation. Additionally, Python will be employed to retrieve the data source for the waterfall chart.
    84 min
    Here, we explore the 365 database utilized in this Growth Analysis with SQL, Python, and Tableau course—focusing on using MySQL to extract necessary data sources for graph creation. Additionally, Python will be employed to retrieve the data source for the waterfall chart.
    Types of Data Access  Free
    The Database - Part 1
    The Database - Part 2
    Funnels - Theory
    Funnel - SQL Query (Part 1)
    Funnel - SQL Query (Part 2)
    Funnel - SQL Query (Part 3)
    Waterfall Chart - Theory
    Waterfall Chart - SQL Query
    Waterfall Chart - Processing the Data in Python (Part 1)
    Waterfall Chart - Processing the Data in Python (Part 2)
    Waterfall Chart - Processing the Data in Python (Part 3)
    Assignment 1 - Create SQL queries
    Waterfall Chart - Data Export (Part 4)
  • 4. Crafting the Graphs
    75 min
    Once all data sources are ready, we'll start crafting various graphs in Tableau for the dashboard, including (among others) combined bar and line charts, stacked bars, and waterfall charts. Along the way, we'll tackle unique challenges and innovative solutions—like adjusting the axis minimum, toggling labels, and conditional number formatting.
    75 min
    Once all data sources are ready, we'll start crafting various graphs in Tableau for the dashboard, including (among others) combined bar and line charts, stacked bars, and waterfall charts. Along the way, we'll tackle unique challenges and innovative solutions—like adjusting the axis minimum, toggling labels, and conditional number formatting.
    The Structure of This Section Free
    The Free and Conversions Graph (Part 1) Free
    The Free and Conversions Graph (Part 2)
    The Free and Conversions Graph (Part 3)
    The Free and Conversions Graph (Part 4)
    The Free and Conversions Graph (Part 5)
    Assignment 2 - Labels toggle
    The Free and Conversions Graph (Part 6)
    Paid per Date Graph
    Paid per Date – Styling and Formatting
    Waterfall Chart
    Assignment 3 - Other Waterfall Chart Periods
    Visitors Bar Chart
    Assignment 4 - Create Visitors Bar Chart for Monthly
    Homepage KPIs
    Assignment 5 - Homepage KPIs for Quarterly and Annual
    The Rest of the Graphs
    Assignment 6 - Create Maps and Funnel
  • 5. Assembling the Dashboard
    37 min
    We'll organize all completed graphs across various dashboard pages, utilizing containers and navigation buttons disguised as filters to enhance user experience.
    37 min
    We'll organize all completed graphs across various dashboard pages, utilizing containers and navigation buttons disguised as filters to enhance user experience.
    Dashboard Beginings – The Title Banner
    The Title Banner (Part 2)
    Incorporating the Graphs into the First Page
    The First Page – Continuation
    Constructing the Second Page – Sheet Swapping
    Assignment 7 - Populate Pages 3,4 and 5
    Assignment 8 - Create the Homepage
    Constructing the Homepage
  • 6. Discussions and Insights
    25 min
    The Growth Analysis with SQL, Python, and Tableau course’s final section is dedicated to analyzing the dashboard, gaining valuable insights, and suggesting changes that would ideally improve the platform’s performance and increase the company’s revenue.
    25 min
    The Growth Analysis with SQL, Python, and Tableau course’s final section is dedicated to analyzing the dashboard, gaining valuable insights, and suggesting changes that would ideally improve the platform’s performance and increase the company’s revenue.
    The Significance of Data Interpretation
    Free Users Data
    Paid Users Data
    Waterfall Chart – Subscriptions
    Visitors Data
    Maps
    Closing Thoughts
  • 7. Course exam
    40 min
    40 min
    Course exam

Free lessons

What Does the Course Cover?

1.1 What Does the Course Cover?

4 min

Motivation - Our Story

1.2 Motivation - Our Story

5 min

Introduction to the Project

2.1 Introduction to the Project

3 min

Term Definitions - Visitors, UTMs, Channel of Acquisition

2.2 Term Definitions - Visitors, UTMs, Channel of Acquisition

9 min

Term Definitions - User Types and Funnels

2.3 Term Definitions - User Types and Funnels

5 min

Key Questions and Metrics

2.4 Key Questions and Metrics

5 min

Start for free

96%

of our students recommend

365 Data Science.

4.8

Based on 863 reviews

#1 most reviewed

AI and data learning platform on Trustpilot.

9 in 10

of our graduates landed a new AI & data job

after enrollment

ACCREDITED certificates

Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global institutions.

Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities employers value most.

  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Certificates are included with the Self-study learning plan.

A LinkedIn profile mockup on a mobile screen showing Parker Maxwell, a Certified Data Analyst, with credentials from 365 Data Science listed under Licenses & Certification. A 365 Data Science Certificate of Achievement awarded to Parker Maxwell for completing the Data Analyst career track, featuring accreditation badges and a gold “Verified Certificate” seal.

How it WORKS

  • Lessons
  • Exercises
  • Projects
  • Practice exams
  • AI mock interviews

Lessons

Learn through short, simple lessons—no prior experience in AI or data science needed.

Try for free

Exercises

Reinforce your learning with mini recaps, hands-on coding, flashcards, fill-in-the-blank activities, and other engaging exercises.

Try for free

Projects

Tackle real-world AI and data science projects—just like those faced by industry professionals every day.

Try for free

Practice exams

Track your progress and solidify your knowledge with regular practice exams.

Try for free

AI mock interviews

Prep for interviews with real-world tasks, popular questions, and real-time feedback.

Try for free

Student REVIEWS

A collage of student testimonials from 365 Data Science learners, featuring profile photos, names, job titles, and quotes or video play icons, showcasing diverse backgrounds and successful career transitions into AI and data science roles.