Advanced Certification Programme
in Data Science Business Analytics
Week 2
Data Analysis
Using R
Topics Covered
• Retail Sales Data Analysis
• Data Manipulation and Visualisation
• Time Series Analysis of Sales
• Sales Distribution by Country
• Product Performance Analysis
• Sales Analysis by Quantity Sold
• Customer Segmentation
• Sales Performance by Product Category
• Month-Wise Sales Distribution
• Customer Purchasing Patterns
• Q&A
Retail Sales Data Analysis
Key Transaction Metrics for Business Insights
Column Description
Invoice number Unique ID for each transaction
Invoice date Date and time of transaction
Customer ID Unique ID for each customer
Description Product details
Quantity Items sold per transaction
Unit price Price per unit
Total price Quantity × Unit price
Country Transaction location
Data Manipulation and Visualisation
Practical Data Applications
• Learn to manipulate and visualise retail sales data using R
• Create effective visualisations for better data interpretation
• Focus on data cleaning, aggregation and generating insights
Data Manipulation and Visualisation
Import Libraries and Load Data
Data Manipulation and Visualisation
Data Processing in R
Time Series Analysis of Sales
Identifying Trends for Smarter Business Decisions
• Use insights to optimise inventory and marketing strategies
• Analyse sales trends over time for better decision-making
Sales Distribution by Country
Understand Regional Sales Patterns
• Visualise total price distribution using a box plot by country
• Identify key target markets and expansion opportunities
• Evaluate sales performance across various countries
Product Performance Analysis
Maximise Sales Through Product Insights
• Determine best-selling products for better inventory management
• Analyse product performance to refine marketing strategies
Sales Analysis by Quantity Sold
Measuring Performance Through Sales Volume
• Examine how quantity sold affects total sales performance
• Identify trends to improve pricing and promotions
• Use visual analysis to uncover sales patterns
Customer Segmentation
Understand Spending Patterns for Targeted Marketing
• Examine customer spending habits to refine marketing strategies
• Segment customers based on total sales data for better engagement
• Identify key consumer groups to enhance customer loyalty
Sales Performance by Product Category
Analyse Product Categories for Better Inventory Management
• Categorise products to evaluate sales trends across different categories
• Assess category-wise sales data to improve stock management
Month-wise Sales Comparison
Evaluate Sales Trends Across Countries Over Time
• Compare sales performance across different countries over months
• Identify trends to support data-driven strategic decisions
Customer Purchasing Patterns
Identify High-Value Customers Through Purchase Analysis
• Analyse average purchase values per customer
• Identify high-value customers for targeted marketing strategies
Save all plots to files (optional)
Export Visualisations for Future Reference
Q&A
Thank you