Watch Me Analysing Data in SQL, Python and Tableau
Join my Academy, learn Data & AI skills and land a job👇
https://analyticsautomation.academy/
On the surface, SQL, Python, and Tableau seem interchangeable for data tasks, but each shows surprising strengths and limitations.
In this video, I demonstrate how to perform key data analytics tasks like total profit, order counts, and sales trends using SQL, Python, and Tableau, highlighting the challenges of tool setup and choosing the right approach for each task.
💬 CONNECT WITH ME
Connect on Linkedin 👉 / lorenzo--rosa
DM me on Instagram 👉 / loresowhat
📩 Get in touch:
[email protected]
🔎 CONTENT
0:00 Introduction and Overview
1:20 Dataset Introduction and Overview
2:12 Setting Up Python Environment
3:25 Setting Up SQL Environment with Google BigQuery
4:30 Setting Up Tableau Environment
5:16 Task 1: Calculating Total Profit by City
7:44 Task 2: Calculating Number of Orders per Customer
12:39 Task 3: Profitability of Subcategories with Condition
16:30 Task 4: Calculating and Visualizing Sales Trend Over Time
21:47 Conclusion and Next Steps
#DataAnalytics #SQLvsPythonvsTableau #DataVisualization