Course: Data Analysis with Python
Topic: Product Profitability Analysis
Students work with a short sample of sales data from a retail or e-commerce company. The aim is to gain a quick understanding of the business problem and work through a complete, yet highly condensed, data analysis cycle. Microlearning makes it possible to focus on a single analytical issue while demonstrating
its practical significance for managerial decision-making.
Warm-Up (5 min)
The lecturer presents a scenario in which a company sells several product lines and wants to quickly assess which of them generate real value and which merely increase turnover. Students discuss which indicators could help a manager assess product profitability, including margin, sales volume and share of revenue. The discussion is guided and leads to a single, clearly defined analytical objective.
Data and Problem (10 min)
Students receive a small dataset containing product, revenue, cost and sales region data. The lecturer briefly explains the structure of the data and formulates the analytical question: which products should be developed further, and which may need to be withdrawn?
Business Interpretation (5 min)
Students work individually or in pairs to carry out a simple data analysis in Python, including loading the data, calculating margins, aggregating results by product and creating a basic visualisation, such as a bar chart. The code remains short and purposeful, focusing solely on solving the given problem without unnecessary technical digressions.
Quick Analysis (5 min)
Based on the results, students formulate two or three conclusions in managerial language, without referring to the code. They identify the most profitable products, discrepancies between sales and profit, and possible causes, such as logistics costs or promotional activity.
Summary and Reflection (5 min)
The lecturer emphasises that even a very short data analysis can support managerial decisions if it is properly focused. Students answer a reflective question about the risk of making decisions based on a single indicator.