←BaldanAll skillsLet's talk

Skill 03 · Data Analytics & BI

Questions in, decisions out.

Analytics is the path from a business question to a decision people can act on: model the data, query it, chart it, and say what it means.

SQLData modellingPower BITableauExcelPythonStorytelling
Open the dashboards

One case, start to finish

From 541,909 raw rows to one dashboard.

Every square is real data from the Online Retail file. Scroll and watch it get checked, cleaned, modelled, added up and turned into the dashboard that answers the question.

Online Retail · sales overview2010-12-01 → 2011-12-09Net revenue£9.77mOrders19,773Customers4,334Countries38Net revenue by monthDecFebAprJunAugOctNovDecWhere it sellsUK 85% · outside the UK:NetherlandsIrelandGermanyFranceAustraliaTop productsRegency cakestand 3 tierParty buntingWhite hanging heart t-light hoJumbo bag red retrospotRabbit night lightWhen orders come inMonTueWedThuFriSatSunonline_retail.xlsx541,909 rows × 8 columns · each square ≈ 1,505 rowsInvoiceNoStockCodeDescriptionQuantityInvoiceDateUnitPriceCustomerIDCountry5,268 duplicates9,288 cancellations2,512 zero price or qty2,310 postage & fees135,080 no customer ID (kept)541,909 → 522,568−19,341 rows (3.6%), one written rule at a timefct_sales522,568 clean sales linesdim_product3,912 productsdim_country38 countriesdim_dateone row per daydim_customer4,334 (counted only)Net revenue by montheach square ≈ £28k of net revenue (sales minus cancellations)Dec ’10Jan ’11FebMarAprMayJunJulAugSepOctNovDecNovember: £1.43m, +34% on October9 days onlySep +44% on Aug, then up to November→ Christmas stock should be in by the end of August

Explore

Every part of the job, one page each.