E-Commerce & Data – Unit Notes
1. E-Commerce Scope
Meaning: Scope means areas where e-commerce is used.
• Online shopping
• Online banking
• Online education
• Digital marketing
• Ticket booking
• Example: Buying from Amazon, paying via UPI
2. Concept of CRM in E-Business
Meaning: CRM (Customer Relationship Management) manages customer data and relationships
using technology.
• Customer data storage
• Personalized offers
• Customer support
• Example: Amazon recommends products based on your history
3. Emerging E-Commerce
New and modern ways of online business.
• Mobile commerce (apps)
• Social commerce (Instagram selling)
• AI-based recommendations
• Subscription models
• Example: Swiggy, Netflix
4. Technology in E-Business
Technologies used make business fast, smart, and efficient.
• Internet
• Cloud Computing
• AI & Machine Learning
• Big Data
• Mobile Apps
5. Cyber Security: Threats & Solutions
Threats:
• Hacking
• Data theft
• Phishing
• Viruses
5. Cyber Security: Solutions
• Encryption
• Firewalls
• Antivirus
• Secure payment gateways
• Example: OTP verification
6. Payment Platforms / Options
• UPI
• Debit/Credit Card
• Net Banking
• Wallets (Paytm, PhonePe)
• Cash on Delivery
• These make payments easy and fast
7. Challenges & Ethical Issues in Digital Economy
Challenges:
• Security issues
• High competition
• Technology cost
• Digital divide
7. Ethical Issues
• Data privacy
• Fake reviews
• Online fraud
8. OLTP (Online Transaction Processing)
Meaning: System for daily transactions.
• Examples: Billing system, ATM transactions
• Fast
• Real-time
9. Data Cleaning
Meaning: Removing errors from data.
• Removing duplicate entries
• Fixing wrong data
• Clean data = Better results
10. Data Warehouse Architecture
Layers:
• Staging – Raw data collected
• Integration – Data cleaned & combined
• Access – Data used for reports
11. KDD (Knowledge Discovery in Database)
Meaning: Process of finding useful knowledge from data.
• Data Selection
• Cleaning
• Transformation
• Data Mining
• Interpretation
12. ETL Process
ETL = Extract, Transform, Load
• Extract – Collect data
• Transform – Clean & organize
• Load – Store in warehouse
13. Data Integration
Combining data from multiple sources.
• Example: Sales + HR + Finance data together
14. Metadata Management
Data about data.
• Data source
• Format
• Type
15. Data Quality in Data Warehouse
Good data should be:
• Accurate
• Complete
• Consistent
15. Methods to Improve Data Quality
• Data cleaning
• Validation
• Removing duplicates
16. EDW (Enterprise Data Warehouse)
Large data warehouse for whole company.
• Stores all data
• Used for decision making
17. Methods to Improve Data Quality (Additional)
• Data validation
• Data cleaning
• Standardization
• Removing duplicate data
• Regular updates
Final Conclusion
This unit explains how online business works (E-commerce), how data is stored (Data Warehouse),
and how data is analyzed (Data Mining/KDD).
These help in better decisions, business growth, and customer satisfaction.
Super Short Revision
• CRM = Manage customers
• OLTP = Daily transactions
• ETL = Data processing
• KDD = Knowledge discovery
• EDW = Full company data