ICDL Data Analytics (ICDL) case studies
ICDL Data Analytics · Put your knowledge to work in context.
ICDL Data Analytics is a professional-level certification in the ICDL programme, the digital-competence framework run by the ICDL Foundation, which describes itself as "a global social enterprise committed to raising standards of digital competence in the workforce, education and society." ICDL certification is available in more than 100 countries through a network of more than 20,000 testing centres. Data Analytics belongs to the ICDL PROFESSIONAL stream, which ICDL positions as "professional digital skills for occupational effectiveness" - that is, skills you apply on the job rather than general computer literacy. The ICDL Data Analytics case studies are 5 cases and about 3,439 words.
1The compost promotion that might not be a success
A regional garden-centre chain ran a three-week '20% off all potting compost' promotion in all eight of its stores in March. Compost sales rose 34% versus February.
664 words, about 3 min2Merging CRM and till exports before a finance review
You must build a 'customer spend' table by combining a CRM export (14,200 customer rows) with a till-system transaction export (63,400 rows) for the finance team's quarterly review. Known issues: CRM emails are inconsistently cased with trailing spaces; 620 CRM rows share an email with another row under a different customer ID; 1,900 transactions carry a customer ID that is absent from CRM (the tills allow guest checkout); transaction amounts are stored as text with a currency symbol, and about 400 of those rows use a comma as the decimal separator; 11% of CRM rows have a blank postcode.
720 words, about 4 min3An A/B test that neither arm clearly wins
An online course platform tested a redesigned checkout page. Control: 12,400 visitors, 298 purchases (2.40%).
705 words, about 4 min4An executive dashboard that 'feels misleading'
You inherit a monthly executive dashboard built by a departing analyst. Slide 1 is a pie chart of revenue across 11 product categories, the smallest of which is 1.2% of revenue.
700 words, about 4 min5Churn rising while every plan improves
A subscription business reports that overall monthly churn rose from 4.1% in Q1 to 4.8% in Q2. The board pack headline reads 'churn worsening'.
650 words, about 3 min