LEARNING ACTIVITIES · ASSESSMENT
Quizzes & Tests
Each chapter includes five automatically scored multiple-choice questions and two written business cases for guided self-review.
How scoring works
Answer all five MCQs, then select “Check answers” to see your score and explanations. Written cases reveal model guidance but do not count toward the numeric mark. The final chapter includes a separate scored calculation test.
CHAPTER 1.1 · KNOWLEDGE CHECK
Introduction to Data Analytics
5 scored MCQs + 2 guided cases
1. Which form of analytics primarily summarizes what has already happened?
2. A retailer investigates why September revenue decreased. What type of question is this?
3. An analyst estimates demand next month using historical orders. This is primarily…
4. Which role normally focuses most strongly on defining business requirements with stakeholders?
5. A system compares several staffing schedules under constraints to recommend an option. This is…
Written business case 1. A retail director wants a factual account of last month, an explanation of falling orders, a sales forecast and a choice between two promotions. Map the four analytics approaches to these requests.
Model guidance: Descriptive: summarize last month. Diagnostic: investigate lower order counts. Predictive: forecast sales under stated assumptions. Prescriptive: compare feasible promotion options and trade-offs.
Written business case 2. A manager asks for the difference between data analyst, business analyst and data scientist. Provide one responsibility and one common output for each.
Model guidance: Data analyst: explores data and communicates performance, often a reconciled report. Business analyst: elicits requirements and maps decisions/processes, often a requirements brief. Data scientist: builds and evaluates statistical/ML models when needed, often a model assessment or forecast.
Not attempted
CHAPTER 1.2 · KNOWLEDGE CHECK
Business Problem Solving
5 scored MCQs + 2 guided cases
1. Which is the best business problem statement?
2. Which discovery question is least leading?
3. What does the M in SMART commonly mean?
4. “Customer IDs are unavailable to the project team” is a…
5. Which is a verifiable acceptance criterion?
Written business case 1. Write a decision-focused problem statement for the 20% revenue decline without assuming its cause.
Model guidance: Investigate the August–September 2026 revenue decrease across online and store channels, quantify the largest contributors, validate reporting definitions, and recommend two testable next investigations.
Written business case 2. List one objective, one assumption, one constraint and one measurable acceptance criterion for the retail case.
Model guidance: Objective: reconcile the two months and identify major segment contributions. Assumption: online traffic events are comparable. Constraint: no access to identifiable customer histories. Acceptance: total net revenue ties to approved finance figures and caveats are documented.
Not attempted
CHAPTER 1.3 · KNOWLEDGE CHECK
Understanding Business Data
5 scored MCQs + 2 guided cases
1. A file of event records containing nested objects is commonly…
2. What does table granularity describe?
3. An order ID containing digits should usually be treated as…
4. An order header joins to three order lines. What is the main risk of summing header revenue?
5. Which quality dimension asks whether required fields are populated?
Written business case 1. Classify a sales CSV, nested checkout JSON events and free-text customer emails. Explain one practical use of each.
Model guidance: Sales CSV: structured, for aggregation. Nested event JSON: semi-structured, for parsing process events. Free-text emails: unstructured, for qualitative theme analysis.
Written business case 2. An order header has one row per order and an order-line table has multiple rows per order. Describe the grain and the join risk.
Model guidance: Order-header grain: one order. Order-line grain: one product line within an order. Joining can repeat order-header revenue, so calculate at an agreed grain and avoid fan-out double counting.
Not attempted
CHAPTER 1.4 · KNOWLEDGE CHECK
KPIs and Business Metrics
5 scored MCQs + 2 guided cases
1. Revenue is ₹8,00,000 and cost of goods sold is ₹5,60,000. Gross profit is…
2. Revenue drops from ₹10,00,000 to ₹8,00,000. Month-on-month growth is…
3. Online orders are 220 and website sessions are 6,000. Session conversion is approximately…
4. Which retention denominator fits a starting-cohort definition?
5. A conversion rate changes from 5% to 3.67%. The absolute change is…
Written business case 1. Write the formulas for gross margin, online conversion and cohort retention. Specify the denominator of each.
Model guidance: Gross margin = (net revenue − COGS)/net revenue. Online session conversion = online completed orders/eligible sessions. Cohort retention = starting customers still active/starting customers. Multiply each by 100%.
Written business case 2. Online orders fell from 300 to 220 while sessions stayed at 6,000. Describe the change without claiming a cause.
Model guidance: Conversion fell from 5.00% to about 3.67%, a drop of about 1.33 percentage points. Tracking definitions and other contextual factors must be checked before making causal claims.
Not attempted
CHAPTER 1.5 · KNOWLEDGE CHECK
Analytics Methodology
5 scored MCQs + 2 guided cases
1. What should happen before selecting a forecasting algorithm?
2. CRISP-DM is best described as…
3. Which is a useful pre-publication quality gate?
4. Why document cleaning steps?
5. Online conversion declined. Which statement is most defensible?
Written business case 1. Describe the analytics stages for investigating Meridian Retail and nominate two quality gates.
Model guidance: Understand decision; source sales and traffic; inspect grain and quality; prepare; compare channel performance; validate against finance and tracking; communicate caveated actions. Quality gates: unique order IDs and reconciliation to finance totals.
Written business case 2. A duplicated order changes revenue by ₹2,000. Explain how to handle the issue professionally.
Model guidance: Record the exception, confirm source and business rules, decide whether deduplication is appropriate, document the transformation, reconcile the corrected totals and seek review before publication.
Not attempted
CHAPTER 1.6 · KNOWLEDGE CHECK
Communication Fundamentals
5 scored MCQs + 2 guided cases
1. Which is a direct observation?
2. Which chart is generally appropriate for comparing two channels?
3. A strong executive brief typically begins with…
4. A recommendation is most actionable when it identifies…
5. Which statement handles uncertainty correctly?
Written business case 1. Convert “Online revenue dropped ₹1,60,000” into a careful insight and recommendation.
Model guidance: Insight: online accounted for 80% of the total ₹2,00,000 decline, making it a priority for investigation. Recommendation: validate funnel tracking and examine checkout errors before selecting an intervention.
Written business case 2. Write a two-sentence executive brief, including one caveat and one owner-driven next action.
Model guidance: September net revenue fell 20%, with 80% of the decrease attributable to online; this is a descriptive contribution, not proof of cause. Analytics engineering should verify session tracking by Wednesday, followed by an e-commerce review of checkout and availability data.
Not attempted
MODULE-END · SCORED PRACTICAL
Retail analysis calculation test
Three numeric calculations. Each correct answer earns one point, independently of the MCQ scores.
1. Revenue decreased from ₹10,00,000 to ₹8,00,000. What is the month-on-month growth rate (%)?
2. Online fell by ₹1,60,000 while total sales fell by ₹2,00,000. What percent of the total decline came from online?
3. Online completed 220 orders out of 6,000 eligible sessions in September. What is the conversion rate (%)? Round to two decimals.