05.04.2024
So interesting and well-detailed.The instructor explained well
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.
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.
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.
This section introduces the course and covers what you’ll learn. We also touch on the prerequisites: SQL, Python, and Tableau fundamentals.
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.
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.
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.
We'll organize all completed graphs across various dashboard pages, utilizing containers and navigation buttons disguised as filters to enhance user experience.
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.
Student feedback
Growth Analysis with SQL, Python, and Tableau
with Nikola Pulev