Growth Analysis with SQL, Python, and Tableau

with Nikola Pulev
4.9/5
(55)

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

4 hours of content 1040 students

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 4 hours of content
  • 41 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Growth Analysis with SQL, Python, and Tableau

A course by Nikola Pulev

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 4 hours of content
  • 41 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

$99.00

Lifetime access

Buy now

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 4 hours of content
  • 41 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Improve your SQL, Python, and Tableau proficiency by tackling complex real-world business datasets
  • Interpret subscriptions and transactions data to uncover actionable insights that can boost revenue growth
  • Create professional and well-formatted multi-page Tableau dashboards
  • Develop sharp business acumen by using data to identify business challenges, analyse trends, and propose improvements
  • Take advantage of an excellent opportunity to add a unique project to your portfolio
  • Master data visualization by creating sophisticated and informative charts in Tableau

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

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.

Learn for Free

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

Curriculum

  • 1. Introduction to the Course
    2 Lessons 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?
    4 min
    Motivation - Our Story
    5 min
  • 2. Case Study Overview
    6 Lessons 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
    3 min
    Term Definitions - Visitors, UTMs, Channel of Acquisition
    9 min
    Term Definitions - User Types and Funnels
    5 min
    Key Questions and Metrics
    5 min
    Sketching the Dashboard (Part 1)
    5 min
    Sketching the Dashboard (Part 2)
    5 min
  • 3. Retrieving Relevant Data from the Database
    14 Lessons 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 
    10 min
    The Database - Part 1
    7 min
    The Database - Part 2
    5 min
    Funnels - Theory
    6 min
    Funnel - SQL Query (Part 1)
    6 min
    Funnel - SQL Query (Part 2)
    6 min
    Funnel - SQL Query (Part 3)
    6 min
    Waterfall Chart - Theory
    8 min
    Waterfall Chart - SQL Query
    4 min
    Waterfall Chart - Processing the Data in Python (Part 1)
    3 min
    Waterfall Chart - Processing the Data in Python (Part 2)
    12 min
    Waterfall Chart - Processing the Data in Python (Part 3)
    7 min
    Waterfall Chart - Data Export (Part 4)
    3 min
    Assignment 1 - Create SQL queries Read now
    1 min
  • 4. Crafting the Graphs
    18 Lessons 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
    2 min
    The Free and Conversions Graph (Part 1)
    5 min
    The Free and Conversions Graph (Part 2)
    6 min
    The Free and Conversions Graph (Part 3)
    3 min
    The Free and Conversions Graph (Part 4)
    6 min
    The Free and Conversions Graph (Part 5)
    6 min
    Assignment 2 - Labels toggle Read now
    1 min
    The Free and Conversions Graph (Part 6)
    3 min
    Paid per Date Graph
    5 min
    Paid per Date – Styling and Formatting
    6 min
    Waterfall Chart
    9 min
    Assignment 3 - Other Waterfall Chart Periods Read now
    1 min
    Visitors Bar Chart
    9 min
    Assignment 4 - Create Visitors Bar Chart for Monthly Read now
    1 min
    Homepage KPIs
    8 min
    Assignment 5 - Homepage KPIs for Quarterly and Annual Read now
    1 min
    Assignment 6 - Create Maps and Funnel Read now
    1 min
    The Rest of the Graphs
    2 min
  • 5. Assembling the Dashboard
    8 Lessons 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
    10 min
    The Title Banner (Part 2)
    5 min
    Incorporating the Graphs into the First Page
    7 min
    The First Page – Continuation
    3 min
    Constructing the Second Page – Sheet Swapping
    6 min
    Assignment 7 - Populate Pages 3,4 and 5 Read now
    1 min
    Assignment 8 - Create the Homepage Read now
    1 min
    Constructing the Homepage
    4 min
  • 6. Discussions and Insights
    7 Lessons 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
    2 min
    Free Users Data
    4 min
    Paid Users Data
    6 min
    Waterfall Chart – Subscriptions
    4 min
    Visitors Data
    4 min
    Maps
    3 min
    Closing Thoughts
    2 min

Topics

Tableau DashboardMySQL queryKey Performance IndicatorsFunnelCombo ChartLine chartdata analysisStacked Bar ChartBar chartWaterfall ChartGrowth MetricsHover Tooltip

Tools & Technologies

tableau
sql
python

Course Requirements

  • Highly recommended to take the SQL, Intro to Python, and Intro to Tableau courses first
  • You will need to install MySQL Workbench
  • You will need to install Tableau Public
  • You will need to install the Anaconda package, which includes Jupyter Notebook

Who Should Take This Course?

Level of difficulty: Advanced

  • Aspiring data analysts
  • Current data analysts who want to improve their technical and business skills

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Exams and certification

Meet Your Instructor

Nikola Pulev

Nikola Pulev

Course Creator at

6 Courses

1728 Reviews

26149 Students

Nikola Pulev is a Natural Sciences graduate from the University of Cambridge (UK) turned data science practitioner and a course instructor at 365 Data Science. Nikola has a strong passion for mathematics, physics, and programming. Over the years, he has taken part in multiple national and international competitions, where he has won numerous awards. One of Nikola’s most notable achievements so far is his silver medal from the International Physics Olympiad.

What Our Learners Say

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.

Recommended Courses