6 min read

    🧠 Business Intelligence, Analytics, AI & ML

    datawarehousebianalyticsaiml

    🧠 Business Intelligence (BI)

    Analogy

    Think of a cricket team. Raw data = every ball bowled. BI = the scoreboard, stats, and match reports that help the coach make decisions.

    BI is the process of collecting raw business data, transforming it, and presenting it as meaningful information to help managers and executives make better decisions.

    Steps in BI

    1. Data Collection β€” gather data from sources (databases, CRMs, ERPs)
    2. Data Storage β€” store it in a Data Warehouse or Data Mart
    3. Data Processing β€” clean and transform via ETL & ELT|ETL
    4. Data Analysis β€” run queries, reports, dashboards
    5. Data Visualization β€” present via tools like Power BI, Tableau
    6. Decision Making β€” business acts on the insights
    Tip

    BI answers "What happened?" β€” it's backward-looking (historical data).


    πŸ“Š Analytics

    Analytics goes beyond BI β€” it not only describes what happened but also predicts what will happen.

    TypeQuestion AnsweredExample
    DescriptiveWhat happened?Sales dropped 20% last month
    DiagnosticWhy did it happen?Discount campaign ended
    PredictiveWhat will happen?Sales will rise 15% next quarter
    PrescriptiveWhat should we do?Run a targeted offer campaign
    Tip

    BI β‰ˆ Descriptive + Diagnostic. Analytics pushes into Predictive + Prescriptive.


    πŸ€– Artificial Intelligence (AI)

    AI is the ability of machines to simulate human intelligence β€” reasoning, learning, problem-solving.

    Analogy

    A human learns from experience. AI does the same β€” but with data instead of life events.

    AI is the umbrella term. Everything below (ML, Deep Learning) lives inside AI.

    AI
    └── Machine Learning (ML)
        └── Deep Learning (DL)
    

    🧬 Machine Learning (ML)

    ML is a subset of AI where machines learn patterns from data without being explicitly programmed.

    Analogy

    You don't teach a child every dog breed by name. You show them 1000 pictures of dogs. They learn the pattern. That's ML.

    Types of ML


    1️⃣ Supervised Learning

    The model is trained on labelled data (input + correct output).

    • Classification β€” output is a category
      Input: Email text β†’ Output: Spam / Not Spam
      Input: Tumor scan β†’ Output: Malignant / Benign
      
    • Regression β€” output is a number
      Input: House size, location β†’ Output: Price (β‚Ή)
      Input: Hours studied β†’ Output: Exam score
      
    Tip

    Labelled = you already know the answer. You're teaching the model using past correct examples.


    2️⃣ Unsupervised Learning

    The model is trained on unlabelled data β€” it finds hidden patterns on its own.

    • Clustering β€” group similar things together
      Customer data β†’ Group into: Budget buyers, Premium buyers, Occasional buyers
      
    • Association β€” find rules between items
      Supermarket data β†’ "People who buy bread also buy butter" (Market Basket Analysis)
      
    Tip

    No right answer given. The model discovers structure by itself.


    3️⃣ Semi-supervised Learning

    Mix of both β€” small labelled data + large unlabelled data.

    Example: Only 500 labelled medical images + 50,000 unlabelled images.
    Model uses both to learn better than using only 500 labelled images.
    
    Info

    Used when labelling data is expensive or time-consuming (e.g., medical imaging, legal documents).


    4️⃣ Reinforcement Learning (RL)

    The model learns by trial and error β€” gets rewards for good actions, penalties for bad ones.

    Example: AlphaGo (chess-like game AI)
             Self-driving car (reward = safe driving, penalty = crash)
             Robot learning to walk
    
    Analogy

    Like training a dog. Good behaviour β†’ treat. Bad behaviour β†’ no treat. Over time it learns what to do.


    πŸ”¬ Deep Learning (DL)

    Deep Learning is a subset of ML that uses neural networks with many layers to learn from massive amounts of data.

    Analogy

    ML can recognize a cat from structured features (fur, ears, tail). Deep Learning looks at raw pixels and figures it out itself β€” like a human brain's visual cortex.

    Where Deep Learning shines:

    Use CaseExample
    Image recognitionFace unlock on your phone
    Natural Language ProcessingChatGPT, Google Translate
    Speech recognitionAlexa, Siri
    Video analysisYouTube recommendations
    Warning

    Deep Learning needs massive data and high compute (GPUs). It's overkill for small datasets β€” use regular ML instead.


    πŸ—ΊοΈ Full Picture

    AI  ──────────────────────────────────────────
    β”‚
    β”œβ”€β”€ Machine Learning
    β”‚   β”œβ”€β”€ Supervised     β†’ Classification, Regression
    β”‚   β”œβ”€β”€ Unsupervised   β†’ Clustering, Association
    β”‚   β”œβ”€β”€ Semi-supervised
    β”‚   └── Reinforcement Learning
    β”‚
    └── Deep Learning (subset of ML, needs big data + GPU)
    

    πŸ§ͺ Practice Drill

    text
    // Try answering these:
    // Q1. A bank wants to predict whether a loan applicant will default or not. Which type of ML is this?
    // Q2. An e-commerce platform groups customers based on purchase behavior without any predefined labels. Which type of ML is this?
    // Q3. A game AI learns to win by playing millions of matches and getting a score for each win. Which type of ML is this?
    // Q4. What's the difference between BI and Analytics in one line each?
    // Q5. Arrange these from broadest to most specific: `Deep Learning`, `AI`, `Machine Learning`
    
    πŸ’‘ Click for Solutions

    A1. Supervised Learning β€” Classification (output is a category: Default / Not Default)

    A2. Unsupervised Learning β€” Clustering (no labels, grouping by pattern)

    A3. Reinforcement Learning (reward = win score, learns by trial and error)

    A4.

    • BI β†’ "What happened?" (historical, backward-looking)
    • Analytics β†’ "What will happen / what should we do?" (forward-looking, predictive)

    A5. AI β†’ Machine Learning β†’ Deep Learning


    ← Previous Topic | Next Topic β†’ Next Topic