Watch me Do a Data Analyst Project in minutes with Python
Join my Academy, learn Data & AI skills and land a job👇
https://analyticsautomation.academy/
This video teaches a full Python data analysis project using real data.
In this video, I walk through a complete Python data analytics project using real data, tackling common issues like data cleaning and stock-out analysis to uncover lost revenue and actionable business insights.
All resources used in the video can be found here: https://drive.google.com/drive/folder...
📸 SOCIAL Instagram and TikTok - @Loresowhat
/ loresowhat
/ loresowhat
📩 Get in touch:
[email protected]
🔎 CONTENT
0:00 Introduction and Project Overview
2:11 Setting up Python Environment in Google Colab
3:39 Loading and Inspecting the Dataset
4:15 Data Cleaning: Handling Price Column
8:26 Project Objective: Analyzing Supply Chain
9:22 Extracting Brand Information from Description
13:34 Mapping Brand Names and Filtering Data
17:12 Analyzing Stock and Out of Stock Sizes
18:04 Defining Function to Calculate Phantom Revenue
20:03 Applying Stock Out Function to Dataset
21:04 Calculating Lost Revenue from Out of Stock Items
23:12 Summarizing Insights and Next Steps
23:42 Aggregating Data and Grouping by Brand
25:20 Creating Visualization for Brand Strategy Analysis
29:10 Interpreting the Brand Strategy Scatter Plot
32:05 Final Recommendations and Conclusion
#PythonDataAnalytics #DataAnalyticsProject #DataSciencePortfolio