business analytics

What is Business Analytics? #

Business Analytics is the process of using data, statistics, and tools to make business decisions.

It helps businesses:

• Improve performance
• Increase revenue
• Understand customers
• Optimize operations

Types of Business Analytics #

What is Sales Analysis? #

Sales analysis is the process of evaluating sales data to understand performance and trends.

Key Metrics in Sales Analysis #

Example Dataset #

import pandas as pd

data = {
    "Product": ["A", "B", "C", "A", "B"],
    "Sales": [100, 200, 150, 300, 250],
    "Region": ["East", "West", "East", "West", "East"]
}

df = pd.DataFrame(data)

Basic Sales Analysis Code #

Total Sales #

total_sales = df["Sales"].sum()
print("Total Sales:", total_sales)

Sales by Product

sales_by_product = df.groupby("Product")["Sales"].sum()
print(sales_by_product)

Sales by Region

sales_by_region = df.groupby("Region")["Sales"].sum()
print(sales_by_region)

Insights You Can Get #

• Which product sells the most
• Which region performs best
• Sales trends over time

Helps in:

• Inventory planning
• Marketing strategies
• Pricing decisions

Customer Behavior Analysis #

What is Customer Behavior Analysis? #

It is the process of understanding how customers interact with a business.

Focus:

• Buying patterns
• Preferences
• Engagement

Key Metrics #

Example Dataset #

data = {
    "Customer": ["Alex", "John", "Emma", "Alex", "Emma"],
    "Purchase": [100, 200, 150, 300, 250]
}

df = pd.DataFrame(data)

Basic Customer Analysis Code #

Total Spending per Customer #

customer_spending = df.groupby("Customer")["Purchase"].sum()
print(customer_spending)

Purchase Frequency

purchase_freq = df["Customer"].value_counts()
print(purchase_freq)

Insights You Can Get #

• High-value customers
• Frequent buyers
• Customer preferences

Helps in:

• Targeted marketing
• Personalization
• Customer retention strategies

Sales vs Customer Behavior #

Simple Workflow #

1. Collect sales & customer data
2. Clean and prepare data
3. Analyze sales metrics
4. Analyze customer behavior
5. Generate insights
6. Make business decisions