05.04.2024
So interesting and well-detailed.The instructor explained well
Growth Analysis with SQL, Python, and Tableau
with
Nikola Pulev
Master the creation of a growth data dashboard from inception to completion in our Growth Analysis with SQL, Python, and Tableau course. Learn to identify key metrics, extract relevant data from databases effectively, and construct a professional Tableau dashboard, acquiring numerous tips and tricks throughout the process.
4 hours 47 lessons
Start course
47 High Quality Lessons
8 Practical Tasks
4 Hours of Content
Certificate of Achievement
Course Overview
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.
Topics covered
Bar chartCombo Chartdata analysisFunnelGrowth MetricsHover TooltipKey Performance IndicatorsLine chartMySQL queryStacked Bar ChartTableau DashboardWaterfall Chart
What You'll Learn
We'll develop a growth analysis report utilizing SQL, Python, and Tableau. The course will offer insights into executing the process and add Tableau tips and tricks for effective workarounds.
Visualize data effectively
Execute advanced MySQL queries
Integrate SQL, Python, and Tableau for robust analysis
Create insightful Tableau dashboards
Construct informative waterfall charts
Extract actionable insights from data
Curriculum
- Introduction to the Course2 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? FreeMotivation - Our Story - Case Study Overview6 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 FreeTerm Definitions - Visitors, UTMs, Channel of Acquisition FreeTerm Definitions - User Types and FunnelsKey Questions and MetricsSketching the Dashboard (Part 1)Sketching the Dashboard (Part 2) - Retrieving Relevant Data from the Database13 Lessons 83 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 FreeThe Database - Part 1The Database - Part 2Funnels - TheoryFunnel - SQL Query (Part 1)Funnel - SQL Query (Part 2)Funnel - SQL Query (Part 3)Waterfall Chart - TheoryWaterfall Chart - SQL QueryWaterfall 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)Waterfall Chart - Data Export (Part 4) - Crafting the Graphs13 Lessons 70 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 FreeThe Free and Conversions Graph (Part 1) FreeThe 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)The Free and Conversions Graph (Part 6)Paid per Date GraphPaid per Date – Styling and FormattingWaterfall ChartVisitors Bar ChartHomepage KPIsThe Rest of the Graphs - Assembling the Dashboard6 Lessons 35 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 BannerThe Title Banner (Part 2)Incorporating the Graphs into the First PageThe First Page – ContinuationConstructing the Second Page – Sheet SwappingConstructing the Homepage - Discussions and Insights7 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 InterpretationFree Users DataPaid Users DataWaterfall Chart – SubscriptionsVisitors DataMapsClosing Thoughts
Student feedback
Filter by rating
- 5 stars
- 4 stars
- 3 stars
- 2 stars
- 1 stars
Sort
- Newest
- Oldest
Growth Analysis with SQL, Python, and Tableau
with Nikola Pulev