Basics of Data Analytics for Business Students – Lecture Notes
Week 1: Introduction to Analytics
- Definition: Data Analytics involves collecting, cleaning, transforming, and modeling data to discover insigh
- Types: Descriptive, Diagnostic, Predictive, Prescriptive Analytics.
Week 2: Data Sources & Cleaning
- Internal: ERP, CRM, POS systems.
- External: Market data, social media, sensors.
- Common Cleaning Techniques: Removing duplicates, standardizing formats, dealing with missing data.
Week 3: Visualization and Interpretation
- Tools: Power BI, Tableau, Excel.
- Choosing the right chart:
- Line: Trend
- Bar: Comparison
- Pie: Proportion
- Scatter: Correlation
- Avoid bias: Always check data context before drawing conclusions.
Week 4: Business Use Cases
- Retail: Demand forecasting using regression.
- Supply Chain: Inventory optimization via simulation.
- Marketing: Customer segmentation through clustering.