Growth Analysis with SQL, Python, and Tableau

Name: Growth Analysis with SQL, Python, and Tableau Course
Price: 36 USD

with Nikola Pulev

4.9/5

(53)

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

4 hours of content 995 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

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

1.1 What Does the Course Cover?

4 min

1.2 Motivation - Our Story

5 min

2.1 Introduction to the Project

3 min

2.2 Term Definitions - Visitors, UTMs, Channel of Acquisition

9 min

2.3 Term Definitions - User Types and Funnels

5 min

2.4 Key Questions and Metrics

5 min

Interactive Exercises
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.

Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.

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

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.

Meet Your Instructor

Nikola Pulev

Course Creator at

6 Courses

1713 Reviews

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